def create_gender(data):
df = data.copy()
# 修改数值
df.loc[df.gender == '0', 'gender'] = '未知'
df.loc[df.gender == '1', 'gender'] = '男性'
df.loc[df.gender == '2', 'gender'] = '女性'
# 根据性别分组
gender_message = df.groupby(['gender'])
# 对分组后的结果进行计数
gender_com = gender_message['gender'].agg(['count'])
gender_com.reset_index(inplace=True)
# 饼图数据
attr = gender_com['gender']
v1 = gender_com['count']
# 初始化配置
pie = Pie(init_opts=opts.InitOpts(width="800px", height="400px"))
# 添加数据，设置半径
pie.add("", [list(z) for z in zip(attr, v1)], radius=["40%", "75%"])
# 设置全局配置项，标题、图例、工具箱(下载图片)
pie.set_global_opts(title_opts=opts.TitleOpts(title="抖音大V性别分布情况",
pos_left="center"),
legend_opts=opts.LegendOpts(orient="vertical",
pos_left="left"),
toolbox_opts=opts.ToolboxOpts(
is_show=True, feature={"saveAsImage": {}}))
# 设置系列配置项，标签样式
pie.set_series_opts(
label_opts=opts.LabelOpts(is_show=True, formatter="{b}:{d}%"))
pie.render("抖音大V性别分布情况.html")
def get_pie(city, center1, center2):
data = df.loc[df['City'] == city, ['Date', 'AQI_Bucket']]
rank_message = data.groupby(['AQI_Bucket'])
rank_com = rank_message['AQI_Bucket'].agg(['count'])
rank_com.reset_index(inplace=True)
rank_com_last = rank_com.sort_values('count', ascending=False)
x = rank_com_last['AQI_Bucket']
y = rank_com_last['count']
pie = Pie(init_opts=opts.InitOpts(width='400px', height='300px'))
input_data = [list(z) for z in zip(x, y)]
pie.add(city, input_data, center=center1, radius=['15%', '30%'])
pie.set_series_opts(label_opts=opts.LabelOpts(formatter='{b}：{d}%'))
pie.set_global_opts(title_opts=opts.TitleOpts(
title=city,
pos_left=center2[0],
pos_top=center2[1],
),
legend_opts=opts.LegendOpts(is_show=False))
return pie
def pie_set_colors():
obj_pie = Pie()
obj_pie.add("",[list(z) for z in zip(Faker.choose(), Faker.values())])
obj_pie.set_colors(["blue", "green", "yellow", "red", "pink", "orange", "purple"])
obj_pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
obj_pie.set_global_opts(title_opts=opts.TitleOpts(title="Pie-设置颜色",subtitle ="副标题"))
return obj_pie
def draw_category_pie(inner,
outside,
inner_title="分类报表",
outer_title='小类报表',
width=2000) -> Pie:
pie = Pie()
inner_radius = "70%"
outer_radius = "80%"
pie.add(
series_name=inner_title,
data_pair=inner,
radius=["0%", inner_radius],
label_opts=opts.LabelOpts(position="inner"),
)
pie.add(
series_name=outer_title,
radius=[inner_radius, outer_radius],
data_pair=outside,
label_opts=opts.LabelOpts(
position="outside",
formatter="{b}:\n{c}({d}%)",
border_width=1,
border_radius=4,
),
)
pie.set_global_opts(legend_opts=opts.LegendOpts(pos_left="left",
orient="vertical"), )
pie.set_series_opts(tooltip_opts=opts.TooltipOpts(
trigger="item", formatter="{a} <br/>{b}: {c} ({d}%)"))
return pie
def analyze_remark_name():
close_partner_dict = {
'宝宝,糙糙,仙女,亲爱,老婆': 0,
'老公': 0,
'父亲,爸': 0,
'母亲,妈': 0,
'闺蜜,死党,基友': 0
}
# 遍历好友数据
for user in friends:
for key in close_partner_dict.keys():
# 判断该好友备注名是否包含close_partner_dict中的任意一个key
name = key.split(',')
for sub_name in name:
if (sub_name in user.remark_name):
close_partner_dict[key] += 1
break
name_list = ['最重要的她', '最重要的他', '爸爸', '妈妈', '死党']
num_list = [x for x in close_partner_dict.values()]
pie = Pie()
pie.add("可能是你最亲密的人", [list(z) for z in zip(name_list, num_list)])
pie.set_global_opts(title_opts=opts.TitleOpts(title="可能是你最亲密的人"))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
pie.render('data/你最亲密的人.html')
def mkhtml2(name1):
"""
饼图
:return:生成豆瓣top250电影产源国家数量占比分析图html文件
"""
# ORM查询
myresult = Test.objects.values('address').annotate(
count=Count('name')).order_by('-count')[:10]
# fetchall() 获取所有记录
namelist = []
# 将变量存在列表里
numlist = []
for name in myresult:
namelist.append(name['address'])
numlist.append(name['count'])
pie = Pie()
pie.add(
"占比",
[list(z) for z in zip(namelist, numlist)],
center=["40%", "60%"],
)
pie.set_global_opts(
title_opts=opts.TitleOpts(title="豆瓣top250电影产源国家数量占比"),
legend_opts=opts.LegendOpts(pos_left="35%"),
)
# 设置显示的样子，加入了百分比
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c} ({d}%)"))
pie.render(f'{name1}')
print(f'{name1}已生成')
def statistics_friends():
# 初始化
unknown, known_male, known_female, known_other = 0, 0, 0, 0
# 遍历
for user in friends:
# 备注不为空
if ((user.remark_name).strip()):
if (user.sex == 1):
known_male += 1
elif (user.sex == 2):
known_female += 1
else:
known_other += 1
else:
unknown += 1
name_list = ['未设置备注的好友', '设置备注的男性好友', '设置备注的女性好友', '设置备注的其他好友']
num_list = [unknown, known_male, known_female, known_other]
pie = Pie()
pie.add("你认识的好友比例", [list(z) for z in zip(name_list, num_list)])
pie.set_global_opts(title_opts=opts.TitleOpts(title="你认识的好友比例"))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
pie.render('data/你认识的好友比例.html')
def show_pie_charts(df):
score_perc = df['star'].value_counts() / df['star'].value_counts().sum(
) # 评分占比 = 评分1-5的个数(分别) / 评分总个数
score_perc = np.round(score_perc * 100, 2)
score_perc = score_perc.sort_index() # Series也可以排序
# 聚合后类型为Series，转成Dataframe
# df_score = pd.DataFrame(list(zip(score_perc.index, score_perc.values)), columns=['score', 'percentage']).sort_values('score')
pie1 = Pie(init_opts=opts.InitOpts(width='1350px', height='750px'))
pie1.add(
series_name='评分占比',
data_pair=[*zip(score_perc.index, score_perc.values)
], # Series: zip打包为一个元组对象，用*解压成元组，再[]转成列表
# data_pair=[*zip(df_score['score'], df_score['percentage'])], # Dataframe
label_opts=opts.LabelOpts(formatter='{c}%'), # formatter='{c}%'百分比
radius=['35%', '70%'] # 是什么意思
)
pie1.set_global_opts(
title_opts=opts.TitleOpts(title='总体评分分布'),
legend_opts=opts.LegendOpts(orient='vertical',
pos_top='15%',
pos_left='2%'), # 图例的位置：水平/垂直
toolbox_opts=opts.ToolboxOpts()) # 右上角的工具栏，保存图片等等
pie1.set_colors(['#D7655A', '#FFAF34', '#3B7BA9', '#EF9050', '#6FB27C'])
pie1.render('charts/pie_chart.html')
def Pie_base(sql, titl) -> Pie:
pie = Pie()
# engine = create_engine("mysql+pymysql://root:root@localhost:3306/mysql", encoding="utf-8")
# session = sessionmaker(bind=engine)
# # sql= "select gzlx as 故障类型,count(1) as 数量 from b_epos where rq BETWEEN '%s' and '%s' group by gzlx"% (rq1, rq2)
# df = pd.read_sql(sql, engine)
# rows=df.values.tolist()
# headers=df.columns.tolist()
with SQLPoll() as db:
students = db.fetch_all(sql, None)
headers = []
for student in students:
headers = list(student.keys())
break
c = []
rows = []
for student in students:
c = list(student.values())
rows += [c]
if len(rows) == 0:
rows = [['无', 0]]
pie.add("", rows)
pie.set_global_opts(title_opts=opts.TitleOpts(title=titl))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {d}%"))
return pie
def draw_multiple_pie(month, day):
max_width, max_height = 1400, 3000
pie = Pie(init_opts=opts.InitOpts(width='{}px'.format(max_width),
height='{}px'.format(max_height)))
pie.set_global_opts(legend_opts=opts.LegendOpts(is_show=False),
title_opts=opts.TitleOpts(
title='2020-%02d-%d 全国各省份城市确诊病例' % (month, day)))
h_center, v_center = 10, 40
horizontal_step, vertical_step = 350, 320
for p in get_province_data(month, day):
title = '%s-%d例' % (p['provinceShortName'], p['confirmedCount'])
labels = [city['cityName'] for city in p['cities']]
counts = [city['confirmedCount'] for city in p['cities']]
if len(labels) == 0:
continue
pie.add(title, [list(z) for z in zip(labels, counts)],
radius=[5, 80],
center=[h_center + 150, v_center + 110]).set_series_opts(
label_opts=opts.LabelOpts(formatter="{b}: {c}"),
tooltip_opts=opts.TooltipOpts())
h_center += horizontal_step
if h_center + 200 > max_width:
h_center = 10
v_center += vertical_step
root = 'html-charts/%d%d' % (month, day)
create_dir(root)
pie.render('%s/省份信息.html' % root)
def MutiplePieCharts(datas):
height_i = '450'
if len(datas) > 3:
height_i = height_i + (350 * (len(datas) // 3))
height = str(height_i) + 'px'
pie = Pie(init_opts=opts.InitOpts(width="100%", height=height))
left_i = 1
right_i = 1
for data in datas:
right = str(300 * right_i) + 'px'
if left_i == 1:
left = '20%'
left_i = 2
elif left_i == 2:
left = '50%'
left_i = 3
else:
left = '80%'
right_i += 1
left_i = 1
pie.add(
data[0],
data[1],
center=[left, right],
radius=120,
)
pie.set_global_opts(title_opts=opts.TitleOpts(title="磁盘使用率"), )
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"), )
return pie.render_embed()
def order_chart():
# 今日各状态订单总金额
pie2 = Pie()
pie2.add("", list(order_status_total.items()))
pie2.set_global_opts(title_opts=opts.TitleOpts(title="今日各状态订单总金额"))
pie2.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
return pie2.dump_options_with_quotes()
def pie_two_html(self, chart_id, title, sub_title1, sub_title2, key1, key2, val1, val2):
# 实例化饼状图
pie = Pie(init_opts=opts.InitOpts(width="100%", height="300px"))
pie.set_global_opts(
title_opts=opts.TitleOpts(
title="{}-{}".format(self.dt, title),
title_textstyle_opts=opts.TextStyleOpts(color="white", font_size=14),
pos_left="center"
),
legend_opts=opts.LegendOpts(is_show=False),
)
pie.chart_id = chart_id
# print("key1: %s" % key1)
# print("val1: %s" % val1)
pie.add(
sub_title1,
[list(z1) for z1 in zip(key1, val1)],
center=[300, 160],
radius=[30, 75],
)
pie.add(
sub_title2,
[list(z2) for z2 in zip(key2, val2)],
center=[1100, 160],
radius=[30, 75],
)
return pie.render_embed()
def pie_echart():
keys = ['男性', '女性']
values = [7322452, 7438028]
data = zip(keys, values)
c = Pie()
c.add("饼状图", list(data))
c.set_global_opts(title_opts=opts.TitleOpts(title='男女比例情况'))
return c
def drawpie(self, title, infos):
from pyecharts.charts import Pie
from pyecharts import options as opts
pie = Pie(init_opts=dict(theme='westeros', page_title=title)).add(
title,
data_pair=tuple(zip(infos.keys(), infos.values())),
rosetype='area')
pie.set_global_opts(title_opts=opts.TitleOpts(title=title))
pie.render(os.path.join(self.savedir, '%s.html' % title))
def sexAnalyse(itemname_, itemnamelist_, itemnumlist_):
totle = itemnumlist_[0] + itemnumlist_[1] + itemnumlist_[2]
subtitle = "共有:%d个好友" % totle
pie = Pie()#新建饼图对象
pie.add("",[list(z) for z in zip(itemnamelist_,itemnumlist_)],center=["35%", "50%"])#饼图对象数据添加
pie.set_global_opts(title_opts=opts.TitleOpts(title=subtitle),legend_opts=opts.LegendOpts(pos_left="15%"),)
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
outFileName = itemname_+ '.html'
pie.render(outFileName)#保存饼图对象
def get_pie(labels, counts, title, size):
pie = Pie(init_opts=opts.InitOpts(width=size[0], height=size[1]))
pie.set_global_opts(legend_opts=opts.LegendOpts(is_show=False), title_opts=opts.TitleOpts(title))
pie.add(
title,
[list(z) for z in zip(labels, counts)],
radius=[5, 80],
).set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"), tooltip_opts=opts.TooltipOpts())
return pie
def pie_render_air(self):
"""
* 实心圆一个，仅支持一份参数；
"""
# c = Pie(init_opts=opts.InitOpts(width="1600px", height="800px"))
c = Pie()
c.add(
series_name=self.y_name,
# radius=["40%", "55%"], # 半圆的尺寸；
radius=[0, "55%"],
data_pair=self.inner_data_pair,
label_opts=opts.LabelOpts(
position="outside",
formatter="{a|{a}}{abg|}\n{hr|}\n {b|{b}: }{c} {per|{d}%} ",
background_color="#eee",
border_color="#aaa",
border_width=1,
border_radius=4,
rich={
"a": {
"color": "#999",
"lineHeight": 22,
"align": "center"
},
"abg": {
"backgroundColor": "#e3e3e3",
"width": "100%",
"align": "right",
"height": 22,
"borderRadius": [4, 4, 0, 0],
},
"hr": {
"borderColor": "#aaa",
"width": "100%",
"borderWidth": 0.5,
"height": 0,
},
"b": {
"fontSize": 16,
"lineHeight": 33
},
"per": {
"color": "#eee",
"backgroundColor": "#334455",
"padding": [2, 4],
"borderRadius": 2,
},
},
),
)
c.set_global_opts(title_opts=opts.TitleOpts(title=self.title),
legend_opts=opts.LegendOpts(pos_left=self.pos_left,
orient="vertical"))
c.set_series_opts(tooltip_opts=opts.TooltipOpts(
trigger="item", formatter="{a} <br/>{b}: {c} ({d}%)"))
return c
def sex_chart(data, movie_id):
list = []
data = data['gender'].value_counts()
for key, v in enumerate(data):
list.append([sex[key], v])
pie = Pie()
pie.add("", list)
pie.set_global_opts(title_opts=opts.TitleOpts(title="评论用户性别分布饼图"))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
pie.render('user_sex_' + movie_id + '.html')
def show_pie(id):
attr = ["成功（含熔断）", "失败", "限流"]
counts = [len(sync.success), len(sync.fail), sync.limit]
c = Pie(init_opts=opts.InitOpts(
width='1200px', height='800px', page_title='page'))
c.add("", [list(attr) for attr in zip(attr, counts)])
c.set_colors(["green", "red", "blue"])
c.set_global_opts(title_opts=opts.TitleOpts(title="成功失败数量饼图"))
c.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
c.render('成功失败数量饼图{}.html'.format(id + 1))
def pie_render_genre(self):
c = Pie()
c.add(self.y_name, self.inner_data_pair, center=["35%", "50%"])
c.set_global_opts(title_opts=opts.TitleOpts(title=self.title),
legend_opts=opts.LegendOpts(pos_left=self.pos_left,
orient="vertical"))
c.set_series_opts(tooltip_opts=opts.TooltipOpts(
trigger="item", formatter="{a} <br/>{b}: {c} ({d}%)"),
label_opts=opts.LabelOpts(formatter="{b}: {d}%"))
return c
def pie():
pie = Pie(init_opts=opts.InitOpts(
theme=ThemeType.PURPLE_PASSION, width="1280px", height="1080px"))
pie.add(
"",
[list(z) for z in zip(data["项目简称"].to_list(), data["母婴"].to_list())],
radius=["40%", "75"])
pie.set_global_opts(
title_opts=opts.TitleOpts(title="各类母婴产品", pos_bottom='50%'))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}:{c}"))
pie.render('../graph/5.4(各类母婴产品盈利).html')
def pie_radius():
obj_pie = Pie()
# radius=["40%", "75%"]饼图的半径，数组的第一项是内半径，第二项是外半径
obj_pie.add("",[list(z) for z in zip(Faker.choose(), Faker.values())],radius=["40%", "75%"],)
obj_pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
obj_pie.set_global_opts(
title_opts=opts.TitleOpts(title="Pie-Radius",subtitle ="副标题"),
# 让图例legend显示到左侧
legend_opts=opts.LegendOpts(orient="vertical", pos_top="15%", pos_left="2%"),
)
return obj_pie
def drawPie(title, data, savepath='./results'):
if not os.path.exists(savepath):
os.mkdir(savepath)
pie = Pie()
attrs = [i for i, j in data.items()]
values = [j for i, j in data.items()]
pie.add("", [list(z) for z in zip(attrs, values)])
pie.set_global_opts(title_opts=opts.TitleOpts(title="评分情况"),
legend_opts=opts.LegendOpts(pos_left=160))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}:{c}"))
pie.render(os.path.join(savepath, '%s.html' % title))
def get_message_type_frequency(file_path, wxid):
"""
:param file_path: 经过预处理后的message表存储位置
:param wxid: 待查询人的微信id
:return:
"""
# file_path = r'D:\wechet-anayze\pre-message-2.txt'
message = pd.read_csv(file_path, sep=',', encoding='utf-8', low_memory=False)
# wxid = ''
# 进行数据筛选，选择message表中与所需微信id一致的数据
message = message[message['talker'] == wxid]
# 根据消息类型统计每种类型的频次（索引为数字编码）
chat_type_count = message['type'].groupby(message['type']).size()
# 消息类型对应关系
message_type = {'1': '文本内容', "3": "图片及视频", "34": "语音消息", "42": "名片信息", "43": "图片及视频",
"47": "表情包", "48": "定位信息", "49": "小程序链接", "10000": "消息撤回提醒", "1048625": "网络照片",
"16777265": "链接信息", "419430449": "微信转账", "436207665": "红包", "469762097": "红包",
"-1879048186": "位置共享"}
# 集合对象，功能与chat_type_count相同，存储（聊天类型：频次）信息（索引为对应中文类型）
chat_type_count_dict = {}
# 根据消息类型代码
for key in chat_type_count.index:
if str(key) in message_type.keys():
print(message_type.get(str(key)))
chat_type_count_dict[message_type.get(str(key))] = chat_type_count[key]
else:
chat_type_count_dict[key] = chat_type_count[key]
print("结果集类型: ", type(chat_type_count_dict))
print(chat_type_count_dict)
x_data = []
y_data = []
for key in chat_type_count_dict:
temp = [str(key), chat_type_count_dict.get(key)]
x_data.append(str(key))
y_data.append(int(chat_type_count_dict.get(key)))
a1 = []
for z in zip(x_data, y_data):
a1.append(z)
pie = Pie(init_opts=opts.InitOpts(width="1600px", height="600px", page_title="消息类型统计"))
pie.add(
"",
data_pair=a1,
center=["35%", "60%"],
)
pie.set_global_opts(
title_opts=opts.TitleOpts(title="Pie-调整位置"),
legend_opts=opts.LegendOpts(pos_left="15%"),
)
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}:{c}"))
pie.render("message_type_count.html")
def level_pie(data):
level_list = [[i, j]
for i, j in enumerate(data['userlevel'].value_counts())]
pie = Pie()
pie.add("", level_list, radius=["40%", "75%"])
pie.set_global_opts(title_opts=opts.TitleOpts(title="等级分布"),
legend_opts=opts.LegendOpts(orient="vertical",
pos_top="15%",
pos_left="2%"))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
pie.render("等级分布.html")
def analysisSex(self, title='分析好友性别分布', friends_info=None):
sex_infos = {'男': 0, '女': 0, '未知': 0}
for item in friends_info.get('sex'):
if item == 0: sex_infos['未知'] += 1
elif item == 1: sex_infos['男'] += 1
elif item == 2: sex_infos['女'] += 1
pie = Pie(init_opts=dict(theme='westeros', page_title=title)).add(
title,
data_pair=tuple(zip(sex_infos.keys(), sex_infos.values())),
rosetype='area')
pie.set_global_opts(title_opts=opts.TitleOpts(title=title))
pie.render(os.path.join(self.savedir, '%s.html' % title))
def generate_pie_html(dict_rows, key, value):
data = []
for row in dict_rows:
data.append([row[key], round(row[value], 2)])
pie = Pie(init_opts=opts.InitOpts(theme=ThemeType.SHINE))
pie.add("", data)
# pie.set_global_opts(title_opts=opts.TitleOpts(title="我的摊大饼策略分布"))
pie.set_global_opts(legend_opts=opts.LegendOpts(is_show=False))
pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {d}%"))
pie_html = pie.render_embed('template.html', env)
return pie_html
def pie_radius_chart(data_pie):
c = Pie()
c.add(series_name='類別', data_pair=data_pie, radius=['40%', '75%'])
c.set_global_opts(title_opts=opts.TitleOpts(title='各種類占比'),
legend_opts=opts.LegendOpts(orient='vertical',
pos_top='15%',
pos_left='2%'))
c.set_series_opts(tooltip_opts=opts.TooltipOpts(
trigger='item', formatter='{a} <br/> {b}:{c} ({d}%)'),
label_opts=opts.LabelOpts(formatter="{b}:{c}%"))
return c
def pie_position():
obj_pie = Pie()
# center=["35%", "50%"]
# 饼图的中心（圆心）坐标，数组的第一项是横坐标，第二项是纵坐标
# 默认设置成百分比，设置成百分比时第一项是相对于容器宽度，第二项是相对于容器高度
obj_pie.add("",[list(z) for z in zip(Faker.choose(), Faker.values())],center=["35%", "50%"])
obj_pie.set_series_opts(label_opts=opts.LabelOpts(formatter="{b}: {c}"))
obj_pie.set_global_opts(
title_opts=opts.TitleOpts(title="Pie-设置位置",subtitle ="副标题"),
legend_opts=opts.LegendOpts(pos_left="15%"),
)
return obj_pie
