Hands-On Exploratory Data Analysis with Python

Resampling time series data

It is often required to resample the dataset at lower or higher frequencies. This resampling is done based on aggregation or grouping operations. For example, we can resample the data based on the weekly mean time series as follows:

1. We can use the code given here to resample our data:

columns = ['Consumption', 'Wind', 'Solar', 'Wind+Solar']power_weekly_mean = df_power[columns].resample('W').mean()power_weekly_mean

The output of the preceding code is given here:

As shown in the preceding screenshot, the first row, labeled 2006-01-01, includes the average of all the data. We can plot the daily and weekly time series ...