symbol警告：无法读取替换为NaN的符号

Question

我试图用熊猫下载斯德哥尔摩所有大盘股的历史股票数据。它运作良好，但对某些股票则不然

import pandas_datareader.data as pdr
import datetime
import csv

with open('stockholm_largecap.csv', 'rb') as f:
    reader = csv.reader(f)
    stockholmLargeCap = list(reader)

start = datetime.datetime(1970, 1, 1)
end = datetime.datetime.today();

stockData = {}

for symbol in stockholmLargeCap:
    f = pdr.DataReader(symbol, 'yahoo', start, end)
    print f

斯德哥尔摩_大容量.csv包含按字母顺序排列的所有股票，但一旦我得到某些股票，我得到（例如BETS-B.ST）：symbol警告：读取符号失败：“BETS-B.ST”，替换为NaN。脚本终止。有没有什么方法可以继续这个程序，忽略这个错误？是什么原因导致一些股票不起作用？在

^{pr2}$

Answer 1

使用try和{}

import pandas_datareader.data as pdr

for symbol in ['SPY', 'holla']:
    try:
        f = pdr.DataReader(symbol, 'yahoo', "2001-01-01", "2010-01-01")
        print f.head(5)
    except:
        print ('did not find: '+symbol)

               Open     High      Low    Close    Volume  Adj Close
Date                                                               
2001-01-02 132.0000 132.1562 127.5625 128.8125   8737500    95.2724
2001-01-03 128.3125 136.0000 127.6562 135.0000  19431600    99.8488
2001-01-04 134.9375 135.4687 133.0000 133.5468   9219000    98.7740
2001-01-05 133.4687 133.6250 129.1875 129.1875  12911400    95.5497
2001-01-08 129.8750 130.1875 127.6875 130.1875   6625300    96.2893
did not find: holla

Answer 2

当我试图从列表中获取股票时，我遇到了同样的问题，我使用了异常处理块，它继续执行代码，尽管出现了符号warning viz。[SymbolWarning:未能读取符号：'AXZZW'，替换为NaN。 警告。警告(消息格式（sym），SYMBOL警告]

from pandas_datareader._utils import RemoteDataError
from pandas_datareader.data import Options
try:
    df1 = web.DataReader(rows[i],'yahoo',"2001-01-01","2010-01-01")
    print("Downloading",i,"/",len(rows),"............")
    print(df1)
except KeyError:
    print("Data not found at Ticker %s"%i)
    continue
except RemoteDataError:
    print("Data not found at Ticker %s"%i)
    continue
print("Success!")

希望这对你也有用！在