Working with multiple sheets

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

Previously

# Import package
import pandas as pd

# Read file
fruit = pd.read_excel('fruit.xlsx')

# Print to console
print(fruit)

simple fruit whole dataset.png

Python for Spreadsheet Users

Previously

one sheet fruit better.png

Python for Spreadsheet Users

Two tabs

price tab

fruit price tab.png

color tab

fruit color tab.png

Python for Spreadsheet Users

pd.ExcelFile()

# Import package
import pandas as pd

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')
Python for Spreadsheet Users

pd.ExcelFile()

# Import package
import pandas as pd

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')

# Print to console
print(fruit_workbook)

excel file object.png

Python for Spreadsheet Users

Attributes

  • Live within objects, just like methods
  • Accessed with the dot
  • No parentheses required
Python for Spreadsheet Users

.sheet_names attribute

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')
Python for Spreadsheet Users

.sheet_names attribute

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')

# Get sheet names
fruit_sheet_names = fruit_workbook.sheet_names
Python for Spreadsheet Users

.sheet_names attribute

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')

# Get sheet names
fruit_sheet_names = fruit_workbook.sheet_names

# Print sheet names to console
print(fruit_sheet_names)

fruit sheet names.png

Python for Spreadsheet Users

Attributes vs. methods

Attributes
  • object.attribute
  • workbook.sheet_names
  • Tell us something
Methods
  • object.method()
  • workbook.parse()
  • Do something for us
Python for Spreadsheet Users

Attributes vs. methods

Attributes
  • object.attribute
  • workbook.sheet_names
  • Tell us something
  • Always attached to an object!
Methods
  • object.method()
  • workbook.parse()
  • Do something for us
  • Always attached to an object!
Python for Spreadsheet Users

Attributes vs. methods vs. functions

Attributes
  • object.attribute
  • workbook.sheet_names
  • Tell us something
  • Always attached to an object!

 

Functions
  • function() or package.function()
  • pd.ExcelFile()
Methods
  • object.method()
  • workbook.parse()
  • Do something for us
  • Always attached to an object!
Python for Spreadsheet Users

.parse() method

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')

# Parse price tab
fruit_prices = fruit_workbook.parse('price')
Python for Spreadsheet Users

.parse() method

# Read workbook
fruit_workbook = pd.ExcelFile('fruit_tabs.xlsx')

# Parse price tab
fruit_prices = fruit_workbook.parse('price')

# Print fruit prices
print(fruit_prices)

fruit prices console.png

Python for Spreadsheet Users

Recap

  • pd.ExcelFile() function
  • workbook.sheet_names attribute
  • workbook.parse() method
Python for Spreadsheet Users

Your Turn!

Python for Spreadsheet Users

Preparing Video For Download...