Python将数据框附加到现有的Excel文件和工作表

使用Python将数据框附加到现有的Excel文件和工作表

pip install pandas
pip install openpyxl

python
import pandas as pd
# 创建一个数据框
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [28, 32, 45],
        'City': ['New York', 'Paris', 'London']}
df = pd.DataFrame(data)
# 将数据框附加到现有的Excel文件和工作表中
with pd.ExcelWriter('example.xlsx', mode='a') as writer:
    df.to_excel(writer, sheet_name='Sheet1', index=False)

python
import pandas as pd
# 创建一个数据框
data = {'Name': ['Tom', 'Nick', 'John'],
        'Age': [28, 32, 45],
        'City': ['New York', 'Paris', 'London']}
df = pd.DataFrame(data)
# 将数据框附加到新的工作表中
with pd.ExcelWriter('example.xlsx', mode='a') as writer:
    df.to_excel(writer, sheet_name='Sheet2', index=False)

python
import pandas as pd
# 创建2019年的销售数据框
sales_2019 = pd.DataFrame({'Month': ['January', 'February', 'March'],
                           'Revenue': [10000, 15000, 12000]})
# 创建2020年的销售数据框
sales_2020 = pd.DataFrame({'Month': ['January', 'February', 'March'],
                           'Revenue': [12000, 18000, 15000]})

python
# 将数据框附加到"2019"工作表中
with pd.ExcelWriter('sales.xlsx', mode='a') as writer:
    sales_2019.to_excel(writer, sheet_name='2019', index=False)
# 将数据框附加到"2020"工作表中
with pd.ExcelWriter('sales.xlsx', mode='a') as writer:
    sales_2020.to_excel(writer, sheet_name='2020', index=False)