python读xls数据图表化_S展翅飛

个人资料

微博

正文字体大小：大中小

python读xls数据图表化

(2022-04-11 14:25:02)

分类： python

from pyecharts import options as opts

from pyecharts.charts import Bar

from pyecharts.options.global_options import ThemeType

import pandas as pd

aa = pd.read_excel('2.xls', sheet_name=0)

c = Bar(init_opts=opts.InitOpts(#bg_color='rgba(255,250,205,0.2)',

width='1600px',

height='1024px',

page_title='soolenv',

theme=ThemeType.LIGHT)

)

c.add_xaxis(list(aa.loc[:, '团队名']))

c.add_yaxis('锁客日均', list(aa.loc[:, '锁客日均']))

c.add_yaxis('锁客日人均', list(aa.loc[:, '锁客日人均']))

c.set_global_opts(

xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=-90)),

title_opts=opts.TitleOpts(title="团队锁客", subtitle="啦啦啦啦"),

)

c.render("2.html")

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report