In [1]:
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
In [2]:
DysErec_dept = pd.read_excel(
io="../DATA/OpenHealth_IndiceConsommationARSparDPTDysfonctionErectile_YA.xls",
skiprows=6,
parse_cols=4)
DysErec_reg = pd.read_excel(
io="../DATA/OpenHealth_IndiceConsommationARSparDPTDysfonctionErectile_YA.xls",
skiprows=6,
parse_cols="F:H")
In [3]:
DysErec_reg.head(2)
Out[3]:
In [4]:
DysErec_reg.iloc[:10].plot(
kind='barh',
y="DDD_DysErec2013",
x='NOM_REGION',
color='red',
alpha=0.8,
figsize=(8, 4),
title="TOP 10 des régions")
plt.gca().invert_yaxis()
In [5]:
DysErec_dept.head(2)
Out[5]:
In [6]:
DysErec_dept.iloc[:10].plot(
kind='barh',
y="DDD_DysErec2013",
x='NOM_DEPT',
color='blue',
alpha=0.8,
figsize=(8, 4),
title="TOP 10 des départements")
plt.gca().invert_yaxis()