Data Transformation and Management

This section allows you to process and refine uploaded datasets for analysis.

• Calculator:

  • Write your formula (e.g., "PET - Precipitation" for water deficit)

  • Name your output variable and run the calculation

• Convert CSV to NetCDF:

  • Upload your CSV file.

  • Select the column names that you want to convert.

  • Name your output file.

• Clip NC with SHP:

  • Start Clipping: Click the "Start Cliping" button.

  • Save Output: Choose "Save NetCDF File" to save the cropped NetCDF file.

• Find Missing Time Steps in NetCDF:

  • Select Frequency: Choose daily/monthly/yearly.

  • Run Analysis: Click "Find & Fill Missing Time Steps" → auto-detects gaps.

  • Download:

    • CSV (missing dates log)

    • NetCDF (with identified time steps)

• Interpolate Missing Values:

  Fill NaNs Along One Dimension

  1. Select Method: Choose (Linear, Cubic, Nearest).

  2. Pick Dimension: Time/Latitude/Longitude.

  3. Run: Click "Fill NaNs Along Selected Dimension".

  4. Output: Interpolated NetCDF file.

  Fill NaNs Across All Dimensions

  1. Select Method: Choose (Linear, Cubic, Nearest).

  2. Run: Click "Fill NaNs Across All Dimensions".

  3. Output: Fully interpolated NetCDF file.

• Merge NetCDF Files:

  Option 1: Concatenate (Along time/variables)

  1. Select Method: Choose "Concatenate".

  2. Pick Dimension: Time/Latitude/Longitude.

  3. Upload Files: Select all NetCDFs to combine.

  4. Download: Single merged file (.nc).

  Option 2: Merge (Grid-based merging)

  1. Select Method: Choose "Merge" (for overlapping grids).

  2. Upload Files: Add spatially compatible NetCDFs.

  3. Download: Single merged file (.nc).

• Option 3: Smart Merge (Advanced concatenation with handling for overlapping data)

  • Select Method: Choose "Smart Merge".

  • Pick Dimension: Time/Latitude/Longitude.

  • Upload Files: Select all NetCDFs to combine.

  • Download: Single merged file (.nc).

• Resample Resolution (Select Resample Method)

  Option 1: Interpolation (For Higher resolution)

  1. Set Target: Enter resolution (e.g., 0.25°).

  2. Select Interpolation Method: Choose (Linear, Nearest, Cubic).

  3. Run: Click "Resample via Interpolation".

  4. Download: Download resampled NetCDF.

  Option 2: Coarsening (For Lower resolution)

  1. Set Factors: Enter lat/lon coarsening (e.g., 2x2).

  2. Aggregate: Pick function (Mean, Sum).

  3. Run: Click "Resample via Coarsening".

  4. Download: Download resampled NetCDF.

• Split NetCDF file (Select Splitting Method)

  Option 1: Index-Based Splitting (Fixed-size chunks)

  1. Select Dimension: Time/Latitude/Longitude.

  2. Set Chunk Size: Enter number of steps (e.g., 12 for monthly splits).

  3. Run: Click "Split Dataset".

  4. Download: ZIP of split files (e.g., file_001.nc, file_002.nc).

  Option 2: Label-Based Splitting (Custom ranges)

  1. Select Coordinate: Time/Latitude/Longitude.

  2. Set Range: Enter start/end values.

  3. Run: Click "Split Dataset".

  4. Download: ZIP of sliced files.