import openpyxl
from openpyxl.workbook import Workbook
from WindPy import *
from pandas import *
import numpy as np
import pandas as pd
w.start();
data=w.wss(“031390396.IB,031490164.IB”, “sec_name,trade_code,issue_issuemethod,windl2type,issue_firstissue,ipo_cappaydate,rate_ratebond,latestissurercreditrating2,issue_amountplan,issue_issueyear,termnote,issuershortened,industry2,province,agency_leadunderwriter,agency_guarantor,latestratingofguarantor”,”tradeDate=20200305;ratingAgency=101;type=1;unit=1;industryType=1;industryStandard=1″)
data=pd.DataFrame(data.Data,index=data.Fields)
data=data.T #转置
writer = pd.ExcelWriter(‘112.xlsx’)
data.to_excel(writer, sheet_name=’Data1′, startcol=0, index=False)
writer.save()
Original: https://blog.csdn.net/weixin_32715971/article/details/112989703
Author: 知乎汽车
Title: python提取wind数据_用Python从wind获取数据,转换成dataframe格式,并保存为Excel文件,excel…
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/678891/
转载文章受原作者版权保护。转载请注明原作者出处!