如何使用python在excel文件的现有工作表中追加dataframe

Question

您可以在下面找到我迄今为止尝试过的内容：

import pandas
from openpyxl import load_workbook

book = load_workbook('C:/Users/Abhijeet/Downloads/New Project/Masterfil.xlsx')
writer = pandas.ExcelWriter('C:/Users/Abhijeet/Downloads/New Project/Masterfiles.xlsx', engine='openpyxl',mode='a',if_sheet_exists='replace') 
df.to_excel(writer,'b2b')

writer.save()
writer.close()

Answer 1

假设您有excel文件abc.xlsx。 您有一个数据帧要附加为“df1”

1.使用熊猫读取文件

import pandas as pd
df = pd.read_csv("abc.xlsx")

2.连接两个数据帧并写入“abc.xlsx”

finaldf = pd.concat(df,df1)
# write finaldf to abc.xlsx and you are done