Python pandas df.iloc[:, 0] 取确定列值作双轴图

#!/usr/bin/python
# -*- coding: <encoding name> -*-
import matplotlib.pyplot as plt
import numpy as np
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 import ticker
from matplotlib.font_manager import FontProperties
from pylab import *
import cx_Oracle

plt.rcParams['font.sans-serif']=['SimHei']#用来正常显示中文标签
plt.rcParams['axes.unicode_minus']=False#用来正常显示负号
conn = cx_Oracle.connect('system/manager@172.16.199.195/ivfhis')
sql2 = "select to_number(to_char(pm.CREATE_DATE,'yyyymm')) AS months,"\
"count(distinct pm.PATIENT_ID) patientcount,"\
"count(distinct pm.ID_NO) as idnumber,"\
"COUNT(distinct su.PATIENT_ID) as sunumber,"\
"round(COUNT(distinct su.PATIENT_ID)/count(distinct pm.PATIENT_ID),2)  as supercent "\
"from PAT_MASTER_INDEX pm "\
"left join INSURANCE_ACCOUNTS su on "\
"pm.PATIENT_ID=su.PATIENT_ID where to_number(to_char(pm.CREATE_DATE,'yyyy'))='2018' "\
"group by to_number(to_char(pm.CREATE_DATE,'yyyymm')) ORDER BY months desc"\
# -- order by years;'
df0 = pd.read_sql(sql2, conn)
df = pd.DataFrame(df0)
# vm=df['months'].astype(str)
# vm=df['months'].astype(str)
# print(vm)
print(df)
# df.rename(index={0: "years", 1: "patientcount", 2: "idnumber", 3: "sunumber", 3: "supercent"})
fig, ax1 = plt.subplots()

plt.xticks(df.iloc[:, 0],fontsize='6',color='blue',rotation=45)
plt.tick_params(axis='x',width=2,labelsize=8)
# 柱形图
# df01=df.iloc[:, 0]
#
# print(df01)
# 按照列索引获取指定列的值,然后画图
ax1.bar(df.iloc[:, 0],df.iloc[:, 1], color="black", alpha=0.5, label="就诊患者人数")
ax1.set_xlabel("患者人数(月)")
ax1.set_ylabel("患者人数")
#  label下边界
ax2 = ax1.twinx()
# 折线图
ax2.plot(df.iloc[:, 0],df.iloc[:, 4], color="green", label="使用社保人数")
ax2.yaxis.set_major_formatter(ticker.PercentFormatter(xmax=1,decimals=0))
ax2.set_ylabel("使用社保人数占比")
ax1.tick_params(pad=5,which='both',length=4,width=0.5,colors='blue',labelsize='medium')
ax2.tick_params(pad=5,which='both',length=4,width=0.5,colors='blue',labelsize='medium')

# 参数x空值X轴的间隔,第二个参数控制每个间隔显示的文本,后面两个参数控制标签的颜色和旋转角度
plt.xticks(rotation=45)
fig.legend(loc="upper right", bbox_to_anchor=(1, 1), bbox_transform=ax1.transAxes)
plt.subplots_adjust(bottom=0.18)

plt.show();

conn.close()

Python pandas df.iloc[:, 0] 取确定列值作双轴图

Original: https://www.cnblogs.com/canyangfeixue/p/15406606.html
Author: 残阳飞雪
Title: Python pandas df.iloc[:, 0] 取确定列值作双轴图

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

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

(0)

大家都在看

发表回复

登录后才能评论
免费咨询
免费咨询
扫码关注
扫码关注
联系站长

站长Johngo!

大数据和算法重度研究者!

持续产出大数据、算法、LeetCode干货,以及业界好资源!

2022012703491714

微信来撩,免费咨询:xiaozhu_tec

分享本页
返回顶部