Matching IPC and DIEM Data - summarizing indicators by IPC phase

Summary of this file

I get IPC and FAO DIEM data and merge it by admin level 2 and year. Then I provide some desciptives of the food security indicators for the entire sample (of merged data) and summarize those indicators by IPC phase - to see how IPC matches to these food security indicators.

Data work

Here is a summary of the data work:

• Get IPC phase per country per area (admin level 2)
• Take the DIEM food security module data, which contains several food security indicators like food consumption scores, reduced coping index, etc. The income module looked less relevant, but at the link in the next bullet point you can take a look at other modules and variables available. To me, nothing from DIEM looks suitable for estimating calorie gaps.
• Selected what indicators to include (see the list in the section below). To see all variables for all modules, see this file: https://www.dropbox.com/scl/fi/rsagth53r1q0pxdrpktxh/DIEM_2023_-_Fields_descriptions.xlsx?rlkey=vn9t7po3fwla9c1ahvz0hwfgj&dl=0
• I merged DIEM data and IPC phase data by admin level 2 columns in both datasets and by time period of the indicator/IPC analysis. For the sake of speed, I didn’t touch any values in the admin level 2 columns of either dataset; I just merged what was already clearly a pair. For merging by time period, I created a window of time based on the start date of the survey/IPC analysis and then filtered as follows: start_dateForMatching_IPC <= end_dateForMatching_DIEM & end_dateForMatching_IPC >= start_dateForMatching_DIEM.

---

Selected indicators

Below are the key indicators, categorized by type. In the data shown below, I include even a more filtered list:

Food Insecurity Experience Scale (FIES)
- fies_rawscore_median, fies_rawscore_wmean: Median and weighted mean FIES raw scores.
- p_mod_median, p_mod_wmean: Prevalence of recent moderate or severe household food insecurity (FIES). Values range from 0 to 1.
- fies_rawscore_0 to fies_rawscore_8: Breakdown of FIES raw scores.

Livelihood Coping Strategy Index (LCSI)
- lcsi_0 to lcsi_3: Different levels of livelihood coping strategies.

Household Diet Diversity Score (HDDS)
- hdds_class_1 to hdds_class_3: Classification of household diet diversity.

Household Hunger Scale (HHS)
- hhs_0 to hhs_6: Measures of household hunger severity.

Food Consumption Score (FCS)
- fcs_median, fcs_wmean: Median and weighted mean Food Consumption Scores.

Food Consumption Groups (FCG)
- fcg_1 to fcg_3: Classification of households based on food consumption. Additional scores per food group are available if needed.

Reduced Coping Strategies Index (rCSI)
- rcsi_score_median, rcsi_score_wmean: Median and weighted mean reduced coping strategies index scores.

---

---

Viewing the data

---

Summarizing FCS

FCS distribution across all matched data

FCS median score at admin 2 level summarized by IPC phase

Food Consumption Scores summarized by IPC phase
area_overall_phase	variable	mean	median	sd	min	max	count
1	fcs_median	47.4	50.0	10.0	27	66.5	70
2	fcs_median	45.1	48.5	13.1	20	71.0	170
3	fcs_median	38.6	36.0	13.2	12	79.0	379
4	fcs_median	34.4	28.0	21.3	12	79.0	9

---

Summarizing reduced coping strategies index

rcsi distribution across all matched data

RCSI median score at admin 2 level summarized by IPC phase

RCSI scores summarized by IPC phase
area_overall_phase	variable	mean	median	sd	min	max	count
1	rcsi_score_median	5.8	4	5.6	0	21.5	70
2	rcsi_score_median	9.7	9	6.9	0	35.0	169
3	rcsi_score_median	12.4	11	7.4	0	46.0	377
4	rcsi_score_median	13.4	16	7.7	0	22.0	9