/Python/Convert excel workbook to dataframe

Convert excel workbook to dataframe

workbook = pd.ExcelFile('***.xls')
sheets = workbook.sheet_names

df = pd.concat([pd.read_excel(workbook, sheet_name=s)
                .assign(sheet_name=s) for s in sheets])

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
Django auto increment field
Python Django
0 vote104 views1 answer
%%writefile
Python
2 votes133 views1 answer
And condition with or in django
Python Django
-1 vote100 views1 answer
Python curses resize window
Python
0 vote135 views1 answer
Printing multiple input in python
Python
1 vote103 views1 answer
Data Compression in python
Python
0 vote102 views1 answer
Python pynput letter key pressed
Python
0 vote103 views1 answer
Check if a date is reached django
Python
0 vote135 views1 answer
Django fixtures. To loaddata
Python Django
10 votes97 views1 answer
Dataframe copy
Python