Excel合并单元格太坑了?别再用鼠标一个个复制了,13行Python代码搞定“快递明细”整理!

import pandas as pddf = pd.read_excel(r"E:\快递明细.xlsx")address_dict = {"收货人":[],"收货人电话":[],"地址":[],"商品名称及数量":[]}for _,row in df.iterrows():    if not pd.isna(row.iloc[4]):        address_dict["收货人"].append(row.iloc[2])        address_dict["收货人电话"].append(row.iloc[3])        address_dict["地址"].append(row.iloc[4])        address_dict["商品名称及数量"].append(f"{row.iloc[0]}*{row.iloc[1]}")    else:        address_dict["商品名称及数量"][-1] += f"{row.iloc[0]}*{row.iloc[1]}"df = pd.DataFrame.from_dict(address_dict)df.to_excel(r"E:\快递明细_合并后.xlsx",index=False)

import pandas as pddf = pd.read_excel(r"E:\快递明细.xlsx")

address_dict = {"收货人":[],"收货人电话":[],"地址":[],"商品名称及数量":[]}for _,row in df.iterrows():    if not pd.isna(row.iloc[4]):        address_dict["收货人"].append(row.iloc[2])        address_dict["收货人电话"].append(row.iloc[3])        address_dict["地址"].append(row.iloc[4])        address_dict["商品名称及数量"].append(f"{row.iloc[0]}*{row.iloc[1]}")    else:        address_dict["商品名称及数量"][-1] += f"{row.iloc[0]}*{row.iloc[1]}"

df = pd.DataFrame.from_dict(address_dict)df.to_excel(r"E:\快递明细_合并后.xlsx",index=False)