if strt_qtr==end_qtr: interval=`Q` cpa_latest=`CPA Accounts: `+strt_qtr ltpv_latest=`LT PV for ROI: `+strt_qtr ctrl_acc_latest=`Contr Accounts: `+strt_qtr print(`n`, cpa_latest, `n`, ltpv_latest, `n`, ctrl_acc_latest, `n`) else: interval=`H` i=strt_q qtr_col=[] cpa_col=`` ctrl_col=`` ltpv_col=`` while (i<=4): j=strt_yr while (j<=end_yr): if j qtr_col=qtr_col.append(quarter) if cpa_col==``: cpa_col=`+cpa_latest+` else: cpa_col=cpa_col+,+`+cpa_latest+` if ctrl_col==``: ctrl_col=`+ctrl_acc_latest+` else: ctrl_col=ctrl_col+,+`+ctrl_acc_latest+` if ltpv_col==``: ltpv_col=`+ltpv_latest+` else: ltpv_col=ltpv_col+,+`+ltpv_latest+` if j==end_yr and i<=end_q: quarter=`Q`+str(i)+` `+str(j) cpa_latest=`CPA Accounts: `+`Q`+str(i)+` `+str(j) ctrl_acc_latest=`Contr Accounts: `+`Q`+str(i)+` `+str(j) ltpv_latest=`LT PV for ROI: `+`Q`+str(i)+` `+str(j) qtr_col=qtr_col+,+`+quarter+` cpa_col=cpa_col+,+`+cpa_latest+` ctrl_col=ctrl_col+,+`+ctrl_acc_latest+` ltpv_col=ltpv_col+,+`+ltpv_latest+` j=j+1 i=i+1 qrt_cal_col=qtr_col.replace(`,`,`]+ X[` ) qrt_cal_col=X[+qrt_cal_col+] cpa_cal_col=cpa_col.replace(`,`,`]+ X[` ) cpa_cal_col=X[+cpa_cal_col+] ctrl_cal_col=ctrl_col.replace(`,`,`]+ X[` ) ctrl_cal_col=X[+ctrl_cal_col+] ltpv_cal_col=ltpv_col.replace(`,`,`]+ X[` ) ltpv_cal_col=X[+ltpv_cal_col+] print(`n`, qtr_col, `n n`, cpa_col, `n n`, ctrl_col,`n n`, ltpv_col) advrt_lkp= pd.read_excel(nat_agg, sheet_name=`Advertising Lookup`) advrt_lkp_not=advrt_lkp[~advrt_lkp[`Variable`].is()] #remove values advrt_lkp_not=advrt_lkp_not[advrt_lkp_not[`Counted Message`]==1] advrt_lkp_not=advrt_lkp_not[[`Variable`,`ROMI Ent Msg`,qtr_col]]
©