You cannot access banned topics.
表格去重代码
import pandas as pd
EXCEL_FILE_PATH = input("input the file:")
df = pd.read_excel(EXCEL_FILE_PATH,sheet_name = 'Sheet1')
df = df.drop_duplicates(subset = ['修改内容'])
df.to_excel(excel_writer = 'new1.xlsx')
执行上述代码,结果表格格式发生改变,请问通过什么方法可以实现去重后不改变表格格式

import pandas as pd
from openpyxl import load_workbook
EXCEL_FILE_PATH = input("请输入文件路径:")
# 使用 pandas 进行去重
df = pd.read_excel(EXCEL_FILE_PATH, sheet_name='Sheet1')
df = df.drop_duplicates(subset=['修改内容'])
# 使用 openpyxl 写回原有的Excel文件
book = load_workbook(EXCEL_FILE_PATH)
writer = pd.ExcelWriter(EXCEL_FILE_PATH, engine='openpyxl')
writer.book = book
df.to_excel(writer, index=False, header=False, startrow=writer.sheets['Sheet1'].max_row)
writer.save()
writer.close()
可以试试这个
跑了下报错呢,另外原表格损坏了
报错代码:df.to_excel(writer, index=False, header=False, startrow=writer.sheets['Sheet1'].max_row)
KeyError: 'Sheet1'
这么搞下去,论坛也迟早成为 AI 的炮灰
这 ai 提供的方法没有解决呢,看来还是不太行……
需要自己写,最简单的办法,丢列表遍历,找出重复行,删掉重复数据再保存就行了