1. Learn
  2. /
  3. Courses
  4. /
  5. Pandas Joins for Spreadsheet Users

Exercise

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.

Instructions

100 XP
  • 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.