读取一个文件夹下面所有csv文件,并对其进行转置

import pandas as pd
import os

def transpose(path,i):
    df = pd.read_csv(path,header=None)
    df = df.iloc[:,4:]
    data = df.values
    index1 = list(df.keys())
    data = list(map(list,zip(*data))) #用zip(*)对数据进行转置
    data = pd.DataFrame(data,index = index1)
    data.to_csv('result'+str(i)+'.csv',index=False,sep=',')

for i,name in enumerate(os.listdir(data_path)):#用os.listdir获取文件夹下文件
    path =  'C:/Users/Administrator/Desktop/数据集phm-ieee-2012-data-challenge-dataset-master/phm-ieee-2012-data-challenge-dataset/Learning_set/Bearing1_1/'+str(name)+''
    transpose(path,i)