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

Exercise

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.

Instructions 1/2

undefined XP
  • 1
    • Combine the data by the time-series column, Game_Date. Use suffixes of '_CLE' and '_DAL'. View the first 10 rows.
  • 2
    • Use a forward fill for missing temperature values and merge the data again. View the first 10 rows.