Python df_with_query Examples

Example #1

File: report_multiples.py Project: jin-park-dev/SelfData

def graph_report(start_date, end_date):
    for tbl_name, tbl_info in daily_config.items():
        date_name = 'Date'
        df = util.df_with_query(tbl_name, date_name, start_date, end_date)
        # print(df)

        if df.empty:
            error = "Table: {}, No record for {} - {}".format(tbl_name, start_date, end_date)
            print(error)
            continue
            return error

        y_axis = tbl_info['y_axis']
        util.plot_monthly(df[date_name], df[y_axis], tbl_name, start_date, end_date)

Example #2

File: google_fit.py Project: jin-park-dev/SelfData

import Report.util_daily_report as util

tbl_name = 'google_fit'
date_name = 'Date'
start_date = '2017-01-01'
end_date = '2017-05-01'  #23/07/2017
y_axis = 'Step count'

df = util.df_with_query(tbl_name, date_name, start_date, end_date)
util.plot_monthly(df[date_name], df[y_axis], tbl_name)