Compute daily and monthly mean from meteorological station measurements
Version 1

Workflow Type: Galaxy
Stable

This workflow is used to process timeseries from meteorological stations in Finland but can be applied to any timeseries according it follows the same format.

Take a temperature timeseries from any meteorological station. Input format is csv and it must be standardized with 6 columns:

  1. Year (ex: 2021)
  2. month (ex: 1)
  3. day (ex: 15)
  4. Time (ex: 16:56)
  5. Time zone (such as UTC)
  6. Air temperature (degC)

Inputs

ID Name Description Type
Temperature timeseries (csv) Temperature timeseries (csv) Data is usually sampled at a higher frequency (from second to a few minutes). The dataset must contain 6 columns: 1. Year 2.m 3.d 4.Time 5.Time zone (such as UTC) 6. Air temperature (degC)
  • File

Steps

ID Name Description
1 Convert CSV to tabular csv_to_tabular
2 Merge date columns to YYYYMMDD toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_awk_tool/1.1.2
3 Text reformatting toolshed.g2.bx.psu.edu/repos/bgruening/text_processing/tp_awk_tool/1.1.2
4 Prepare daiky means toolshed.g2.bx.psu.edu/repos/iuc/datamash_ops/datamash_ops/1.1.0
5 Daily mean toolshed.g2.bx.psu.edu/repos/iuc/datamash_ops/datamash_ops/1.1.0
6 Monthly mean toolshed.g2.bx.psu.edu/repos/iuc/datamash_ops/datamash_ops/1.1.0
7 Positive only Filter1
8 Negative only Filter1
9 Daily climate stripes toolshed.g2.bx.psu.edu/repos/climate/climate_stripes/climate_stripes/1.0.1
10 Monthly climate stripes toolshed.g2.bx.psu.edu/repos/climate/climate_stripes/climate_stripes/1.0.1
11 Prepare bar chart toolshed.g2.bx.psu.edu/repos/iuc/collection_column_join/collection_column_join/0.0.3
12 bar char for daily temperatures (C) barchart_gnuplot

Outputs

ID Name Description Type
daily_mean_timeseries daily_mean_timeseries n/a
  • File
monthly_mean_timeseries monthly_mean_timeseries n/a
  • File
stripes_daily_temperatures stripes_daily_temperatures n/a
  • File
stripes_monthly_temperatures stripes_monthly_temperatures n/a
  • File
daily_barchart daily_barchart n/a
  • File

Version History

Version 1 (earliest) Created 23rd May 2021 at 20:28 by Anne Fouilloux

Added/updated 1 files


Open master f96fc45
help Creators and Submitter
Creators
Not specified
Submitter
Activity

Views: 2342   Downloads: 130

Created: 23rd May 2021 at 20:28

help Attributions

None

Total size: 26.5 KB
Powered by
(v.1.14.1)
Copyright © 2008 - 2023 The University of Manchester and HITS gGmbH