Combining time series
You recently read a paper showing positive correlation of game weather with player injuries. You decide to see if concussions and average temperatures for games follow the same pattern. Game temperatures have been stored in csv files and - of course - there is one file per team. You load files for Cleveland and Dallas to get an idea of how the seasons change for different teams.
temps_cle
and temps_dal
are show on your screen.
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.
# Merge data and view first 10 rows
temps = pd.____(____, ____, on='Game_Date',
suffixes=[____, '_DAL'])
print(temps.head(10))