代码:
import pandas as pd
import os
path="D:/1-data/202210/" #存放文件的文件夹
pathnew="D:/1-data/ok/" #导出文件的文件夹
files=os.listdir(path) #打开文件夹
for i in files:
df=pd.read_csv(path+i,encoding = 'gb2312')
df = df.drop(columns=["要删除的列", "要删除的列"])
df.to_csv(pathnew+i,index=False)
原文件:
导出来的:
for i in files:
df=pd.read_csv(path+i,encoding = 'gb2312')
df=df.iloc[:,[0,2,4]] #df.iloc[行编号,列编号] [0,2,4]表示取这三列
df.columns=["1","2","3"] #给这几列改标题
df["4"]=0 #新增一列,用0填充
df.to_csv(pathnew1+i,index=False)