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

Exercise

Working with complementary data

Your team is now ready to explore data at a more detailed level. Each game in American football is made up of discrete plays with a typical game containing around 150 plays. Your spreadsheet for punt plays has data on every punt from the 2016 and 2017 seasons.

Punts spreadsheet

You want to append the data for each play with game data: home team, visiting team, etc. You already have the play data saved to punts.csv. You also have game data saved as games.csv.

Instructions 1/3

undefined XP
    1
    2
    3
  • Load data from punts.csv into a data frame called punts. Examine the first 10 rows of the data frame.