Jun-20-2018, 10:09 PM
I have a 'dates' column and a 'tmax' (temperature values) column. I want to create one another column that shows each month's average in each year. I tried
Sample values are below:
date tmax
1-Jan-80 15.773
2-Jan-80 18.342
...
30-Jan-80 15.851
31-Jan-80 11.962
...
1-Dec-80 15.773
2-Dec-80 18.342
...
30-Dec-80 15.851
31-Dec-80 11.962
1-Jan-81 15.773
2-Jan-81 18.342
...
30-Jan-81 15.851
31-Jan-81 11.962
...
1-Dec-2015 15.773
2-Dec-2015 18.342
...
30-Dec-2015 15.851
31-Dec-2015 11.962
df['date']=pd.date_range(start='1/01/1980', end='31/12/2015') #df['date'] = df['date'].dt.strftime('%d-%b-%Y') format of date df['means'] = df.resample('M', on='date').mean()I have got
ValueError: Wrong number of items passed 4, placement implies 1
Sample values are below:
date tmax
1-Jan-80 15.773
2-Jan-80 18.342
...
30-Jan-80 15.851
31-Jan-80 11.962
...
1-Dec-80 15.773
2-Dec-80 18.342
...
30-Dec-80 15.851
31-Dec-80 11.962
1-Jan-81 15.773
2-Jan-81 18.342
...
30-Jan-81 15.851
31-Jan-81 11.962
...
1-Dec-2015 15.773
2-Dec-2015 18.342
...
30-Dec-2015 15.851
31-Dec-2015 11.962