Loading data
The pandas
package, which you now know how to import as pd
, has a useful function, read_excel()
, that will load in our Excel data.
The ticket_sales.xlsx
file contains data relating to ticket sales for several (fake and punny) movies at a few different theater locations. Maybe they're your theaters.
Let's get this data into Python so you can start looking at movie and location performance.
This exercise is part of the course
Python for Spreadsheet Users
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import the pandas package as pd
# Use the read_excel function to load ticket_sales.xlsx
pd.____(____)