skills.rest
xjtulyc
xjtulycCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

food-systems-data

Download FAOSTAT production, trade, and food balance sheet data into pandas DataFrames.

33|6|Updated Mar 17, 2026
Search Tags:#data visualization#food security#food systems#FAOSTAT#dietary energy adequacy#trade flows
One-click install
npx skills add https://github.com/xjtulyc/awesome-rosetta-skills --skill food-systems-data
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: food-systems-data
Source: https://github.com/xjtulyc/awesome-rosetta-skills/tree/main/skills/19-agriculture/food-systems-data
Command: npx skills add https://github.com/xjtulyc/awesome-rosetta-skills --skill food-systems-data

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, requests, numpy, matplotlib, plotly.

What problem does it solve?

This Skill helps you download and analyze national food systems indicators from FAOSTAT so you can quantify food security, dietary adequacy, and trade patterns instead of manually stitching datasets together.

Core Features & Use Cases

  • FAOSTAT data retrieval (production, trade, food balance sheets): Pulls FAOSTAT REST API data for crop/livestock production (QCL), trade (TCL), and food balance sheets/food security indicators (FBS/FS).
  • Food security and diet metrics: Computes Dietary Energy Adequacy (DEA) and food import dependency ratios and supports analysis of diet composition signals (e.g., cereals share proxy).
  • Trade flow visualization: Builds bilateral trade corridors and visualizes top export routes (including Sankey-style workflow via plotting options).
  • Use Case: An analyst needs to compare how import dependence and caloric adequacy change for multiple countries from 2000–2020 and then identify the main wheat export corridors for 2020.

Quick Start

Use the food-systems-data skill to download FAOSTAT food balance sheets for Ethiopia and compute Dietary Energy Adequacy (DEA) over 2000–2020.

Frequently Asked Questions about food-systems-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I download and analyze FAOSTAT food balance sheet data for multiple countries?▼

Dietary Energy Adequacy (DEA) is a food security metric calculated by transforming standardized pandas DataFrames containing food balance sheet data. It requires downloading food security indicators from the FAOSTAT REST API and applying numeric transformations to quantify caloric adequacy trends.

What's the best way to visualize bilateral trade corridors using FAOSTAT data?▼

The best way to visualize bilateral trade corridors is by summarizing FAOSTAT trade flow data into DataFrames and generating plots like Sankey-style corridor charts. This approach uses plotly and matplotlib to map top export routes for specified items and years.

Can I use pandas and plotly to estimate food import dependency ratios from FAOSTAT data?▼

Yes, you can use pandas and plotly to estimate food import dependency ratios. The Skill downloads FAOSTAT trade and food balance sheet data, standardizes the fields into DataFrames, and applies numeric transformations to calculate import dependency math and visualize the results.

Does this approach support analyzing dietary energy adequacy trends over time for specific countries?▼

Yes, this approach supports dietary energy adequacy trend analysis over time for specified countries. It downloads food security indicators from the FAOSTAT REST API across parameterized years and applies numeric transformations to quantify and plot the changing caloric adequacy.

What are the limitations of using FAOSTAT REST API data for food systems analysis?▼

A limitation of using FAOSTAT REST API data for food systems analysis is that diet composition signals, such as the cereals share proxy, are estimated rather than directly provided. Additionally, bilateral trade corridor summarization relies on standardizing available response fields without external trade context.

Related Skills

Explore More Data & Analytics Skills→
jkitchinjkitchin
34

python-plotting

Select and apply Matplotlib, Seaborn, or Plotly for Python visualizations.

Community
Intermediate
yangqiongyangqiong

Report Generator Skill

Generate HTML data reports from pandas DataFrames with summaries and analyses.

Community
Intermediate
antvisantvis
4.0k

antv-l7

Compose interactive geospatial visualizations with AntV L7.

Official
Advanced
berba-qberba-q
6

faostat-country-profile

Generate country-level agricultural and food security profiles from FAOSTAT data.

Community
Intermediate