Download Analyst Recommendation from HeXun

最新推荐文章于 2022-04-20 08:35:00 发布

zhucai4

最新推荐文章于 2022-04-20 08:35:00 发布

阅读量1k

点赞数

分类专栏： Python Trading

本文链接：https://blog.csdn.net/zhucai4/article/details/45072493

版权

Python Trading 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

import numpy as np
import scipy as sp
import scipy.stats as ss
import pandas as pd
import requests as rs
import bs4

df = pd.DataFrame()

for i in range(51,3808):
    webpage = 'http://yanbao.stock.hexun.com/listnews1_'+str(i)+'.shtml' 
    response = rs.get(webpage)
    soup = bs4.BeautifulSoup(response.text)
    links = soup.findAll('td', align="left")

    stock = []
    institution = []
    analysts = []
    rating = []
    date = []

    for j in xrange(len(links)):
        if (j%5==0):
            stock.append(links[j].get_text().split(u'\uff1a')[0])
        elif (j%5==1):
            institution.append(links[j].get_text())
        elif (j%5==2):
            analysts.append(links[j].get_text())
        elif (j%5==3):
            rating.append(links[j].get_text())
        else:
            date.append(links[j].get_text())

    ratingdata = np.array([date, stock, rating, institution, analysts]).T   
    ratingdata = pd.DataFrame(ratingdata)
    ratingdata.columns = ['Date', 'Stock', 'Rating', 'Institution', 'Analysts']
    df = df.append(ratingdata)    
    
filedestiny = 'analystrating.csv'
df.to_csv(filedestiny, encoding='utf-8', index=False)