def create_combine_charts(dataframe): page = Page() # df= get_df_fromSQL('ori_data') df_new = pd.DataFrame() list1 = coltype_filter(dataframe, '套餐类型') num = len(list1) v1 = [x for x in range(0, num)] v2 = [x for x in range(0, num)] v3 = [x for x in range(0, num)] v4 = [x for x in range(0, num)] for i in range(0, num): df_new = detailed_info_filter(dataframe, '套餐类型', [list1[i]]) v1[i] = month_Chuzhang(df_new) for i in range(0, num): df_new = detailed_info_filter(dataframe, '套餐类型', [list1[i]]) v2[i] = APRU_Chuzhang(df_new) # for i in range(0,num): # df=dataframe[dataframe['套餐类型']==list1[i]] # v3[i]=MOU(df) # for i in range(0,num): # df = dataframe[dataframe['套餐类型']==list1[i]] # v4[i]=DOU(df) chart = Bar("数据分析", '总收入/平均出帐收入/MOU/DOU') chart.add('总收入', list, v1) chart.add("月平均收入", list, v2) # chart.add('MOU',list,v3) # chart.add('DOU',list,v4) page.add(chart) return page
def create_iprv3_charts(df): page = Page() list3 = coltype_filter(df, '账期') list3.sort() n = len(list3) v1 = [x for x in range(0, n)] for i in range(0, n): df_new = df[df['账期'] == list3[i]] yearIncome = month_Chuzhang(df_new) v1[i] = yearIncome # monthIncome = yearIncome/n list5 = All_DOU(df) list6 = all_MOU(df) list7 = all_APRU(df) page = Page() v2 = [x for x in range(0, n)] charts1 = Line("各月份比较") charts1.add('income', list3, v1) charts1.add("DOU", list3, list5) charts1.add("MOU", list3, list6) # charts3 =Line('APRU') charts1.add("APRU", list3, list7) page.add(charts1) # page.add(charts2) # page.add(charts3) return page
def create_total_charts(df): page = Page() df_new = pd.DataFrame() list1 = coltype_filter(df, '套餐类型') num = len(list1) v1 = [x for x in range(0, num)] for i in range(0, num): df_new = df[df['套餐类型'] == list1[i]] v1[i] = month_Chuzhang(df_new) # v2 = [10, 25, 8, 60, 20, 80] v2 = [x for x in range(0, num)] for i in range(0, num): df_new = df[df['套餐类型'] == list1[i]] v2[i] = APRU_Chuzhang(df_new) v3 = [x for x in range(0, num)] for i in range(0, num): df_new = df[df['套餐类型'] == list1[i]] v3[i] = MOU(df_new) v4 = [x for x in range(0, num)] for i in range(0, num): df_new = df[df['套餐类型'] == list1[i]] v4[i] = DOU(df_new) chart = Bar("数据分析", "月总收入/平均收入/MOU/DOU") chart.add("月总收入", list1, v1) chart.add("各套餐平均收入", list1, v2) chart.add("MOU", list1, v3) chart.add("DOU", list1, v4) # chart.add("月平均收入", attr, v2, is_stack=True, is_more_utils=True) page.add(chart) return page
def total_everymonth_charts(dataframe): page = Page() list1 = coltype_filter(dataframe, '账期') df_new = pd.DataFrame() num = len(list1) v1 = [x for x in range(0, num)] v2 = [x for x in range(0, num)] for i in range(0, num): df_new = detailed_info_filter(dataframe, '账期', [list1[i]]) v1[i] = month_Chuzhang(df_new) chart = Line("折线图", '一年的降水量') chart.add("降水量", list1, v1, is_label_show=True) page.add(chart) return page
def sameUserDataframe(df, numlist): df_new = df[df['用户标识'] == numlist] list3 = coltype_filter(df, '账期') list3.sort() n = len(list3) yearIncome = month_Chuzhang(df_new) # monthIncome = yearIncome/n list5 = All_DOU(df) list6 = all_MOU(df) list7 = all_APRU(df) page = Page() charts1 = Line("DOU") charts1.add(str(numlist) + "的DOU", list3, list5) # charts2 = Line("MOU") charts1.add(str(numlist) + "的MOU", list3, list6) # charts3 =Line('APRU') charts1.add(str(numlist) + "的APRU", list3, list7) page.add(charts1) # page.add(charts2) # page.add(charts3) return page