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.
Diese Übung ist Teil des Kurses
Pandas Joins for Spreadsheet Users
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
# Create data frame for stadiums and view
____ = pd.read_csv(____)
print(stadiums.head(5))