Checking for duplicate keys
The team is debating whether or not two datasets can be joined. The question comes down to whether or not each data frame has a unique set of one or more key columns.
You'll be going back to two data frames from before, game_matchups
and punts
. In an earlier exercise you determined there was a one-to-many relationship between the data frames.
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.
# View first 5 rows of game_matchups and check key columns
print(____.head())
____('Duplicate keys:', game_matchups.____('GameKey').sum())