def update_ga_category(selected_rows, end_date):
travel_product = []
travel_product_list = sorted(df['GA Category'].unique().tolist())
for i in selected_rows:
travel_product.append(travel_product_list[i])
# Filter by specific product
filtered_df = df[(df['GA Category'].isin(travel_product))].groupby(
['Year', 'Week']).sum()[[
'Spend TY', 'Spend LY', 'Sessions - TY', 'Sessions - LY',
'Bookings - TY', 'Bookings - LY', 'Revenue - TY', 'Revenue - LY'
]].reset_index()
fig = update_graph(filtered_df, end_date)
return fig
def update_metasearch(selected_rows, end_date):
travel_product = []
travel_product_list = df[(df['Category'] == 'Metasearch and Travel Ads'
)]['Placement type'].unique().tolist()
for i in selected_rows:
travel_product.append(travel_product_list[i])
# Filter by specific product
filtered_df = df[(df['Placement type'].isin(travel_product))].groupby(
['Year', 'Week']).sum()[[
'Spend TY', 'Spend LY', 'Sessions - TY', 'Sessions - LY',
'Bookings - TY', 'Bookings - LY', 'Revenue - TY', 'Revenue - LY'
]].reset_index()
fig = update_graph(filtered_df, end_date)
return fig
def update_line_graph(proj, conf, start_date, end_date):
line_data = update_graph(proj, conf, start_date, end_date)
return line_data
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