DRC · PYTHON & R PROJECT COLLECTION

From field records to
review-ready information.

Practical workflows I developed during my work with the Danish Refugee Council: checking assessment records, reviewing candidate duplicates and turning structured exports into usable beneficiary registers.

CONTEXTHumanitarian information management
METHODSPython · R · structured exports
PUBLIC COLLECTION7 notebooks · 4 R workflows

The operational challenge

Assistance programmes need more than a completed assessment form. Household and member records must be consistent, possible duplicate registrations need review, and programme teams need clear documents for verification and distribution. Repeating these steps manually creates avoidable work and makes the process harder to reproduce.

My contribution

I developed Python and R scripts to support these tasks alongside ActivityInfo-based information management. The work brought together data preparation, automated checks, scoring analysis and document generation. It supported the wider DRC workflows described in my professional experience, including beneficiary-list preparation for BHA-funded assistance and information management support to the ECHO consortium.

  1. Make checks repeatable. Apply documented household and member consistency checks, then produce a review report that helps teams investigate the records behind each flag.
  2. Support careful verification. Compare selected identity and household attributes to identify candidate matches, keeping the final judgement with authorised reviewers.
  3. Turn exports into field documents. Sort and group structured records into distribution and validation registers, with consistent headers, card-number fields and printable layouts.
  4. Prepare files for handover. Organise representative exports and picture-processing steps so that preparation can be repeated and inspected.

What you can explore here

The public collection contains adapted examples and documentation. Python demonstrations use explicitly fictional records. The R reference workflows retain the analytical approach while replacing private system connections with local input files. No programme datasets, beneficiary photographs, operational links or credentials are included.

The original scoring criteria are programme-specific, and candidate duplicates require human review. These examples demonstrate my approach to the work; they are not automatic assistance-eligibility tools.

FOUR CONNECTED CAPABILITIES

Explore the work behind the code.

01 / DATA QUALITY

Assessment cleaning & candidate deduplication

R-based household and member checks, exact-key and fuzzy candidate matching, and local review reports. Flags are prompts for investigation, not automatic exclusions.

R · household/member joins · review reports

Explore the R workflows ↗

02 / PROGRAMME ANALYSIS

Vulnerability scoring & disaggregation

An offline reference for reviewing scoring components and disaggregating assessment results, including food-consumption and coping-strategy measures.

R · scoring logic · grouped summaries · charts

Read the scoring reference ↗

03 / OPERATIONAL AUTOMATION

Distribution & verification registers

Python demonstrations that transform structured exports into organised PDF and editable document registers, using one shared renderer for consistent columns and pagination.

Python · structured exports · PDF · DOCX

Open the register notebook ↗

04 / FILE PREPARATION

Representative exports & picture processing

Local household-representative review exports, non-destructive image compression and attachment preparation. The public examples use geometric placeholders.

R + Python · local files · metadata removal

Open the picture-processing notebook ↗

LET’S WORK TOGETHER

Build a workflow your
team can use and maintain.

Discuss a project or training ↗