Livelihoods and Energy Control Panel
  • Guidance for the structure of Control Panel
    • Livelihoods Control Panel
      • Library ‘LM’
        • 1.1 Common Components
        • 1.2 Livelihoods Specific Component
        • Common Script
      • Livelihoods CONTROL PANEL (Parent)
        • 2.1 GAS SCRIPT
        • 2.2 HTML/JAVA SCRIPT
    • Energy Control Panel
      • Library ‘EM’
        • 1.1 Common Components [Energy]
        • 1.2 Energy Specific Component
      • Energy CONTROL PANEL (Parent)
        • 2.1 GAS SCRIPT [Energy]
        • 2.2 HTML/JAVA SCRIPT
  • Description of the main processes
    • Start and Refresh Control Panel
      • Modules of Start and Refresh Control Panel
      • Diagram on Start and Refresh Control Panel
      • GAS Functions for Start and Refresh Control Panel
    • Task scheduling and execution
      • Modules of Task scheduling and execution
      • Task status
      • Diagram on Task scheduling and execution
      • GAS Functions for Task scheduling and execution
    • Activation of automatic mode
      • Diagram on Activation of automatic mode
      • GAS Functions for Activation of automatic mode
    • Email notification
      • Modules of Email notification
      • Diagram on generationg Email notification
      • GAS Functions for Email notification
    • Extracting the PDF template
      • Modules of Extracting the PDF template
      • Diagram on Extracting the PDF template
      • GAS Functions for Extracting the PDF template
    • Extracting summary template table
      • Modules of Extracting summary template table
      • Diagram on Extracting summary template table
      • GAS Functions for Extracting summary template table
    • Deploying new surveys
      • Modules of Deploying new surveys
      • Diagram on Deploying new surveys
      • GAS Functions for Deploying new surveys
    • Updating the survey forms after deployment
      • Manual Module of Updating the survey forms after deployment
      • Diagram on Updating the survey forms after deployment
      • GAS Functions for Updating the survey forms after deployment
    • Updating the location file after deployment
      • Manual module of Updating the location file after deployment
      • Diagram on Updating the location file after deployment
      • GAS Functions for Updating the location file after deployment
    • CSV Customisation
      • Modules of CSV Customisation
      • Diagram on CSV customisation
      • GAS Functions for CSV customisation
    • Updating username
      • Manual module of Updating username
      • Diagram on Updating username
      • GAS Functions for Updating username
    • Autorizing user access
      • Manual module of Autorizing user access
      • Diagram on Autorizing user access
      • GAS Functions for Autorizing User Access
    • Suspending user access
      • Manual module of Suspending user access
      • Diagram on Suspending user access
      • GAS Functions for Suspending user access
    • Sample profiling
      • Modules of Sample profiling
      • Diagram on Sample profiling
      • GAS Functions for Sample profiling
    • Updating data for Beneficiary Survey
      • Modules of Updating data for Beneficiary Survey
      • Diagram on Updating data for Beneficiary Survey
      • GAS Functions for Updating data for Beneficiary Survey
    • Data Harmonization and Cleaning
      • Livelihoods Module - Data Cleaning and Harmonisation of Crop/Animal/Local Units and TOP/BOTTOM CODING
        • Modules of Data Cleaning
        • Diagram on Data Cleaning
        • GAS Functions for Data Cleaning
      • Livelihoods Module - UPDATE HARMONISATION LIST
        • Modules of updating harmonisation list
        • How to harmonise the CROP or ANIMAL NAME if you find “other” in column D of the HAM tab
      • Energy Module - Data Cleaning - KPT Day 1 - 2 matching, USD conversion and Top/Bottom coding
        • Modules of Data Cleaning for Energy Module
        • Diagram on Data Cleaning of Energy Module
        • GAS Functions for Data Cleaning of Energy Module
    • Country Analysis Note
      • Creating and updating a problem statement
        • Modules of Creating and Updating a problem statement
        • GAS Functions for Creating and Updating a problem statement
      • Extracting Country Analysis Note
        • Modules of Extracting Country Analysis Note
        • Diagram on Extracting Country Analysis Note
        • GAS Functions for Extracting Country Analysis Note
      • Generating PDF version
        • Modules of Generating PDF version
    • Generate PDF for beneficiary form
    • Updating the Global Indicators
  • Duplication process
    • Manage a Google Account
      • Set up a Google account
      • Google Account Settings
    • Set up a Google script account
    • System duplication methods
      • 1. Complete system duplication with the new settings
        • Duplicate the monitoring sheet
        • Folder structure in Google drive account
        • Set up the kobo accounts
        • Enable API on Google script
        • Link kobo accounts to the script
        • Tests in the control panel
        • Troubleshooting
      • 2. Creating an a child of Control Panel
        • Duplicate the monitoring sheet of Control Panel
        • Connect Library
        • Adjust parameters
Livelihoods and Energy Control Panel
  • »
  • Description of the main processes »
  • Data Harmonization and Cleaning
  • View page source

Data Harmonization and Cleaning¶

  • Livelihoods Module - Data Cleaning and Harmonisation of Crop/Animal/Local Units and TOP/BOTTOM CODING
    • Modules of Data Cleaning
    • Diagram on Data Cleaning
    • GAS Functions for Data Cleaning
  • Livelihoods Module - UPDATE HARMONISATION LIST
    • Modules of updating harmonisation list
    • How to harmonise the CROP or ANIMAL NAME if you find “other” in column D of the HAM tab
  • Energy Module - Data Cleaning - KPT Day 1 - 2 matching, USD conversion and Top/Bottom coding
    • Modules of Data Cleaning for Energy Module
    • Diagram on Data Cleaning of Energy Module
    • GAS Functions for Data Cleaning of Energy Module
Next Previous

© Copyright 2020, CartONG.

Built with Sphinx using a theme provided by Read the Docs.