变换成如下格式
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()