Looking at data with print()
Now that we have your movies and theater data loaded into Python, what does this data even look like?
By using the print() function, we'll be able to look at the ticket sales data in its entirety. Notice how this 'view' of ticket sales data is the number of tickets sold for each movie in each theater location. Each row is an observation of a single movie at a single theater's location.
This exercise is part of the course
Python for Spreadsheet Users
Exercise instructions
- Use
pd.read_excel()to load inticket_sales.xlsxand assign the result tosales. - Use the
print()function to display thesalesdata in the console.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import the pandas package as pd
import pandas as pd
# Load file and assign the data to sales
# Print sales
____(____)