Data Transformation

Overview

The data transformation for WASH Futures Explorer is performed within a Jupyter Notebook, located in the src folder as main.ipynb. This notebook prepares the raw data for visualisation by performing multiple transformation steps on the IFs and JMP datasets, which are essential for calculating progress rates and organizing WASH indicators.

Required libraries are listed in the requirements.txt file in the src folder.

Transformation Steps

• 1. Preparation
  • 1.A. Import Required Libraries
  • 1.B. Data Input and Output
  • 1.C. Common Functions
  • 1.D. Key Table Generator
  • 1.E. Country Mapping
• 2. IFs Dataset
  • 2.A. IFS Functions
  • 2.B. IFS Data Processing
  • 2.C. IFs Table of Keys
  • 2.D. IFS Table Results
  • 2.E. Progress Rates
• 3. JMP Dataset
  • 3.A. JMP Data Processing
  • 3.B. JMP Table Keys
  • 3.C. JMP Table Results
• 4. Post Data Transform
  • 4.A. Post Data Functions
  • 4.B. Replace Key Tables with Predefined Strings

—