Madagascar_​workflow

Upload the first source file (mashup.csv) for further processing and analysis.The data contains aggregated information about regions, years, drought index, and precipitation indicators.

Upload a second source file (spi_timeseries.csv), which contains monthly SPI values by region.This dataset is used to derive annual drought indicators

Data cleanup: transforming strings into the desired format (e.g. removing extra spaces or normalizing region names) to ensure consistency across datasets.

Processing the second dataset: applying string transformations to normalize region names and prepare the data for merging.

Exporting the curated dataset as CSV for use in visualizations and RDF publication on the project website.

Merging two datasets by common keys (region_name and year).This step creates a mash-up dataset that combines precipitation and SPI drought indicators in a single harmonized table.

Converting date strings into Date&Time format to support temporal aggregation and correct interpretation of time-based values.

Removing unnecessary columns and keeping only the indicators required for visualization and reporting.