import pandas as pd

ad_data = pd.read_csv('/datasets/ad_data_2.csv')
site_data = pd.read_csv('/datasets/site_data_2.csv')

funnel_daily = pd.merge(ad_data, site_data, on='date')
funnel_daily['ctr, %'] = funnel_daily['clicks'] / funnel_daily['impressions'] * 100
funnel_daily['cr, %'] = funnel_daily['registrations'] / funnel_daily['clicks'] * 100

funnel_daily['date'] = pd.to_datetime(funnel_daily['date'])
funnel_daily['week'] = funnel_daily['date'].dt.week
funnel_daily['month'] = funnel_daily['date'].dt.month

funnel_weekly = funnel_daily.groupby('week')[['impressions', 'clicks', 'registrations']].sum()
funnel_weekly['ctr, %'] = funnel_weekly['clicks'] / funnel_weekly['impressions']*100
funnel_weekly['cr, %'] = funnel_weekly['registrations'] / funnel_weekly['clicks']*100

funnel_monthly = funnel_daily.groupby('month')[['impressions', 'clicks', 'registrations']].sum()
funnel_monthly['ctr, %'] = funnel_monthly['clicks'] / funnel_monthly['impressions']*100
funnel_monthly['cr, %'] = funnel_monthly['registrations'] / funnel_monthly['clicks']*100

print(funnel_monthly)