Package: kwb.pilot 0.3.0

Michael Rustler

kwb.pilot: Importing, Aggregating and Visualising Data From KWB Pilot Plants

Collects, aggregates and visualises operational and analytical data from water suppliers (including a standardised reporting document).

Authors:Michael Rustler [aut, cre], Hauke Sonnenberg [ctb], AquaNES [fnd], MBR 4.0 [fnd], SULEMAN [fnd], ULTIMATE [fnd], Kompetenzzentrum Wasser Berlin gGmbH [cph]

kwb.pilot_0.3.0.tar.gz
kwb.pilot_0.3.0.zip(r-4.5)kwb.pilot_0.3.0.zip(r-4.4)kwb.pilot_0.3.0.zip(r-4.3)
kwb.pilot_0.3.0.tgz(r-4.4-any)kwb.pilot_0.3.0.tgz(r-4.3-any)
kwb.pilot_0.3.0.tar.gz(r-4.5-noble)kwb.pilot_0.3.0.tar.gz(r-4.4-noble)
kwb.pilot_0.3.0.tgz(r-4.4-emscripten)kwb.pilot_0.3.0.tgz(r-4.3-emscripten)
kwb.pilot.pdf |kwb.pilot.html✨
kwb.pilot/json (API)
NEWS

# Install 'kwb.pilot' in R:
install.packages('kwb.pilot', repos = c('https://kwb-r.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/kwb-r/kwb.pilot/issues

On CRAN:

data-aggregationdata-importdata-visualisationproject-aquanesproject-mbr40project-sulemanproject-ultimate

71 exports 1 stars 0.23 score 124 dependencies 17 scripts

Last updated 2 years agofrom:e7189f774e. Checks:OK: 1 WARNING: 6. Indexed: yes.

TargetResultDate
Doc / VignettesOKAug 21 2024
R-4.5-winWARNINGAug 21 2024
R-4.5-linuxWARNINGAug 21 2024
R-4.4-winWARNINGAug 21 2024
R-4.4-macWARNINGAug 21 2024
R-4.3-winWARNINGAug 21 2024
R-4.3-macWARNINGAug 21 2024

Exports:%>%add_labeladd_parameter_metadataadd_site_metadataaggregate_export_fst_berlin_faggregate_export_fst_berlin_saggregate_export_fst_berlin_taggregate_export_fst_mbr4calculate_operational_parameterscalculate_operational_parameters_berlin_fcalculate_operational_parameters_berlin_scalculate_operational_parameters_berlin_tcalenderweek_from_dateschange_timezonecheck_env_influxdb_ultimatecheck_env_nextcloudcheck_thresholdscreate_monthly_selectioncreate_report_batchcreate_wedeco_metafiledownload_nextcloud_filesdygraph_add_limitsexport_dataget_env_influxdb_ultimateget_monthly_data_from_calendarweeksget_monthly_periodsget_pivot_dataget_rawfilespaths_for_monthget_thresholdsget_valid_timezonesgroup_datetimeimport_analytics_baselimport_analytics_meta_baselimport_data_baselimport_data_berlin_fimport_data_berlin_simport_data_berlin_timport_data_haridwarimport_lab_data_berlin_timport_operationimport_operation_baselimport_operation_meta_baselimport_sheetsload_fst_datalong_to_widemerge_and_export_fstmove_nextcloud_filesnormalised_permeate_flowplot_analyticsplot_calculated_operational_timeseriesplot_dataread_fstread_mbr4read_mbr4_archivedread_mbr4_latestread_pentair_dataread_wedeco_dataread_weintekread_weintek_batchremove_duplicatesreport_config_templatereport_config_to_txtreport_txt_to_configrun_appset_timezoneshiny_filetidy_mbr4_datawrite_aggr_to_influxdbwrite_aggr_to_influxdb_loopwrite_to_influxdbwrite_to_influxdb_loop

Dependencies:askpassbase64encbitbit64blobbslibcachemcellrangerclicliprcolorspacecommonmarkcpp11crayoncrosstalkcurldata.tableDBIdbplyrdigestdplyrdygraphsevaluatefansifarverfastmapfasttimefontawesomefsfstfstcoregenericsggforceggplot2gluegtablehighrhmshtmltoolshtmlwidgetshttpuvhttrinfluxdbclientisobandjanitorjquerylibjsonliteknitrkwb.filekwb.nextcloudkwb.utilslabelinglaterlatticelazyevalleafletleaflet.providerslifecyclelubridatemagrittrMASSMatrixmemoisemgcvmimemunsellnanotimenlmeopensslpillarpkgconfigplotlyplyrpngpolyclipprettyunitsprogresspromisespurrrR6rappdirsrasterRColorBrewerRcppRcppCCTZRcppDateRcppEigenreadrreadxlrematchrlangrmarkdownrvestsassscalesselectrshinyshinythemessnakecasesourcetoolsspstringistringrsyssystemfontsterratibbletidyrtidyselecttimechangetinytextweenrtzdbutf8vctrsviridisLitevroomwithrxfunxml2xtablextsyamlzoo

0 Introduction

Rendered fromA0_intro.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

1 Installation

Rendered fromA1_installation.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

2 App Start

Rendered fromA2_app_start.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

3.0 GUI Overview

Rendered fromA3_0_gui_overview.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

3.1 GUI Explore Panel

Rendered fromA3_1_gui_explore.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-08-20
Started: 2019-11-28

3.2 GUI Report Panel

Rendered fromA3_2_gui_report.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

3.3 GUI Background panel

Rendered fromA3_3_gui_background.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

3.4 GUI Site Panel

Rendered fromA3_4_gui_site.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-02-26
Started: 2019-11-28

4 Modify

Rendered fromA4_modify.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2019-11-28
Started: 2019-11-28

Pilot: MBR 4.0

Rendered frommbr40.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2022-06-01
Started: 2021-08-20

Pilot: SULEMAN

Rendered fromsuleman.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2021-08-20
Started: 2021-02-26

Pilot: Ultimate

Rendered fromultimate.Rmdusingknitr::rmarkdownon Aug 21 2024.

Last update: 2022-06-08
Started: 2022-06-01

Readme and manuals

Help Manual

Help pageTopics
Helper function: add label ("SiteName_ParaName_Unit_Method")add_label
Helper function: add parameter metadataadd_parameter_metadata
Helper function: add site metadataadd_site_metadata
Berlin-Friedrichshagen: aggregate and export to fstaggregate_export_fst_berlin_f
Berlin-Schoenerlinde: aggregate and export to fstaggregate_export_fst_berlin_s
Berlin-Tiefwerder: aggregate and export to fstaggregate_export_fst_berlin_t
MBR4.0: aggregate and export to fstaggregate_export_fst_mbr4
Calculate operational parameterscalculate_operational_parameters
Calculate operational parameters for Berlin-Friedrichshagencalculate_operational_parameters_berlin_f
Calculate operational parameters for Berlin-Schoenerlindecalculate_operational_parameters_berlin_s
Calculate operational parameters for Berlin-Tiefwerdercalculate_operational_parameters_berlin_t
Helper function: get calender weeks for time periodcalenderweek_from_dates
Timezone change: changes time zone to user defined time zonechange_timezone
Helper Function: check if all environment variables for ULTIMATE InfluxDB are definedcheck_env_influxdb_ultimate
Helper Function: check if all environment variables for Nextcloud are definedcheck_env_nextcloud
Check thresholdscheck_thresholds
Create monthly selectioncreate_monthly_selection
Report batch: creates batch file for reportcreate_report_batch
Create WEDECO metafile datacreate_wedeco_metafile
Helper Function: Download Nextcloud Files from a Directorydownload_nextcloud_files
Dygraph: add (multiple) horizontal lines to plotdygraph_add_limits
CSV data export in "wide" formatexport_data
Helper Function: get influxdb config for Ultimate if defined definedget_env_influxdb_ultimate
Helper function for Berlin-S: get all calendar week files for monthyget_monthly_data_from_calendarweeks
Get monthly periodsget_monthly_periods
InfluxDB: Get Pivot Data from ultimate_mean_ bucketget_pivot_data
Berlin-Tiefwerder: get rawfilepaths for monthsget_rawfilespaths_for_month
Get thresholds for analytics/operational parametersget_thresholds
Timezone: get valid time zones from Wikipediaget_valid_timezones
Group DateTime by user defined period (year, month, day, hour, minute)group_datetime
Imports analytical data for Basel (without metadata)import_analytics_basel
Imports analytical data for Basel (with metadata for both sites at once, i.e. "rhein" and "wiese")import_analytics_meta_basel
Imports operational & analytical data for Basel (with metadata for both sites at once, i.e. "rhein" and "wiese")import_data_basel
Import data for Berlin Friedrichshagenimport_data_berlin_f
Import data for Berlin Schoenerlindeimport_data_berlin_s
Import data for Berlin Tiefwerderimport_data_berlin_t
Imports Haridwar dataimport_data_haridwar
BerlinTiefwerder: import lab dataimport_lab_data_berlin_t
Imports operational dataimport_operation
Imports operational data for Basel (without metadata and only for one site at once, e.g. "rhein" or "wiese")import_operation_basel
Imports operational data for Basel (with metadata for both sites at once, i.e. "rhein" and "wiese")import_operation_meta_basel
Imports multiple analytics sheets from an EXCEL spreadsheetimport_sheets
Load fst data for shiny appload_fst_data
Helper function: transform "long" to "wide"long_to_wide
Helper function: merge and export fst files into main shiny data foldermerge_and_export_fst
Move Nextcloud Filesmove_nextcloud_files
Calculate normalised permeate flownormalised_permeate_flow
Plot analytics data (in PDF)plot_analytics
Plot calculate operational time seriesplot_calculated_operational_timeseries
Export interactive HTML plot with "plotly"plot_data
Wrapper for fst::read.fst to read DateTime column in POSIXct formatread_fst
Read MBR4.0 data combining latest and archived dataread_mbr4
Read MBR4.0 archived data from Nextcloudread_mbr4_archived
Read MBR4.0 data from Martin Systems Webportal (As "tsv")read_mbr4_latest
Read MBR4.0 tsv dataread_mbr4_tsv
Read PENTAIR operational dataread_pentair_data
Import WEDECO raw dataread_wedeco_data
Read Weintek data from single fileread_weintek
Read Weintek data from multiple filesread_weintek_batch
Remove duplicates in data.frameremove_duplicates
Report config: generate templatereport_config_template
Report config: saves config to text filereport_config_to_txt
Report config: imports text file to listreport_txt_to_config
Runs Shiny app for an AQUANES siterun_app
Timezone set: sets a user defined time zoneset_timezone
Path to Shiny File in Packageshiny_file
MBR 4.0 Data Tidytidy_mbr4_data
InfluxDB: write aggregated time series to Ultimate target bucketwrite_aggr_to_influxdb
InfluxDB: write aggregated time series to Ultimate target bucket in loopwrite_aggr_to_influxdb_loop
InfluxDB: write to InfluxDBwrite_to_influxdb
InfluxDB: write to InfluxDB in Loopwrite_to_influxdb_loop