python——使用seaborn画直方图

# -*- coding: utf-8 -*-
import pandas as pd
import sys
reload(sys)
sys.setdefaultencoding('utf8')
from pylab import *
mpl.rcParams['font.sans-serif'] = ['Microsoft YaHei']#指定默认字体
mpl.rcParams['axes.unicode_minus'] =False # 解决保存图像是负号'-'显示为方块的问题
from sqlalchemy import create_engine
import seaborn as sns

engine = create_engine('postgresql+psycopg2://username:password@ip:port/databasename')
conn = engine.connect()

df = pd.read_sql(
    'select column,count(1) as number from table group by column',
    engine).sort()

sns.barplot(x=df['column'], y=df["number"], data=df)

效果图如下：