python处理excel格式变化，分类，归类，行变列

 上图转换成下图，格式转换。

方法一

import pandas as pd
data1 = pd.read_csv(r"C:\path1.csv",encoding='gb18030')
rows = data1.shape[0]  # 获取行数 shape[1]获取列数
department_list = []

for i in range(rows):
    temp = data1["表名"][i]
    if temp not in department_list:
        department_list.append(temp)
n = len(department_list)

import xlsxwriter  # 导入模块

df_list=[]
for v in range(n):
    df_v=[]
    df_list.append(df_v)

workbook = xlsxwriter.Workbook(r"C:\path2.xlsx")  # 新建excel表
worksheet = workbook.add_worksheet(name="11")  # 新建sheet（sheet的名称为"sheet1"）
worksheet.write_row('A1', department_list)

for w in range(n):
    for i in range(0, rows):
        i