学习笔记(35):21天通关Python（仅视频课）-水平柱状图和水平折线图

立即学习:https://edu.youkuaiyun.com/course/play/24797/282216?utm_source=blogtoedu

'''
柱状图：Bar
线型图：Line
柱状图水平：HorizontalBar
线型图水平：HorizontalLine
Line()
'''
import  pygal
import sqlite3

fenshulevel = [10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 110, 120, 130, 140, 150]
namelist = []
fenshulist = []
conn = sqlite3.connect('test62.db')
c = conn.execute('select * from user_tb')
for itm in c:
    namelist.append(itm[1])
    fenshulist.append(itm[2])

# # 创建线型视图
# line = pygal.Line()
# # 添加数据
# line.title = '考试分数详情'
# line.add('课程', fenshulist)
# line.x_labels = namelist
# line.y_labels = fenshulevel
# line.x_title = '课程名称'
# line.y_title = '分数'
# # 特特效
# #X轴标签 倾斜45度
# line.x_label_rotation  = 45
# 
# line.render_to_file('test62_line.svg')

# 创建水平柱状图视图
line = pygal.HorizontalBar()
# 添加数据
line.title = '考试分数详情'
line.add('课程', fenshulist)
line.x_labels = namelist
line.y_labels = fenshulevel
line.x_title = '课程名称'
line.y_title = '分数'
# 特特效
#X轴标签 倾斜45度
line.x_label_rotation  = 45

line.render_to_file('test62_HorizontalBar.svg')

# 创建水平线型图视图
line = pygal.HorizontalLine()
# 添加数据
line.title = '考试分数详情'
line.add('课程', fenshulist)
line.x_labels = namelist
line.y_labels = fenshulevel
line.x_title = '课程名称'
line.y_title = '分数'
# 特特效
#X轴标签 倾斜45度
line.x_label_rotation  = 45

line.render_to_file('test62_HorizontalLine.svg')