data = []
with open('aice.tsv') as _f:
for row in _f:
rows = row.replace('\n','').split('\t')
data.append(rows)
data2 = []
for rows in data[2:]:
name = rows[1]
for i,t in enumerate(rows[4:]):
tmp = [name , '{0:02}月分'.format(i+1) , int(t)]
data2.append(tmp)
import pandas as pd df = pd.DataFrame(data2 , columns=['市町村','月','価格']) df.shape(972, 3)
df2 = df.groupby('市町村').mean('価格').sort_values('価格')
df2
df3 = df.sort_values('価格').head()
df3
import seaborn as sns
from matplotlib import pyplot as plt
df4 = df[df['市町村'].isin(df2.index[0:10])]
plt.figure(figsize=(10,5))
sns.boxplot(x='市町村',y='価格', data=df4,order=df2.head(10).index)
plt.title('')
plt.show()
