Exercise

Replicating VLOOKUP

Thursday night games are relatively new to the league. The Health and Safety group wants to look at concussions occurring on Thursday night games to get a sense of what's happening. Of course, game data and impact data are kept in separate files.

In a spreadsheet environment, you would almost certainly join the tables with VLOOKUP or INDEX-MATCH. The pandas.merge() function seems like a good fit here. Your team has already prepared two data frames, thursdays and impacts.

Health and Safety wants to see two different views of the joined data: one view oriented on impacts and one view oriented on Thursdays.

Instructions 1/3

undefined XP
    1
    2
    3
  • View the first 5 lines of each data frame.