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
games
data 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()