根据值合并行（pandas 到 excel - xlsxwriter）- 加法

跟进这个问题 https://stackoverflow.com/questions/61217923/merge-rows-based-on-value-pandas-to-excel-xlsxwriter/61228294?noredirect=1#comment120527781_61228294

我想问我们是否可以合并多列中的行，即

根据 @Dimitris Thomas 的回答，我将能够获得以下内容

并想知道如何更新代码以获得：

Thanks

IIUC:

Firstly:

df=pd.read_excel('filename.xlsx')
#read excel file in pandas

try via set_index() and to_excel()

df.set_index(df.columns[:-1].tolist()).to_excel('filename.xlsx',header=None)
#OR(Since you don't provide data as text so not sure which one should work)
df.set_index(df.columns.tolist()).to_excel('filename.xlsx',header=None)