Python：日本人の年代別・性別死亡数を視覚化して考察する

from pandas import *

df = read_csv('dead.csv',encoding='shift_jis')
df.head(2)

df = df.set_index(['年齢(5歳階級)'])
df.drop(['表章項目','死因年次推移分類','性別','/時間軸(年次)'],axis=1,inplace=True)
df = df.apply(to_numeric, errors="coerce").astype(float)
df.reset_index(inplace=True)
df.head(2)

df1 = df[['年齢(5歳階級)','2017年']][:46][24:]
df1.rename(columns={'2017年':'Male'}, inplace=True)
df1

df2 = df[['年齢(5歳階級)','2017年']][:69][47:]
df2.rename(columns={'2017年':'Female'}, inplace=True)
df2

df3 = merge(df1,df2,how='inner',on='年齢(5歳階級)')
df3['Total'] = df3['Male']+df3['Female']
df3['Female_Pct'] = df3['Female'] / df3['Total']
df3['Male_Pct'] = df3['Male'] / df3['Total']

from matplotlib.pyplot import *
from matplotlib.font_manager import FontProperties
from matplotlib import rcParams
import matplotlib.patches as mpatches
style.use('ggplot')

fp = FontProperties(fname='/usr/share/fonts/opentype/ipaexfont-gothic/ipaexg.ttf', size=54)
rcParams['font.family'] = fp.get_name()
rcParams["font.size"] = "22"
fig, ax = subplots(figsize=(20,15))
for (i, row) in df3.iterrows():
    bar([row['年齢(5歳階級)']], [row['Male_Pct']],
        color=['#008AB8'], width=.95, align='center', edgecolor='none')
    bar([row['年齢(5歳階級)']], [row['Female_Pct']], bottom=[row['Male_Pct']],
            color=['#CC6699'], width=.95, align='center', edgecolor='none')
    
xlim(-0.6, 21.6)
ylim(0, 1)
xticks(range(0, 22), df3['年齢(5歳階級)'], fontsize=11)
grid(False)
yticks(np.arange(0, 1.01, 0.05),
       ['{}%'.format(int(x * 100)) for x in np.arange(0, 1.01, 0.05)])
xlabel('Age group')
a = mpatches.Patch(color='#CC6699', label='Female')
b = mpatches.Patch(color='#008AB8', label='Male')
plot([-0.425, 21.425], [0.5, 0.5], lw=2, color='black')
plot([-0.425, 21.425], [0.25, 0.25], lw=2, color='black')
plot([-0.425, 21.425], [0.8, 0.8], lw=2, color='black')
plot([-0.425, 21.425], [0.70, 0.70], lw=2, color='black')
plot([-0.425, 21.425], [0.15, 0.15], lw=2, color='black')
ax.legend(handles=[a,b],bbox_to_anchor=(0,1.02,1,0.2),loc="lower left",mode="None",\
          borderaxespad=0,ncol=2,prop={'size': 26});