Example #1
0
def netincomedata():

    a = sqlqueries.sqlmonthlyexpenses()
    string = ""
    multiplier = ""

    df = pd.read_sql(a %(string, multiplier), engine, parse_dates='Date')

    return returnTable(df)
Example #2
0
def spendingdata():

    a = sqlqueries.sqlmonthlyexpenses()
    multiplier = "* - 1"
    string = "WHERE categories.Spending"

    df = pd.read_sql(a %(multiplier, string), engine, parse_dates='Date')

    return returnTable(df)