下面程序一直无法将数据写入文件,请教:
import json
import time
from collections import OrderedDict
import pandas
import numpy as np
import requests
from bs4 import BeautifulSoup
def List():
data = pandas.read_csv("fund code.csv")
data1 = data.values.tolist()
return data1
def Fund_detail_info(i,fund_detail):
rank_detail_info = OrderedDict()
#i= str(i[0])
id = i.zfill(6)
fund_ur1='http://fundf10.eastmoney.com/zcpz_'+ id +'.html'
response = requests.get(fund_ur1)
response.encoding = "utf-8"
response = response.text
soup = BeautifulSoup(response,"lxml")
rank_detail_info['基金代码'] = id
soup_div = soup.find_all('div', class_='bs_gl')
soup_r = soup.find_all('td', class_='tor')
data = soup_div[0].find_all('label')
#print(data)
#for n in data:
# soup_span=n.span.text
# soup_a=n.a.text
# print(soup_span)
# print(soup_a)
rank_detail_info['成立日期'] = soup_div[0].find_all('label')[0].find_all('span')[0].get_text()
rank_detail_info['基金经理'] = soup_div[0].find_all('label')[1].find_all('a')[0].get_text()
rank_detail_info['类型'] = soup_div[0].find_all('label')[2].find_all('span')[0].get_text()
rank_detail_info['管理人'] = soup_div[0].find_all('label')[3].find_all('a')[0].get_text()
rank_detail_info['资产规模'] = soup_div[0].find_all('label')[4].find_all('span')[0].get_text().replace("\r\n", "").replace(" ", "")
rank_detail_info['股票比例'] = soup_r[0].get_text()
fund_detail.append(rank_detail_info)
return fund_detail
list = List()
j = 0
fund_detail=[]
for i in list:
j+=1
i = str(i[0])
fund_detail = Fund_detail_info(i,fund_detail)
print('扫描基金'+ i+ '数据,还剩'+ str(len(list)-j))
#fund_detail_data = []
#fund_detail_data.append(fund_detail)
#print(fund_detail)
df_fund_detail=fund_detail
print(fund_detail)
df_fund_detail.to_excel(f'Fund 详情.xlsx','经济信息', encoding='utf-8',index=None)