def get_tail(pd, lines=-1):
"""
get .tail() of the DataFrame.
if 'lines' parameter is equel to -1 : use the deafult (usually 5),
otherwise : use it.
return type : DataFrame
"""
if lines == -1:
return pd.tail()
else:
return pd.tail(lines)
def get_only_head_and_tail(pd, lines=-1):
"""
get .head() + .tail() of the DataFrame.
if 'lines' parameter is equel to -1 : use the deafult (usually 5),
otherwise : use it.
return type : DataFrame
"""
if lines == -1:
return pd.head().append(pd.tail())
else:
lines = int(lines / 2)
return pd.head(lines).append(pd.tail(lines))
pass
def get_data(interval, symbols, time):
url = 'https://api.iextrading.com/1.0/stock/market/batch?symbols='
urlTypes = 'types=chart&'
#symbols = "AAPL,F,GE,SPY,FB&"
urlRange = 'range=1d&chartInterval=' + interval
# symbols = 'MMM,ABT&' # ,ABBV,ABMD,ACN,ATVI,ADBE,AMD,AAP,AES,AET,AMG,AFL,A,APD,AKAM,ALK,ALB,ARE,ALXN,ALGN,ALLE,AGN,ADS,LNT,ALL,GOOGL,GOOG,MO,AMZN,AEE,AAL,AEP,AXP,AIG,AMT,AWK,AMP,ABC,AME,AMGN,APH,APC,ADI,ANSS,ANTM,AON,AOS,APA,AIV,AAPL,AMAT,APTV,ADM,ARNC,ANET,AJG,AIZ,T,ADSK,ADP,AZO,AVB,AVY,BHGE,BLL,BAC,BK,BAX,BBT,BDX,BRK-B,BBY,BIIB,BLK,HRB,BA,BKNG,BWA,BXP,BSX,BHF,BMY,AVGO,BR,BF-B,CHRW,COG,CDNS,CPB,COF,CAH,KMX,CCL,CAT,CBOE,CBRE,CBS,CELG&'
r = DailyData.requests.get(url + symbols + urlTypes + urlRange)
json = r.json()
columns = [
'date', 'symbol', 'open', 'high', 'low', 'close', 'volume',
'change', 'changePercent', 'vwap'
]
pd = DailyData.pd.DataFrame(columns=columns)
for stock in json:
print(stock)
for chart in json[stock]['chart']:
if chart['minute'] == time:
pd = DailyData.map_to_chart(chart, pd, stock)
print(pd.head())
print(pd.tail())
pd.to_pickle("StockDataDaily/" + stock + ".pkl")
#df = df.append(df2) #行删除 # Drop rows with label 0 #df = df.drop(0) #基本功能 print pd.T print pd.axes print pd.dtype print pd.empty print pd.ndim print pd.shape print pd.size print pd.values print pd.head() print pd.tail() #描述性统计 #df.sum() #df.mean() #df.std() #count() #median() #mode() #min() #max() #abs() #prod #cumsum #cumprod #decrible()