Merging on two or more keys
You want to combine data for the plays occurring in each game. You have two data frames with different aspects of the plays. The frames are called play_times and play_yards.
The first 10 rows of each frame appear in your console. It looks like both frames use GameId and PlayId together to identify unique plays.
Diese Übung ist Teil des Kurses
Pandas Joins for Spreadsheet Users
Anleitung zur Übung
- Merge the data frames using the appropriate key column(s).
- Check for duplicated key values using the
.duplicated()and.sum()methods.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
# Merge data frames
plays = ____(play_times, ____, on=[____, ____])
# Check for duplicated values in key columns
plays.____(['GameId', 'PlayId']).____()