pd.ExcelFile() function
It's rare that you'll have a spreadsheet with just one tab. In this chapter, we'll use multi-tabbed workbook, theater_report.xlsx
that will give us some more details on our movie sales. Before we learn about what's in it, we've got to get it into Python.
The pandas
package has already been loaded for you as pd
to help you with this task.
This exercise is part of the course
Python for Spreadsheet Users
Exercise instructions
- Use your new
ExcelFile()
function to read intheater_report.xlsx
and assign the result totheater_report
. - Print the workbook object.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Read in the whole workbook
# Print the workbook
print(____)