Sanket
0
Q:

how i resamplae a datetime column in python

>>> d = dict({'price': [10, 11, 9, 13, 14, 18, 17, 19],
...           'volume': [50, 60, 40, 100, 50, 100, 40, 50]})
>>> df = pd.DataFrame(d)
>>> df['week_starting'] = pd.date_range('01/01/2018',
...                                     periods=8,
...                                     freq='W')
>>> df
   price  volume week_starting
0     10      50    2018-01-07
1     11      60    2018-01-14
2      9      40    2018-01-21
3     13     100    2018-01-28
4     14      50    2018-02-04
5     18     100    2018-02-11
6     17      40    2018-02-18
7     19      50    2018-02-25
# try below code when you want resample on datetime column to other all columns in dataframe
>>> df.resample('M', on='week_starting').mean() 
               price  volume
week_starting
2018-01-31     10.75    62.5
2018-02-28     17.00    60.0
0

New to Communities?

Join the community