Nov-29-2019, 04:21 PM
Thank you for your help.
I have a time series dataframe with hourly data distributed over a 20 years period (N = 175297):
Data A B C D
1/1/1989 0:00 12.0000 12.0000 12.0000 12.0000
...
12/31/2008 5:00 11.9678 11.9712 11.9484 11.9484
I need to compute the mean value for each day, the final series will only have 365 values.
The first value will be the mean value of:
01/01/1989,
01/01/1990,
01/01/1991,
01/01/1992,
...
01/01/2008,
The second value will be the mean value of:
01/02/1989,
01/02/1990,
01/02/1991,
01/02/1992,
...
01/02/2008,
I have tried this:
Can this be made with resample?
Thank you
I have a time series dataframe with hourly data distributed over a 20 years period (N = 175297):
Data A B C D
1/1/1989 0:00 12.0000 12.0000 12.0000 12.0000
...
12/31/2008 5:00 11.9678 11.9712 11.9484 11.9484
I need to compute the mean value for each day, the final series will only have 365 values.
The first value will be the mean value of:
01/01/1989,
01/01/1990,
01/01/1991,
01/01/1992,
...
01/01/2008,
The second value will be the mean value of:
01/02/1989,
01/02/1990,
01/02/1991,
01/02/1992,
...
01/02/2008,
I have tried this:
# Import data data = pd.read_excel('Bouca.xlsx', index_col=0, header=1).iloc[:,[0,1,2,3-1]] data.columns = ['W2R','W2L','Hostetler','Flake'] years = data.index.year W2R=data['W2R'].resample('D', how='mean') W2L=data['W2L'].resample('D', how='mean') Hostetler=data['Hostetler'].resample('D', how='mean') Flake=data['Flake'].resample('D', how='mean')With this code I can only convert from hourly data to daily data (N=7308)
Can this be made with resample?
Thank you