/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 vote176 views4 answers
Remove french stopwords with spacy
Python
1 vote201 views1 answer
Sort and remove duplicates list python
Python
0 vote215 views2 answers
Print specific key in dictionary python
Python
1 vote179 views1 answer
String to tuple python
Python
9 votes179 views8 answers
Python loop
Python
2 votes238 views1 answer
Import crypto python
Python
0 vote190 views1 answer
Flask read form data
Python
1 vote197 views1 answer
Python transpose np array
Python
0 vote181 views2 answers
Pandas groupby aggregate quantile
Python
1 vote184 views1 answer
Split list into list of lists python on every n element
Python