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 = (data.loc[i]['日期'])
        moneny = (data.loc[i]['金额'])
        dsd(j-1, b, date)
        dsd(j-1, c, moneny)
def dsd(yol,xol,vale):
    worksheet.write(yol, xol, vale)
for i in range(s):
    if int(data.loc[i]['ran'])==1:
        id=int(data.loc[i]['ran'])
        print(id)
        dnon=(str(data.loc[i]['寄卖单号']))
        print(dnon)
        date=(data.loc[i]['日期'])
        moneny=(data.loc[i]['金额'])
        dsd(j,0,dnon)
        dsd(j,1,date)
        dsd(j,2,moneny)
        j=j+1
    asd(2,3,4)
    asd(3,5,6)
    asd(4,7,8)
    asd(5,9,10)
    asd(6,11,12)
    asd(7,13,14)
    asd(8, 13, 14)
workbook.close()