import bs4 as bsimport datetime as dtimport osimport pandas as pdimport pandas_datareader.data as webimport pickleimport requestsdef save_sp500_tickers():resp = requests.get('http://en.wikipedia.org/wiki/List_of_S%26P_500_companies')soup = bs.BeautifulSoup(resp.text, 'lxml')table = soup.find('table', {'class': 'wikitable sortable'})tickers = []for row in table.findAll('tr')[1:]: ticker = row.findAll('td')[0].text tickers.append(ticker)with open("sp500tickers.pickle", "wb") as f: pickle.dump(tickers, f)return tickers # save_sp500_tickers()def get_data_from_yahoo(reload_sp500=False):if reload_sp500: tickers = save_sp500_tickers()else: with open("sp500tickers.pickle", "rb") as f: tickers = pickle.load(f)if not os.path.exists('stock_dfs'): os.makedirs('stock_dfs')start = dt.datetime(2010, 1, 1)end = dt.datetime.now()for ticker in tickers: # just in case your connection breaks, we'd like to save our progress! if not os.path.exists('stock_dfs/{}.csv'.format(ticker)): df = web.DataReader(ticker, 'yahoo', start, end) df.reset_index(inplace=True) df.set_index("Date", inplace=True) df = df.drop("Symbol", axis=1) df.to_csv('stock_dfs/{}.csv'.format(ticker)) else: print('Already have {}'.format(ticker))def compile_data():with open("sp500tickers.pickle", "rb") as f: tickers = pickle.load(f)main_df = pd.DataFrame()for count, ticker in enumerate(tickers): df = pd.read_csv('stock_dfs/{}.csv'.format(ticker))此處發(fā)生錯誤，它指出“文件 stock_dfs/BRK.B.csv 不存在”，但它首先沒有在本地導(dǎo)入/存儲，所以為什么這是一個問題？底部的完整錯誤
1 回答
Smart貓小萌
TA貢獻1911條經(jīng)驗 獲得超7個贊
就在錯誤發(fā)生之前，調(diào)用了pd.read_csv()：
for count, ticker in enumerate(tickers):
df = pd.read_csv('stock_dfs/{}.csv'.format(ticker))
當(dāng)ticker是'BRK.B'并且程序嘗試設(shè)置從中讀取數(shù)據(jù)時會發(fā)生錯誤'stocks_dfs/BRK.B.csv'。
錯誤信息是說你的機器上沒有stocks_dfs/BRK.B.csv文件。這令人費解，因為這段代碼應(yīng)該已經(jīng)下載了所有必要的文件：
for ticker in tickers:
# just in case your connection breaks, we'd like to save our progress!
if not os.path.exists('stock_dfs/{}.csv'.format(ticker)):
df = web.DataReader(ticker, 'yahoo', start, end)
df.reset_index(inplace=True)
df.set_index("Date", inplace=True)
df = df.drop("Symbol", axis=1)
df.to_csv('stock_dfs/{}.csv'.format(ticker))
else:
print('Already have {}'.format(ticker))
確保在運行讀取代碼（頂部）的同一目錄中運行下載代碼（正上方）。要進行快速檢查，請查看您的工作目錄中是否存在名為的文件夾。該文件夾應(yīng)包含、和特別是.stock_dfs/GOOGL.csvFB.csvBRK.B.csv
添加回答
舉報
0/150
提交
取消