Python：在留外国人の詳細を円グラフで表示する

import tabula

df = tabula.read_pdf("http://www.moj.go.jp/content/001289225.pdf",
             output_format='dataframe',
             pages = '1',
             encoding='utf-8',
             java_options=None,
             pandas_options=None,
             multiple_tables=False)

df[4:6].head(2)

df1 = df[['Unnamed: 1','平成30年末']][6:18].drop(7)
df1 = df1.set_index(['Unnamed: 1'])
df1

df1.index=['中国','韓国','ベトナム','フィリピン','ブラジル','ネパール','台湾','米国',\
          'インドネシア','タイ','その他'] 
df1

for i, col in enumerate(df1.columns):
    df1.iloc[:, i] = df1.iloc[:, i].str.replace(',', '')

df1 = df1.apply(pd.to_numeric, errors="coerce").astype(int)

%matplotlib inline
from matplotlib.pyplot import *
from matplotlib.font_manager import FontProperties
from matplotlib import rcParams

style.use('classic')
fp = FontProperties(fname='/usr/share/fonts/opentype/ipaexfont-gothic/ipaexg.ttf', size=54)
rcParams['font.family'] = fp.get_name()
c      = [(x/22.0, x/77.0, .9) for x in range(len(df1))] 

fig, ax = subplots(figsize=(18,10))
_,texts,autotexts = ax.pie(df1['平成30年末'],labels=df1.index,colors=c,shadow=True,\
 explode=(0,0.1,0,0,0,0.1,0,0.1,0.,0.1,0.),autopct='%1.2f%%',wedgeprops = {'linewidth': 3},\
  textprops={'fontsize': 25},startangle=65,pctdistance=.85,labeldistance=1.1,radius=1.2);
#texts.set_fontsize(50)
setp(autotexts, size=20, weight="bold");
setp(texts, size=25, weight="bold");
for autotext in autotexts:
    autotext.set_color('white')

import tabula

df2 = tabula.read_pdf("http://www.moj.go.jp/content/001289225.pdf",
             output_format='dataframe',
             pages = '4',
             encoding='utf-8',
             java_options=None,
             pandas_options=None,
             multiple_tables=False)

df3 = df2[1:2]
df3

df3.drop(['中長期在留者','Unnamed: 7'], axis=1,inplace=True)

df3.rename(columns={'日本人の国籍・地域 計':'総数','技術・ 人文知識・':'技術・人文知識・国際業務','Unnamed: 10':'日本人の配偶者等'},inplace=True)
df3

for i, col in enumerate(df3.columns):
    df3.iloc[:, i] = df3.iloc[:, i].str.replace('総 数','').str.replace(',','')
df3 = df3.apply(pd.to_numeric, errors="coerce").astype(int)
df3.index=['外国人数']
df3

df3.drop(['総数'], axis=1,inplace=True)
df3

k=df3.T.sort_values('外国人数',ascending=False)
m=[]
for i in k['外国人数']:
    m.append(i)
n=[]
for i in k.T.columns:
    n.append(i)

c = cm.inferno_r(np.linspace(.2,.5, 10))

fig, ax = subplots(figsize=(18,10))
_,texts,autotexts = ax.pie(m,labels=n,colors=c,shadow=True,\
 explode=(0,0.1,0,0,.15,0.1,0,0.1,0.,0.1,),autopct='%1.2f%%',wedgeprops = {'linewidth': 3},\
  textprops={'fontsize': 25},startangle=0,pctdistance=.75,labeldistance=1.1,radius=1.2);
#texts.set_fontsize(50)
setp(autotexts, size=25, weight="black",color='black')
setp(texts, size=25, weight="heavy",color='black');

fig, ax = subplots(figsize=(18,10))
def func(pct, allvals):
    absolute = int(pct/100.*np.sum(allvals))
    return "{:.1f}%\n({:,}人)".format(pct, absolute)
c = cm.spring_r(np.linspace(0.1, 0.5, 10))
wedges,texts,autotexts = ax.pie(m,labels=n,shadow=True,colors=c,\
 explode=(0,0.1,0,0,.15,0.1,0,0.1,0.,0.1,),autopct=lambda pct: func(pct, m),wedgeprops = {'linewidth': 3},\
  textprops={'fontsize': 25},startangle=0,pctdistance=.80,labeldistance=1.1,radius=1.2);
setp(autotexts, size=16, weight="black",color='k')
setp(texts, size=25, weight="heavy",color='black');

e = []
for i in m:
    e.append(str(i))

c=[]
for i in range(len(e)):
    d=e[i][:len(e[i])-4]+'万'+e[i][-4:]
    c.append(d)

f=["{}({}人)".format(n_, c_) for c_, n_ in zip(c, n)]

fig, ax = subplots(figsize=(18,10))

wedges,texts,autotexts = ax.pie(m,shadow=True,labeldistance=1,radius=1.2,\
 explode=(0.1,0.,0.1,0.,.15,0.,0.1,0.,0.1,0.,),wedgeprops = {'linewidth': 3},\
  autopct='%1.2f%%',textprops={'fontsize': 25},startangle=160,\
   pctdistance=.75,counterclock=False)

plt.setp(autotexts, size=35, weight="bold",color='w')

bbox_props = dict(boxstyle="square,pad=0.3", fc="w", ec="k", lw=0.72)
kw = dict(arrowprops=dict(arrowstyle="-"),
          bbox=bbox_props, zorder=0, va="center")

for i, p in enumerate(wedges):
    ang = (p.theta2 - p.theta1)/2 + p.theta1
    y = np.sin(np.deg2rad(ang))
    x = np.cos(np.deg2rad(ang))
    horizontalalignment = {-1: "right", 1: "left"}[int(np.sign(x))]
    connectionstyle = "angle,angleA=0,angleB={}".format(ang)
    kw["arrowprops"].update({"connectionstyle": connectionstyle})
    ax.annotate(f[i], xy=(x, y), xytext=(1.5*np.sign(x), 1.45*y),size=30,
                horizontalalignment=horizontalalignment, **kw)