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.
Bu egzersiz
Python for Spreadsheet Users
kursunun bir parçasıdırEgzersiz talimatları
- Use your new
ExcelFile()function to read intheater_report.xlsxand assign the result totheater_report. - Print the workbook object.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Read in the whole workbook
# Print the workbook
print(____)