用SQL取代pandas 聚合运算结合plot画图的方法案例

python;gutter:true;</p> <h1>!/usr/bin/python</h1> <h1>-<em>- coding: -</em>-</h1> <p>import matplotlib.pyplot as plt import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv) import pymssql # 引入pymssql模块 import seaborn as sns # Provides a high level interface for drawing attractive and informative statistical graphics from matplotlib.font_manager import FontProperties from pylab import * import matplotlib.pyplot as plt import seaborn as sns</p> <p>plt.rcParams['font.sans-serif'] = ['SimHei']</p> <h1>Matplotlib中设置字体-黑体,解决Matplotlib中文乱码问题</h1> <p>plt.rcParams['axes.unicode_minus'] = False</p> <h1>解决Matplotlib坐标轴负号'-'显示为方块的问题</h1> <p>sns.set(font='SimHei')</p> <h1>Seaborn中设置字体-黑体,解决Seaborn中文乱码问题</h1> <p>import warnings # Ignore warning related to pandas_profiling warnings.filterwarnings('ignore') conn = pymssql.connect(host='localhost', user='wonderful', password='wonderful', database='ProcreateV93',charset='GBK')</p> <p>font = FontProperties(fname=r"c:\windows\fonts\simsun.ttc", size=10) sql = "select username,COUNT(DISTINCT o_id) AS Oidcount from Oplan GROUP BY username order by Oidcount desc " df0 = pd.read_sql(sql, conn) df = pd.DataFrame(df0)</p> <h1>orient='h'表示是水平展示的,alpha表示颜色的深浅程度</h1> <h1>设置y轴、X轴的坐标名字与字体大小</h1> <p>sns.barplot(x=df.username.values,y=df.Oidcount.values,orient='v', color='green')</p> <p>plt.xlabel('医生') plt.ylabel('患者数')</p> <h1>设置X轴的各列下标字体是水平的</h1> <p>plt.xticks(rotation='horizontal')</p> <h1>设置Y轴下标的字体大小</h1> <p>plt.show()

Original: https://www.cnblogs.com/canyangfeixue/p/15386654.html
Author: 残阳飞雪
Title: 用SQL取代pandas 聚合运算结合plot画图的方法案例

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/9216/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

最近整理资源【免费获取】:   👉 程序员最新必读书单  | 👏 互联网各方向面试题下载 | ✌️计算机核心资源汇总