功能:
通过使用pyecharts,将爬虫爬取的csv数据转换为html的可交互图表。
代码:
from pyecharts.charts import Bar
from pyecharts import options as opts
import pandas as pd
import numpy as np
import re
ds=pd.read_excel('B站排名前100的视频汇总(2021-11-24)(日榜).xls')
height, width = ds.shape
data = ds.copy()
views = data["播放量"]
length = len(views)
# bar = Bar()
bar = Bar(init_opts=opts.InitOpts(width="1600px", height="2500px"))
bar.add_xaxis(data["up主名字"].tolist())
bar.add_yaxis("播放量", data["播放量"].tolist(), stack="stack1", category_gap='20%').reversal_axis()
bar.add_yaxis("评论数", data["评论数"].tolist(), stack="stack1").reversal_axis()
bar.add_yaxis("综合得分", data["综合得分"].tolist(), stack="stack1").reversal_axis()
bar.set_global_opts(title_opts=opts.TitleOpts(title="Bar-堆叠数据(全部)"))
bar.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
bar.set_series_opts(label_opts=opts.LabelOpts(position="right"))
bar.set_series_opts(label_opts=opts.LabelOpts(is_show=False))
bar.set_global_opts(toolbox_opts=opts.ToolboxOpts(is_show=True))
# bar.set_colors(['#0b2e4a','#003366', '#366092', '#95b3d7', '#b8cce4','#dce6f1'])
# bar.width = '100%'
# bar.height = '1000%'
bar.render("播放量统计.html")
数据源文件如下:

转换HTML效果如下:

