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.
Latihan ini adalah bagian dari kursus
Pandas Joins for Spreadsheet Users
Petunjuk latihan
- 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.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
# 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()