Get startedGet started for free

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

View Course

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())
Edit and Run Code