/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 vote270 views1 answer
Query json array
Python
0 vote271 views1 answer
Db connection string timeout
Python
0 vote258 views1 answer
Python make string one line
Python
0 vote261 views1 answer
Flatten columns after pivot pandas
Python
8 votes251 views3 answers
Pandas replace string with another string
Python
0 vote253 views1 answer
Same elements of two sets in python
Python
28 votes261 views4 answers
Seaborn figure size
Python
0 vote261 views1 answer
How to select name parent table in model laravel
Python
2 votes277 views1 answer
Fill zero behind number python
Python
3 votes284 views3 answers
Generate n different random numbers python
Python