Case study challenge - part 2
The next part of the challenge is to join play-level data to your main data frame. You have a new file, plays.csv with the play data. Your data frame from Part 1, games, is already loaded.
This exercise is part of the course
Pandas Joins for Spreadsheet Users
Exercise instructions
- Load play data and view the first 5 rows. What kind of relationship exists between games and plays?
- Merge play data into the
gamesdata frame. Keep only games included in both data frames. Also, validate your results. - Get data frame information on the resulting data frame.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load play data and view
plays = ____(____)
print(____.head())
# Merge play data into game data frame
games_plays = games.____(____, how=____, ____=____, validate=____)
# Get data frame information
____.info()