我的腳本接收 F500 公司的“實時”在線列表,遍歷每個股票代碼,獲取指定時間段內(nèi)的股票代碼表現(xiàn)。我無法弄清楚的是如何將模式/存儲到 2D 列表中,每個符號的多行代碼數(shù)據(jù)。不知何故,第二個 iterrows 將不起作用。提前致謝:import pandas as pd #dataframe extends from pdimport pandas_datareader.data as web #grabs stock dataimport datetime as dt #to specify date range for grab#VARS:#url to f500 listdata_url = "https://query.data.world/s/vjghzuarkh6dap3dblkxanppyh5jtl" source = "yahoo" start = dt.datetime(2019, 2, 13) #datetime typeend = dt.datetime.now() results = []#read into memorydf500 = pd.read_csv(data_url)for index, row in df500.tail().iterrows(): try: dfdr = web.DataReader(row['SYMBOL'], source, start, end) #returns a dataframe presumably for index2, row2 in dfdr().iterrows(): # here i want to append to the results list: row['SYMBOL'], row2['Date'], row2['High'] print ("test output ", row2[0]) #not even this works except Exception as e: pass# commit to sqlite3 from list or df
添加回答
舉報
0/150
提交
取消