用Python从wind获取数据，转换成dataframe格式，并保存成excel文件

最新推荐文章于 2024-07-26 16:05:52 发布

qq_40423392

最新推荐文章于 2024-07-26 16:05:52 发布

阅读量5.7k

点赞数

文章标签： python excel

本文链接：https://blog.csdn.net/qq_40423392/article/details/104741200

版权

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()