def sort_ph3(test_case_removal):
current_date = str(datetime.datetime.now().strftime("%Y-%m-%d"))
ph = Phase3(bool(test_case_removal),concat=True)
ph.filterPhaseReports()
redo_index = ph.redoScoreIndices()
ph.percent_difference(redo_index)
df= ph.report
redo_sum = df[df['redo'].notnull()]['emq'].sum()
non_redo_sum = df[df['redo'].isnull()]['emq'].sum()
ph.report=ph.sort_repo('email')
df=ph.consolidate_repo()
output = Output(df,'3')
output.do_it_all()
writer = pd.ExcelWriter('/var/www/html/flaskapp/Output/No_Phase '+current_date+'.xlsx',engine='xlsxwriter')
output.df.to_excel(writer,startcol = 0, startrow = 10,index=False)
worksheet = writer.sheets['Sheet1']
worksheet.write_string(0, 0, 'EmQ No Phase/Redo Export – '+current_date)
worksheet.write_string(1, 0, "Number of Redo Participants")
worksheet.write_string(1, 1, str(len(redo_index)))
worksheet.write_string(2, 0, "Sum of all redo participants ")
worksheet.write_string(2, 1, str(redo_sum))
worksheet.write_string(3, 0, "Sum of all non-phase participants (except redo) ")
worksheet.write_string(3, 1, str(non_redo_sum))
worksheet.write_string(4, 0, "Average % Difference ")
worksheet.write_string(4, 1, str('Insert number here'))
writer.save()
def sort_ph2(test_case_removal):
current_date = str(datetime.datetime.now().strftime("%Y-%m-%d"))
ph = Phase2(bool(test_case_removal),concat=True)
ph.filterPhaseReports()
ph.report=ph.sort_repo('email')
df=ph.consolidate_repo()
both_survey_completed= ph.both_survey_completed(df)
res=ph.percent_difference(df,both_survey_completed)
bgf,bdf,bgs,bds = ph.get_people_and_scores(df, both_survey_completed)
total_improved_scores, percent_improvement= ph.calculate_improvement( bgf, bdf,bgs,bds )
bg_only_ppl, bd_only_ppl = ph.single_bag_boss_list(df)
output = Output(res[0],'2')
output.do_it_all(res[3])
total_participants = len(output.df)
## writer = pd.ExcelWriter('/var/www/html/flaskapp/Output/Phase2 '+current_date+'.xlsx', engine='xlsxwriter')
writer = pd.ExcelWriter('./../Output/Phase2 '+current_date+'.xlsx',engine='xlsxwriter')
output.df.to_excel(writer,startcol = 0, startrow = 15,index=False)
worksheet = writer.sheets['Sheet1']
worksheet.write_string(0, 0, 'EmQ Phase 2 Export – '+current_date)
worksheet.write_string(2, 0, "Phase 2 both quizzes completed ")
worksheet.write_string(2, 8, str(len(both_survey_completed)))
worksheet.write_string(3, 0, "Bagging Grocery only people ")
worksheet.write_string(3, 8, str(len(bg_only_ppl)))
worksheet.write_string(4, 0, "Boss' Dinner only people ")
worksheet.write_string(4, 8, str(len(bd_only_ppl)))
worksheet.write_string(5, 0, "Both surveys done - Bagging Grocery first")
worksheet.write_string(5, 8, str(len(bgf)))
worksheet.write_string(6, 0, "Both surveys done - Boss' Dinner Second")
worksheet.write_string(6, 8, str(len(bds)))
worksheet.write_string(7, 0, "BGF, BDS - Average Difference")
worksheet.write_string(7, 8, str(ph.average_difference(bgf,bds)))
worksheet.write_string(8, 0, "Both surveys done - Boss' Dinner first")
worksheet.write_string(8, 8, str(len(bdf)))
worksheet.write_string(9, 0, "Both surveys done - Bagging Grocery Second")
worksheet.write_string(9, 8, str(len(bgs)))
worksheet.write_string(10, 0, "BDF, BGS - Average Difference")
worksheet.write_string(10, 8, str(ph.average_difference(bdf,bgs)))
worksheet.write_string(11, 0, "Total people with improved scores")
worksheet.write_string(11, 8, str(total_improved_scores))
worksheet.write_string(12, 0, "Average % improvement")
worksheet.write_string(12, 8, str(percent_improvement))
worksheet.write_string(13, 0, "Average improvement")
worksheet.write_string(13, 8, str(ph.average_difference(bgf,bds)-ph.average_difference(bdf,bgs)))
writer.save()
def sort_ph1(test_case_removal):
current_date = str(datetime.datetime.now().strftime("%Y-%m-%d"))
ph = Phase1(bool(test_case_removal),concat=True)
ph.filterPhaseReports()
ph.report=ph.sort_repo('email')
df=ph.consolidate_repo()
both_survey_completed= ph.both_survey_completed(df)
bg_ppl,bg_scores,bd_ppl,bd_scores = ph.get_total_scores_and_people(df)
res=ph.percent_difference(df,both_survey_completed)
bg_scores = [float(x) for x in bg_scores]
bd_scores = [float(x) for x in bd_scores]
avg_bg_scores = float(sum(bg_scores)/len(bg_ppl))
avg_bd_scores = float(sum(bd_scores)/len(bd_ppl))
output = Output(res[0],'1')
output.do_it_all(res[3])
total_participants = len(output.df)
## writer = pd.ExcelWriter('/var/www/html/flaskapp/Output/Phase1 '+current_date+'.xlsx',engine='xlsxwriter')
writer = pd.ExcelWriter('./../Output/Phase1 '+current_date+'.xlsx',engine='xlsxwriter')
output.df.to_excel(writer,startcol = 0, startrow = 11,index=False)
worksheet = writer.sheets['Sheet1']
worksheet.write_string(0, 0, 'EmQ Phase 1 Export – '+current_date)
worksheet.write_string(1, 0, "Phase 1 both quizzes completed ")
worksheet.write_string(1, 8, str(len(both_survey_completed)))
worksheet.write_string(2, 0, "Total Phase1 Participants ")
worksheet.write_string(2, 8, str(total_participants))
worksheet.write_string(3, 0, "Total BG Participants ")
worksheet.write_string(3, 8, str(len(bg_ppl)))
worksheet.write_string(4, 0, "Total BD Participants ")
worksheet.write_string(4, 8, str(len(bd_ppl)))
worksheet.write_string(5, 0, "Total BG scores ")
worksheet.write_string(5, 8, str(sum(bg_scores)))
worksheet.write_string(6, 0, "Total BD scores ")
worksheet.write_string(6, 8, str(sum(bd_scores)))
worksheet.write_string(7, 0, "Average of Bagging Grocery scores ")
worksheet.write_string(7, 8, str(avg_bg_scores))
worksheet.write_string(8, 0, "Average of Boss' Dinner scores ")
worksheet.write_string(8, 8, str(avg_bd_scores))
worksheet.write_string(9, 0, "Average Difference (BG - BD) ")
worksheet.write_string(9, 8, str(avg_bg_scores- avg_bd_scores ))
writer.save()
