Get startedGet started for free

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.

This exercise is part of the course

Analyzing Police Activity with pandas

View Course

Exercise instructions

  • 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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Reset the index of 'ri'


# Examine the head of 'ri'
print(____)

# Create a DataFrame from the 'DATE' and 'rating' columns


# Examine the head of 'weather_rating'
print(____)
Edit and Run Code