def sumstockPricesOriginalData(): a = sqlqueries.sqlSumStockData() df = pd.read_sql(a, engine, parse_dates='transdate') df = pd.pivot_table(df, index=['transdate','owner', 'FXRate'],values=["Price"],columns=['symbol']).reset_index() df = df.fillna(0) droplevel(df) return returnTable(df)
def sumstockPricesData(): a = sqlqueries.sqlSumStockData() df = pd.read_sql(a, engine, parse_dates='transdate') df = pd.pivot_table(df, index=['transdate','owner', 'FXRate'],values=["Price"],columns=['symbol']).reset_index() droplevel(df) df4 = df df4 = df4.iloc[:2,3:] df4 = pd.DataFrame(df4.sum()) df3 = df.iloc[:,3:] initial = df3.ix[0:1] initial = initial.sum() df2 = df3.divide(initial / 100) df.iloc[:,3:] = df2 df4 = df4.reset_index() df4.columns = ['Stock','Price'] df = df.fillna(0) return returnTable(df), returnTable(df4)