python - Python / pandas 从多个excel表中导入数据并转置为单个excel

Question

我正在寻找一种在 python 中从一系列数百个 excel 表中导入数据的方法，将其转置，然后将其导出到新的 excel 中（参见下图说明概念）。我可以遍历文件，获取数据，但坚持转置数据并将其写入/附加到新的数据帧：

import pandas as pd
import glob
import os

path =r'C:\Users\data'
filenames = glob.glob(path + "/*.xlsx")
files = os.listdir(path)

files_xls = [f for f in files if f[-4:] == 'xlsx']
df = pd.DataFrame()

for f in files_xls:
    data = pd.read_excel(path+'\\'+f, 'Assessment')
    answers_to_copy =  list(range(20, 32))+list(range(33, 113))
    df = []
    Entity_Name     = data['Definition'][11]
    for ind in answers_to_copy:
        print(data['IndicatorName'][ind], data['Answer'][ind]) 

标签： pythonexcelpandastranspose