twoHelixestwoHelixes Start free

Datasets / World food and health

Change in obesity since 1990, by country

The change is latest minus 1990 for each country separately, so a country that only appears late in the series cannot invent a change. Countries missing either endpoint stay out of the ranking.

Question how has obesity changed since 1990 by country?
Obesity change since 1990 (percentage points)0102030BruneiSaint Kitts and N…ChileTongaBelizeJamaicaArgentinaGeorgiaBarbadosQatarChange Pp
World food and health — 20 rows charted from 7,485, drawn as a hbar
How it decided
Finding the data13 ms

World food and health: 7,485 rows, 7 columns. country, year and obesity_pct at the 1990 and latest endpoints.

Shaping the data34 ms

7,485 rows in, 20 out across 2 columns. The change is latest minus 1990 for each country separately, so a country that only appears late in the series cannot invent a change. Countries missing either endpoint stay out of the ranking.

Choosing the chart6 ms

hbar. One signed change per country is a ranking, and horizontal bars keep the country labels legible at this length.

Applying defaults1 ms

Palette, spacing, axis titles and legend placement applied. 0 issues found.

The transformation

This is the code, not a description of it — the chart above was drawn from what it returns, and the notebook download runs the same lines against the same file.

base = df[df["year"] == 1990].dropna(subset=["obesity_pct"])[["country", "obesity_pct"]].rename(columns={"obesity_pct": "obesity_1990"})
latest_year = df.dropna(subset=["obesity_pct"])["year"].max()
now = df[df["year"] == latest_year].dropna(subset=["obesity_pct"])[["country", "obesity_pct"]].rename(columns={"obesity_pct": "obesity_latest"})
joined = base.merge(now, on="country", how="inner")
joined["change_pp"] = joined["obesity_latest"] - joined["obesity_1990"]
result = joined.sort_values("change_pp", ascending=False).head(20)[["country", "change_pp"]]

What it charted

20 rows out of 7,485, 2 columns. First 8 shown.

countrychange_pp
Brunei30.3339
Bahamas30.2478
Saint Kitts and Nevis29.7396
Samoa29.4986
Chile28.6435
Romania28.3511
Tonga27.7462
Panama27.7091