patter1 2021-02-20 15:09 采纳率: 33.3%
浏览 7333

请教: 'list' object has no attribute 'to_excel'

下面程序一直无法将数据写入文件,请教:

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)
  • 写回答

1条回答 默认 最新

  • Sevan_Li 2021-02-20 15:13
    关注

    你这都没有转换成DataFrame啊,当然没有to_excel了

    你弄完之后,df_fund_detail=fund_detail这个改成【df_fund_detail=pandas.DataFrame(fund_detail)】

    评论

报告相同问题?

悬赏问题

  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
  • ¥15 数据可视化Python
  • ¥15 要给毕业设计添加扫码登录的功能!!有偿
  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥15 stable diffusion
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条