The raw Denver crime dataset is huge with over 460,000 rows each marked with a reported date. Counting the number of weekly crimes is one of many queries that can be answered by grouping according to some period of time. The resample method provides an easy interface to grouping by any possible span of time.
Counting the number of weekly crimes
Getting ready
In this recipe, we will use both the resample and groupby methods to count the number of weekly crimes.
How to do it...
- Read in the crime hdf5 dataset, set the index as the REPORTED_DATE, and then sort it to increase...