# -*- 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)
效果图如下: