pyhon实现excel的转置

 变换成如下格式

import pandas as pd
from win32com.client import Dispatch
import openpyxl
import xlsxwriter
workbook=xlsxwriter.Workbook('you.xlsx')
worksheet=workbook.add_worksheet()
data = pd.read_excel(r'D:\python分析脚本\数据整理\上海zw1.xls', sheet_name='Sheet1')
s=data.shape[0]
j=1

def asd(ran,b,c):
    if int(data.loc[i]['ran']) == ran:
        dnon = (str(data.loc[i]['寄卖单号']))
        print(dnon)
        date = (