Python代码示例，读取excel表格，将行数据转为列数据。（10）

import pandas as pd

types = ['语文','数学','物理','化学','生物','地理']
excelfile = './行数据表格.xlsx'
mexcel = './列数据表格.xlsx'

df = pd.read_excel(excelfile,sheet_name='sheet1')
dfm = pd.read_excel(mexcel)

unit = []
for index,row in dfm.iterrows():
    dictrow = row.to_dict()
    unit.append(dictrow['统计'])

ta = {}
for item in unit:
    typei = {}
    for type in types:
        typei[type] = 0
    ta[item] = typei

for index,row in df.iterrows():
    dictrow = row.to_dict()
    ta[dictrow['学生']][dictrow['科目']] = dictrow['成绩']

for ab in ta:
    print(ab,end='')
    for sf in ta[ab]:
        print('\t',end='')
        print(ta[ab][sf],end='')
    print()