Comment by srean

That's where you need time series models. Take a look at linear filters and how to handle seasonal variations.

It gets interesting when there are different frequencies at play simultaneously, like in your example -- day of the week and time of day effects. If their periods are mutually prime that's more convenient to handle as they are orthogonal in the Fourier space.

Think of these as radio AM modulation.