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()