DataFrame读写多个sheet

1，写入多个Sheet

import pandas as pd
import numpy as np

arr = np.array(np.random.randint(0,100,25)).reshape(5,5)
# print('first:\n' , arr)

df = pd.DataFrame(arr,index = ['a','b','c','d','e'], columns =['name','age','sex','score','weight'])
df['sex']=['M','F','M','F','M']
df['name']=['xing','liu','zhang','li','Kevin']
df1 = pd.DataFrame(arr,index = ['a','b','c','d','e'], columns =['name','age','sex','score','weight'])
df1['name'] = ['John','David','stephen','Lily','Hao']
df1['status'] = [1,2,3,4,5]

with pd.ExcelWriter('TestExcel01.xlsx') as writer:
     df.to_excel(writer,sheet_name='sheet1')
     df1.to_excel(writer,sheet_name='sheet2')

2，读出多个sheet

df = pd.read_excel('TestExcel01.xlsx',sheet_name=0)
df1= pd.read_excel('TestExcel01.xlsx',sheet_name=1)