The massive amounts of data from sensors, which is usually recorded in a high
temporal resolution (up to every second) is challenging for data processing and
visualisation. Especially if standard tools like MS EXCEL are used, which are
not well suited for such tasks to data import restrictions (e.g. rows per
spreadsheet limited to maximum 1 million rows in MS EXCEL 2010) or missing
built-in features for data aggregation (e.g. calculating one hour median values
from the raw data).
In addition operational data often needs to be combined with analytical data
(usually with a temporal resolution of days to weeks) for example in order to
(1) assess the impact of the plant’s operation scheme (e.g. flow rate) on its
performance for reducing specific substances or for (2) calculating substance
loads (by multiplying substance concentrations with flow rates)
Within the AQUANES project – in order to address the above challenges for small
companies or wa-ter operators – a data visualization and reporting tool was
developed with the software R (www.r-project.org), which enables the user to:
- Explore online and offline data at different temporal aggregation levels
(e.g. raw data or 10 minutes median values)
- Create automated reports not only including the raw (online/offline) data
but also with more advanced calculations combining different online and/or
offline data (e.g. specific en-ergy demand)
In a first step, the R reporting tool was implemented and tested for the AQUANES site Haridwar, which is described in this report.
The objective of this report is to document the following four processes for the R reporting tool:
Note: This report is based on version 0.4.0 of the R package “aquanes.report”, which is available for download at Zenodo or Github and released using the open-source MIT licence.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.