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.
Bu egzersiz
Pandas Joins for Spreadsheet Users
kursunun bir parçasıdırEgzersiz talimatları
- 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.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# 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()