Dietary Energy Consumption¶

import pandas as pd

from geonamescache.mappers import country
country_name_to_iso3 = country(from_key='name', to_key='iso3')

info = 'Average dietary energy consumption per person per day in kilocalories.\n'
footer = 'CC BY-SA 2014 Ramiro Gómez - ramiro.org • Data: FAO Statistics Division - fao.org'
mpl.rcParams['font.size'] = 11
mpl.rcParams['font.family'] = 'Ubuntu'
mpl.rcParams['axes.color_cycle'] = 'a6cee3, 1f78b4, b2df8a, 33a02c, fb9a99, e31a1c, fdbf6f, ff7f00, cab2d6'

df = pd.read_excel('data/FoodConsumptionNutrients_en.xls', 'Dietary Energy Cons. Countries', skiprows=2).dropna()
del df['Country Code']
df.head()

df['iso3'] = df['Country name'].apply(country_name_to_iso3)
df.set_index('Country name', inplace=True)

df.sort('2006-08', inplace=True)
s = df['2006-08'].head(10)

s.plot(kind='barh', figsize=(10, 6), title='Least Calories Consumed per Capita per Day\n', fontsize='large')

ax = plt.axes()
ax.spines['top'].set_visible(False)
ax.spines['right'].set_visible(False)
ax.spines['bottom'].set_visible(False)
ax.spines['left'].set_color((1, 1, 1))
ax.xaxis.set_label_text(info + footer)
ax.xaxis.set_ticklabels('')
ax.yaxis.set_label_text('')

for i, x in enumerate(s):
    ax.text(x + 100, i - .1, int(x), ha='left', fontsize='large')

plt.savefig('../static/img/graphs/least-calories-countries.png', bbox_inches='tight')

s = df['2006-08'].tail(10)
s.plot(kind='barh', figsize=(10, 6), title='Most Calories Consumed per Capita per Day\n', fontsize='large')

ax = plt.axes()
ax.spines['top'].set_visible(False)
ax.spines['right'].set_visible(False)
ax.spines['bottom'].set_visible(False)
ax.spines['left'].set_color((1, 1, 1))
ax.xaxis.set_label_text(info + footer)
ax.xaxis.set_ticklabels('')
ax.yaxis.set_label_text('')

for i, x in enumerate(s):
    ax.text(x + 100, i - .1, int(x), ha='left', fontsize='large')

    plt.savefig('../static/img/graphs/most-calories-countries.png', bbox_inches='tight')

df.to_csv('../static/data/csv/calories-countries.csv', encoding='utf-8', index=False)