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