How to Aggregate Dates in a Pandas DataFrame Using Groupby Sum

Converting Date Data in Excel: How to Handle Incorrect Years and Days Using Pandas to_datetime()

Splitting a pandas datetime index to create a categorical variable

Accessing Minute-Level Data from Resampled Hourly Frequency in Pandas