python - Delete single column from multiple xlsx sheets using python

Question

Can anyone know that how to delete same single column from multiple xlsx sheet using python?

After that those sheets save it to same path.

标签： pythonexcelpandasopenpyxlxlrd

Answer 1

首先，您应该使用 Excel 工作簿创建一个列表并保存在一个名为“files”的变量中：

dfs = []

for file in files:
    df = pd.read_excel(file, sheet_name = None)
    dfs.append(df)

col_to_delete = ['Your columns']

for df in dfs:
    #Here you delete one by one
    df.drop(labels = col_to_delete, inplace = True)

之后，我不知道您是否要合并所有 .xlsx 或覆盖，但这是另一个问题，请查看 pd.Write() 的文档以保存文件

希望能帮助到你