2002年〜2019年の国内興行収入1位作品の推移をグラフ化する

import pandas as pd
import requests

d=[]
for i,j in enumerate(range(2002,2004)):
    a = 'https://www.boxofficemojo.com/intl/japan/yearly/?yr={}&p=.htm'.format(j)
    df = pd.read_html(requests.get(a).content)
    df1 = df[2]
    df1.columns = ['順位','タイトル','興行収入','公開日']
    b = df1[['タイトル','興行収入']].iloc[1]
    d.append(b)

e=[]
for j in range(2004,2020):
    a = 'https://www.boxofficemojo.com/intl/japan/yearly/?yr={}&p=.htm'.format(j)
    df = pd.read_html(requests.get(a).content)
    df1 = df[2]
    df1.columns = ['順位','タイトル','配給会社','興行収入','公開日']
    b = df1[['タイトル','興行収入']].iloc[1]
    e.append(b)

df2 = pd.DataFrame(d)
df3 = pd.DataFrame(e)
df4 = pd.concat([df2,df3])

df4.to_csv('yearly_top_gross.csv', index=False)

import pandas as pd
import requests

df11 = pd.read_csv('yearly_top_gross.csv',encoding='utf-8')

df11['タイトル'][1] = 'Odoru daisosasen the movie 2'

df11['興行収入'] = df11['興行収入'].str.replace('$','').str.replace(',','')

df11['興行収入'] = df11['興行収入'].apply(pd.to_numeric, errors="coerce").astype(int)

years = list(range(2002,2020))
years = ",".join(map(str, years))
years = years.split(',')

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

rcParams["font.size"] = "25"
rc('xtick', labelsize=25)
rc('ytick', labelsize=35)
fp = FontProperties(fname='/usr/share/fonts/opentype/ipaexfont-gothic/ipaexg.ttf', size=54)
rcParams['font.family'] = fp.get_name()
fig, ax = subplots(figsize=(20,16))
df11.set_index('タイトル').plot(kind='barh',ax=ax,width=.9,color='pink');
xticks(np.arange(0,2.8e8,1e8/5),
   ['{}億'.format(float(x/1e9)) if x > 0 else 0 for x in np.arange(0,2.8e9,1e9/5)]);
for j,i in enumerate(ax.patches):
    ax.text((i.get_width()+1e6 if int(i.get_width()) < 1.5e8 else i.get_width()-1.05e8),\
     i.get_y()+.15,'{:,}億{:,}万{:,}ドル ({}年)'.format(int(str(i.get_width())[:-8]),\
       int(str(i.get_width())[-8:-4]),int(str(i.get_width())[-4:]),years[j]) \
 if int(i.get_width()) > 1e8 else '{:,}万{:,}ドル ({}年)'.format(int(str\
  (i.get_width())[:-4]),int(str(i.get_width())[-4:]),years[j]),fontsize=30, color='k');