import glob
import os
import pandas as pd
csv_path = glob.glob('.\\shares\\*\\*.csv')
csv_path
去除列名中的空格
for csv_name in csv_path:
df = pd.read_csv(csv_name, encoding='gbk')
df.head()
col_names = df.columns.tolist() # 获取列名字
# 把列名中的空格去掉
for index,value in enumerate(col_names):
col_names[index]= value.replace(" ","")
col_names
# 修改列名字
df.columns=col_names
df.to_csv(csv_name, encoding='gbk')