Working with split data
Your team wants to use data from the 2016 and 2017 seasons. The game data is stored in a spreadsheet file with each season on a separate sheet.
This is a perfect chance to start building pandas muscles! You'll use pandas
to look at each season of data and see if they can be joined into one data frame. A coworker has already imported the pandas
package into the code environment as "pd" and saved each sheet to csv files. The files are called games_2016.csv
and games_2017.csv
.
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.
# Create data frame for 2016
games_2016 = pd.read_csv(____)