Chapter 10 Calculating Matrice Intermediare (direct food security data)

After survey teams have processed the data (cleaned, calculated indicators and added survey weights), then the R syntax below can be used to generate a .csv file of the Food Security Direct evidence that can be pasted into the matrice intermediare

10.1 Overview video

10.2 Generating Matrice Intermediare

10.2.1 Example processed data set

Here is the example processed data set: exampledataEnglish_processed

10.2.2 Syntax

Here is the syntax to generate the matrice intermediare from processed dataset: matricemaker_EN

10.2.3 Example of matrice intermediare

Here is a zipped file of the example matrice intermediare (.csv) generated from processes above: matrice_intermediaire_direct_en

10.3 Troubleshooting & Known issues

  • If the country did not collect all the 5 Food Security Indicators (FCS, HDDS, rCSI, HHS, LhCS) - the modules not collected should be removed from the code
  • If the level of analysis is at the Admin 1 level only - then the variables ADMIN2Name and ADMIN2Code should be removed from the code
  • If the ADMIN1Name and ADMIN2Name were not collected with geocodes (see Chapter 2) then the code will have to be modified
  • If survey weights are used, the variable should be renamed to Weight_HH, if survey weights are not used then the code wt = WeightHH should be removed from the syntax
  • For calculations of the Food Consumption Groups - modify the code to use FCSCat21 for 21/35 thresholds or FCSCat28 for 28/42 thresholds as appropriate.