1955年〜2018年の洋画と邦画の公開数と興収シェアをグラフ化

import pandas as pd
import requests

df = pd.read_html(requests.get('http://www.eiren.org/statistics_e/').content)

df1 = df[0]
df2 = df[1]

df3 = df1[[0,1,2,3,4,5,6,7,11,12]]
df4 = df2[[0,1,2,3,4,5,9,6,10,11]]

df3.columns = ['年','スクリーン数','邦画','洋画','総数','入場者数','興行収入',\
             '平均料金','邦画シェア','洋画シェア']
df4.columns = ['年','スクリーン数','邦画','洋画','総数','入場者数','興行収入',\
             '平均料金','邦画シェア','洋画シェア']

df3 = df3.drop(df3.index[[0,1,2]])
df4 = df4.drop(df4.index[[0,1,2]])

for i, col in enumerate(df4.columns):
    df4.iloc[:, i] = df4.iloc[:, i].str.replace(r"\(.*\)","").str.replace(',','')
df4.head()

df5 = pd.concat([df3,df4], axis=0)
df5[df5.columns[0:8]] = df5[df5.columns[0:8]].apply(pd.to_numeric, errors="coerce").astype(int)
df5[df5.columns[8:10]] = df5[df5.columns[8:10]].apply(pd.to_numeric, errors="coerce").astype(float)

df5 = df5.reset_index(drop=True)

df5.to_csv('movie_data.csv', index=False)

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"] = "25"
fig, ax = subplots(figsize=(20,15))

for i, row in df5.iterrows():
    bar([i], [row['邦画シェア']],
        color=['#008AB8'], width=0.8, align='center', edgecolor='none')
    bar([i], [row['洋画シェア']], bottom=[row['邦画シェア']],
            color=['#CC6699'], width=0.8, align='center', edgecolor='none')

xlim(-0.6, len(df5)-.6)
ylim(0, 100)
xticks(range(64), df5['年'], fontsize=20,rotation=90)
grid(False)
yticks(np.arange(0, 101, 25),
       ['{}%'.format(int(x)) for x in np.arange(0, 101, 25)])
xlabel('年')
ylabel('洋画と邦画のシェア')
plot([-0.425, 65.425], [50, 50], lw=2, color='black')
plot([-0.425, 65.425], [25, 25], lw=2, color='black')
plot([-0.425, 65.425], [75, 75], lw=2, color='black')
a = mpatches.Patch(color='#CC6699', label='洋画シェア')
b = mpatches.Patch(color='#008AB8', label='邦画シェア')
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});

df6 = df5[['年','邦画','洋画']]

fig, ax = subplots(figsize=(20,12))
rcParams["font.size"] = "20"
df6[['邦画','洋画']].plot(ax=ax,marker='o')
rc('ytick', labelsize=22)
grid=True
xlabel('年')
ylabel('洋画と邦画の公開本数')
xlim(-0.6, len(df6)-.6)
xticks(range(0,len(df6.index)),df6['年'],fontsize=20,rotation=90)
ax.legend(loc='best', prop={'size': 26});