Datasets / World food and health
Meat eaten per person, latest year with data
A ranking, not a full map: only the latest year on record for each meat series is used, and countries with no observation that year are left out rather than plotted as zero.
How it decided
World food and health: 7,485 rows, 7 columns. country, year and meat_kg_per_person; income, calories and obesity are not in this cut.
7,485 rows in, 20 out across 2 columns. A ranking, not a full map: only the latest year on record for each meat series is used, and countries with no observation that year are left out rather than plotted as zero.
hbar. Country names are long labels and the question is a ranking, so horizontal bars sorted descending read best.
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.
latest = df.dropna(subset=["meat_kg_per_person"])["year"].max()
result = (
df[df["year"] == latest]
.dropna(subset=["meat_kg_per_person"])
.sort_values("meat_kg_per_person", ascending=False)
.head(20)[["country", "meat_kg_per_person"]]
)
What it charted
20 rows out of 7,485, 2 columns. First 8 shown.
| country | meat_kg_per_person |
|---|---|
| Tonga | 156.9305 |
| Mongolia | 136.1397 |
| Marshall Islands | 125.6185 |
| United States | 122.06 |
| Macao | 121.229 |
| Saint Vincent and the Grenadines | 118.4571 |
| Australia | 116.78 |
| Argentina | 114.95 |