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

Exercise

One-to-many joins

You think it might be helpful to take a look at punt plays because of their potential for concussions. A typical NFL game has 8-10 punts. Here is the spreadsheet you created. punts

You'd like to join this dataset with the stadium data you previously created. It seems like a great opportunity for a one-to-many join. The datasets are saved to separate csv files, stadiums.csv and punts.csv.

This exercise is meant to provide a first glance at one-to-many joins before taking a deeper look later in the course.

Instructions 1/3

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