ComeçarComece de graça

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.

Este exercício faz parte do curso

Pandas Joins for Spreadsheet Users

Ver curso

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

# View data frames
print(____.head())
print(____.head())
Editar e executar o código