4.2. Data CleanΒΆ

To reshape the data from the previous page to make it suitable for analysis, we do the following:

  1. Extract years and months from the date columns.

  2. Join data together.

  3. Recast the data types.

  4. Group and aggregate the rows to get counts.

  5. Calculate crime rates.

  6. Lower case and replace white-space with underscore characters.

  7. Remove duplicates.

  8. Remove NAs.

The scripts for cleaning and reshaping the data can be found in the book by un-hiding the code and also in the Python scripts found in the src/make_data/ directory of the repository.

4.1. Viewing the data 5. Exploratory Data Analysis