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.
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.
This exercise is part of the course
Pandas Joins for Spreadsheet Users
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Create data frame for stadiums and view
____ = pd.read_csv(____)
print(stadiums.head(5))