def update_data_1(start_date, end_date, derived_filter_query_structure):
# with open("/Users/roman/Work/business/JHU APL/dash_sample_dashboard/data/Output.txt", "w") as text_file:
# text_file.write(data_2.to_string())
data_2 = update_first_datatable(start_date, end_date, 'Paid Search',
'Placement type')
# print("After first datatable update")
# print(data_2)
# print("DF 2")
# print(data_2)
(pd_query_string,
df_filtered) = construct_filter(derived_filter_query_structure, df=data_2)
# print("Query String: %s" % pd_query_string)
if pd_query_string != '':
df_filtered = data_2.query(pd_query_string)
# print("DF Filtered")
# print(df_filtered)
# with open("Output.txt", "w") as text_file:
# text_file.write(intermediate.to_string())
return df_filtered.to_dict("rows")
def update_data_1_metasearch(start_date, end_date,
derived_filter_query_structure):
(pd_query_string,
df_filtered) = construct_filter(derived_filter_query_structure)
if pd_query_string != '':
df_filtered = df_filtered.query(pd_query_string)
intermediate = df_filtered.to_dict('rows')
data_1 = update_first_datatable(start_date, end_date,
'Metasearch and Travel Ads',
'Placement type', intermediate)
return data_1
def update_data_1_metasearch(start_date, end_date):
data_1 = update_first_datatable(start_date, end_date,
'Metasearch and Travel Ads',
'Placement type')
return data_1
def update_data_1_publishing(start_date, end_date):
data_1 = update_first_datatable(start_date, end_date, 'Publishing',
'Placement type')
return data_1
def update_data_1_display(start_date, end_date):
data_1 = update_first_datatable(start_date, end_date, 'Display',
'Placement type')
return data_1
def update_data_1(start_date, end_date):
data_1 = update_first_datatable(start_date, end_date, 'Paid Search',
'Placement type')
return data_1
def update_data_1(start_date, end_date):
data_1 = update_first_datatable(start_date, end_date, None, 'GA Category')
return data_1
def update_data_1(proj, conf, start_date, end_date):
data_1 = update_first_datatable(proj, conf, start_date, end_date)
return data_1
def update_data_1(start_date, end_date, serial_number):
return update_first_datatable(start_date, end_date, serial_number)
def update_hamilton_category(start_date, end_date, serial_number):
filtered_df = update_first_datatable(start_date, end_date, serial_number)
fig = update_graph(filtered_df)
return fig