import pandas as pd """ 实现excel按某一列groupyby,另一列逗号相加 """ file_path= "ppc_dictionary_inuse.xlsx" save_file_path='./new.xlsx' sheet_name="cw_theme" df = pd.read_excel(file_path, sheet_name=sheet_name) df=df[["name_en","name_cn"]] #注意如果不加reset_index,那么新排的列就会被当做索引,从而有点问题 #参考:https://www.it1352.com/1779380.html df=df.groupby('name_en').agg({"name_cn":','.join}).reset_index() a=1 #数据写入 writer = pd.ExcelWriter(save_file_path) df.to_excel(excel_writer=writer,sheet_name=sheet_name,header=None,index=None) writer.save() writer.close()
读取excel A列重复的B列值相加
最新推荐文章于 2024-02-18 20:49:55 发布