Python+MySQL查询基本操作+并使用matplotlib绘制条形图

# 1000本图书中前10个出版社出版的图书个数进行条形图的展示
# matplotlib - 条形图 bar -- 垂直条形图
import pymysql
from matplotlib import pyplot as plt
from matplotlib.font_manager import FontProperties
# 获取出版社和书数量
def getbookinfo():
    # 1- 连接数据库
    connect = pymysql.connect(host="localhost",
                              user="root",
                              password="mysql",
                 database="dangdang_book",
                              port=3306,
                              charset='utf8')
    # 2- 执行sql
    cursor = connect.cursor()
    select = """
            select 出版社,count(书名) 数量 
            from tbl_books
            where char_length(出版社)!=1
            group by 出版社
            order by 数量 desc
            limit 10
            """
    cursor.execute(select)
    result = cursor.fetchall()
    x = []   # 存储10个出版社
    y = []   # 存储10个出版社的书籍数量
    for r in result: