An access library for the world crop, food production and consumption datasets

This is an idea proposed in 2025 as a good starter project, and is available for being worked on. It may be co-supervised with Alison Eyres and Thomas Ball.

Agricultural habitat degradation is a leading threat to global biodiversity. To make informed decisions, it's crucial to understand the biodiversity impacts of various foods, their origins, and potential mitigation strategies. Insights can drive actions from national policies to individual dietary choices. Key factors include knowing where crops are grown, their yields, and food sourcing by country.

The FAOSTAT trade data offers comprehensive import and export records since 1986, but its raw form is complex, including double counting, hindering the link between production and consumption.

While Kastner et al. proposed a method to address this, it has only been applied to 2013 data so far. Creating a reproducible pipeline for processing FAO trade data across years is essential for assessing how global trade changes affect biodiversity. For instance, how has Brexit impacted the UK's food sourcing and biodiversity? What are the repercussions of emerging producers on ecosystems?

The summer project

There exists a Python faostat library to act as an interface to the raw CSV. And in 2024, a bunch of food hackers released AgriFoodPy which is a package for modelling food systems.

In this project, we'd like to:

port a bunch of R code to Python using faostat/agrifoodpy and verify the outputs are broadly the same
determine strategies to incrementaly update and reproduce FAO data on top of these libraries so we can do more frequent updates and tailoring
apply it to the code backing the "Food impacts on species extinction risks can vary by three orders of magnitude" paper

This would be a good summer project for a student interested in getting to grips with scientific computing, such as Python, Rscript, and dataframes libraries. If the core is done early, then we can investigate visualisations as well. And of course, if you're interested in sustainability, is this is a great topic to start on!