Vivian
4/5/2019 - 9:10 AM

Read multiple files

# read multiple files and store them in a dictionary 'sheets'
wb = pd.ExcelFile('./data.xlsx')
sheets = {}
for name in wb.sheet_names:
    sheets[name] = pd.read_excel(wb, name)

# access dataset
sheet.get('sheet_name')