1. Learn
    2. /
  2. Courses
    3. /
  3. Analyzing Police Activity with pandas

Exercise

Preparing the DataFrames

In this exercise, you'll prepare the traffic stop and weather rating DataFrames so that they're ready to be merged:

  1. With the ri DataFrame, you'll move the stop_datetime index to a column since the index will be lost during the merge.
  2. With the weather DataFrame, you'll select the DATE and rating columns and put them in a new DataFrame.

Instructions

100 XP
  • Reset the index of the ri DataFrame.
  • Examine the head of ri to verify that stop_datetime is now a DataFrame column, and the index is now the default integer index.
  • Create a new DataFrame named weather_rating that contains only the DATE and rating columns from the weather DataFrame.
  • Examine the head of weather_rating to verify that it contains the proper columns.