How to use socio4health GUI ===================================================== For those who prefer a graphical user interface (GUI) over coding, the `Socio4Health GUI `_ provides an easy-to-use platform for data harmonization. This tutorial will guide you through the steps of using a the GUI to export, manage, and harmonize demographic and socioeconomic data. 1. Standardize the raw dictionary ------------------------------------- In the side menu, click on the **Dictionary Standardization** option. This will take you to a new page where you can upload your raw dictionary file. .. image:: ../img/dic_standard.png :align: center :width: 600px :alt: CSV file structure Here you can upload your raw dictionary file in ``CSV`` or Excel format. The raw dictionary should contain the following columns: **question**, **variable_name**, **value**, **description**, and **possible_answers**. Before uploading, ensure that your file is properly formatted and contains all the necessary information. Follow the `dictionary creation tutorial `_ to create your raw dictionary. .. note:: In case it is a Fixed Width File (``FWF``), you can process it by clicking on hte **Is this a fixed width file?** sliding. Once the file is uploaded, click on the **Standardize Dictionary** button. The GUI will process the file, standardize the dictionary according to the required format and load it into the system for further processing. .. image:: ../img/dic_standard2.png :align: center :width: 600px :alt: CSV file structure If needed, you can download the standardized dictionary by clicking on the **Download Standardized Dictionary** button. This will allow you to save a copy of the standardized dictionary as a ``CSV`` file for your records or for further analysis. 2. Data Extraction ------------------------- Choose the data source from the dropdown menu. The available options are: **Internet (URL)**, **Local file**, **Example Brazil Census 2010**, and **Example Colombia Housing Survey 2021**. .. image:: ../img/extractor.png :align: center :width: 600px :alt: extract data from URL If you select **Internet (URL)**, you will need to provide the ``URL`` of the data file you want to upload. Additionally, you can specify any relevant keywords, file extensions to look for, scraping depth and whether the file is a fixed width file (``FWF``). Also make sure to set ``CSV`` parameters such as the separator and the encoding. Once you have filled in all the required information, click on the **Extract Data from URL (or File)** button to start the data extraction process. .. image:: ../img/ext_2.png :align: center :width: 600px :alt: extract data from URL 3. Data Harmonization ------------------------- Once you have extracted the data, you can proceed to harmonize it. Click on the **Harmonization** option in the side menu to access the harmonization page.