Bekerja dengan beberapa sheet

Python untuk Pengguna Spreadsheet

Chris Cardillo

Data Scientist

Sebelumnya

# Import package
import pandas as pd

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

# Print to console
print(fruit)

dataset buah sederhana lengkap.png

Sebelumnya

satu sheet buah lebih baik.png

Dua tab

tab price

tab harga buah.png

tab color

tab warna buah.png

pd.ExcelFile()

# Import package
import pandas as pd

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

pd.ExcelFile()

# Import package
import pandas as pd

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

# Print to console
print(fruit_workbook)

objek file excel.png

Attribute

Hidup dalam objek, seperti method
Diakses dengan titik
Tanpa tanda kurung

Attribute .sheet_names

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

Attribute .sheet_names

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

# Get sheet names
fruit_sheet_names = fruit_workbook.sheet_names

Attribute .sheet_names

# 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)

nama sheet buah.png

Attribute vs. method

Attribute

object.attribute
workbook.sheet_names
Memberi informasi

Method

object.method()
workbook.parse()
Melakukan sesuatu

Attribute vs. method

Attribute

object.attribute
workbook.sheet_names
Memberi informasi
Selalu melekat pada objek!

Method

object.method()
workbook.parse()
Melakukan sesuatu
Selalu melekat pada objek!

Attribute vs. method vs. fungsi

Attribute

object.attribute
workbook.sheet_names
Memberi informasi
Selalu melekat pada objek!

Fungsi

function() atau package.function()
pd.ExcelFile()

Method

object.method()
workbook.parse()
Melakukan sesuatu
Selalu melekat pada objek!

Method .parse()

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

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

Method .parse()

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

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

# Print fruit prices
print(fruit_prices)

harga buah konsol.png

Ringkasan

pd.ExcelFile() fungsi
workbook.sheet_names attribute
workbook.parse() method

Ayo berlatih!

Python untuk Pengguna Spreadsheet