1. Learn
    2. /
  2. Courses
    3. /
  3. Pandas Joins for Spreadsheet Users

Exercise

Matching to the nearest time

You decide to go back and look at punts as one type of dangerous play. One of your team's past challenges is that it has been hard to match play data to the timing of concussions throughout the season, especially for punts. You think pandas may be able to help here.

The data frame from your previous work, temps, is already loaded. You also have a data frame called impacts that includes the dates of each concussion occurring on punts. It also has a column showing the cumulative count of concussions for the season as of the latest occurrence. The data frames are shown on your screen.

Instructions

100 XP
  • Combine the data to see how many concussions from punts have been recorded as of each game day in temps. Plot a run chart of cumulative concussions as of Cleveland and Dallas game dates. This has already been completed for you.