Pandas dates and events

user_9289463 0
Viewed 42

I have a dataset of datetime and specific events that occured at these times. The dataset looks like this: enter image description here

Now what I want is to have a new dataset having 2 columns. The first one is the dates with weeks frequency and the second one is how many events happened during this week from the above picture, so for example will be like this:

Dates            Events
27-12-2015       5
3 - 1-2016       6
pandas time-series python-3.x
1 Answers

Use DataFrame.resample or Grouper:

df['date_raised'] = pd.to_datetime(df['date_raised'])

df.resample('W', on='date_raised').size().reset_index(name='Events')

Or:

df.groupby(pd.Grouper(freq='W', key='date_raised')).size().reset_index(name='Events')
user_29010020
Related