Answers for "list multiple excel sheet in python pandas"

multipl excel sheets in pandas

xls = pd.ExcelFile('path_to_file.xls')
df1 = pd.read_excel(xls, 'Sheet1')
df2 = pd.read_excel(xls, 'Sheet2')

Posted by: Guest on March-31-2021

how to read excel with multiple pages on pandas

pd.read_excel('filename.xlsx', sheet_name = 'sheetname')

Posted by: Guest on April-28-2021

Code answers related to "list multiple excel sheet in python pandas"