- This repository includes codes for constructing the value of household food consumption from different sources by crop and documentation for construction decisions across instruments.
- Countries captured include Benin, Burkina Faso, Cote d'Ivoire, Ethiopia, Ghana, Guinea Bissau, Kenya, Malawi, Mali, Niger, Nigeria, Senegal, Sierra Leone, Tanzania, Togo, and Uganda.
- This section sets global variables for use later in the script, including
- Exchange Rates and Inflation Conversions
- Population: We reference true rural and urban population estimates from the World Bank to re-weight households.
- Thresholds for Winsorization: the smallest (below the 1 percentile) and largest (above the 99 percentile) are replaced with the observations closest to them
- Description: This dataset includes hhid/grappe menage/hhcode as a unique identifier, along with its location identifiers (e.g. rural, region, zone, department, province, ea, etc.). Other variables created here include:
- Female-headed household indicator
- Household survey weight
- Age of household head
- Number of household members
- Number of working-age adults
- Number of working-age female adults
- Number of working-age male adults
- Number of elders
- Number of children
- Adult-equivalent
- Rural location indicator
- survey interview day, month, and year.
- Description: This dataset includes hhid/grappe menage/hhcode as a unique identifier and constructs food consumption at the crop level by the different sources (from purchases, own production, and gifts).
- Data Construction Notes:
- Food items are aggregated into major crop categories.
- The value of food consumption from purchases was constructed using reported food prices in the surveys.
- The value of food consumption from own production and gifts are computed using the mean purchase price of the food items at various administrative levels. For instance, when the purchase price of a food item is reported by more than 10 observations in an enumeration area, the value of food consumed by the food item from production and gifts is derived by multiplying the food quantity with the median purchase price in that enumeration area. Depending on observations, the mean purchase price for each unit of food item was constructed at the different levels of disaggregation (enumeration area, local government area, woreda, district, state, and country).
- The average food consumption value was calculated for surveys that collected data in two visits (post-planting and post-harvest visits).
- Most surveys capture food consumption over the past 7 days before the visits. The annualized value of food consumption was derived by multiplying by 52 (the number of 7 days in a year). For those with a 30-day recall, annual food consumption was calculated by multiplying by 12 (the number of months in a year).
- Household food consumption from purchases is inclusive of food consumed away from home.
- To remove outliers, the value of food consumption was winsorized at the top 1% threshold.
- The average value of food consumption can be calculated using survey weights to be representative of the country and location levels.
- Food consumption values in Local Currency Units are converted to 2017 Purchasing Power Parity (PPP).
- The raw data was downloaded from various secondary sources, including:
| Country | Survey | Years |
|---|---|---|
| Bénin | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Burkina Faso | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19, 2021/21 |
| Cote d'Ivoire | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Ethiopia | Socioeconomic Panel Survey (ESS) | 2015/16, 2018/19, 2012/22 |
| Ghana | Socioeconomic Panel Survey (SPS) | 2009/10 |
| Guinea Bissau | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Kenya | Integrated Household Budget Survey (KIHBS) | 2015/16 |
| Malawi | Integrated Household Survey (IHS) | 2010/11, 2013, 2016/17, 2019/2020 |
| Mali | Enquête Agricole de Conjoncture Intégrée (EACI) | 2014 |
| Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 | |
| Niger | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Nigeria | General Household Survey (GHS) | 2010/22, 2012/13, 2015/16 and 2018/19 |
| Senegal | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Sierra Leone | Integrated Household Survey (IHS) | 2018 |
| Tanzania | National Panel Survey (NPS) | 2008/09, 2010/11, 2012/13, 2014/15, 2019/20 |
| Togo | Enquête Harmonisée sur les Conditions de Vie des Ménages (EHCVM) | 2018/19 |
| Uganda | National Panel Survey (UNPS) | 2009/10, 2010/11, 2011/12, 2013/14, 2015/16, 2018/19, 2019/20 |
- Download the raw data from the different sources.
- For each country, extract the raw data files to a folder and update the global directory named "Country_Survey_raw_data" with the appropriate folder path.
- Next create a folder where to store intermediary data files created and update the global directory named "Country_Survey_created_data".
- Also, create a folder to store all final data files created and update the global directory named "final_data".