Get startedGet started for free

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

View Course

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()
Edit and Run Code