Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- sheet_names =['orange','banana','grape']
- xlsx = pd.ExcelFile('C:\Users\ken\Desktop\Df.xlsx')
- df = []
- for x in sheet_names:
- df.append(xlsx.parse(sheetname=x,index_col=0,parse_cols='B:F'))
- print df
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement