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.
Cet exercice fait partie du cours
Pandas Joins for Spreadsheet Users
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.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de 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()