List of articles

• Construction worksheet
• Save data to multiple sheet in

Construction worksheet

import pandas as pd
df = pd.DataFrame({
' Number ':['1001','1002','1003'],
' full name ':[' Zhang San ',' Li Si ',' Wang Wu '],
' Total score ':[740,678,322]})
df

Save data to multiple sheet in

# Open one Excel file 
work = pd.ExcelWriter('excel.xlsx')
# Save the first table 
df.to_excel(work, sheet_name=' Complete information ',index=False)
# Save the second table 
df[[' full name ',' Total score ']].to_excel(work, sheet_name=' League tables ',index=False)
# Data persistence 
work.save()