[Python] 엑셀 파일 불러오기 - ExcelFile, data.iterrows

1. 특정 시트

--

import pandas as pd
 
def readExel(xlse_path, sheetName):
    xls_file = pd.ExcelFile(xlse_path)
    data = xls_file.parse(sheetName)
    return data
 
data = readExel('/Users/aaron/Desktop/test/testExcel.xlsx', 'Sheet')
 

2. 전체 시트

--

import pandas as pd
 
xls = pd.ExcelFile('/Users/aaron/Desktop/testExcel.xlsx')
sheets = xls.sheet_names
 
sh1 = xls.parse(sheet_name="Sheet1")
sh2 = xls.parse(sheet_name="Sheet2")
sh3 = xls.parse(sheet_name="Sheet3")

3. 시트 한 행씩 읽기

--

for i, row in data.iterrows(): 
   print(i, row)