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.
This exercise is part of the course
Pandas Joins for Spreadsheet Users
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# View data frames
print(____.head())
print(____.head())