In KWB-R/fakin.doc: Does not matter.

Data Processing

Data are often inconsistent, incomplete, incorrect, or misspelled. Data cleaning is essential.

For data cleaning you may use a GUI (Graphical User Interface) based tool like OpenRefine http://openrefine.org/ or choose a programmatic approach.

In the following we describe how data can be imported into the R-Programming Environment, which can be used for data cleaning, aggregation and visualisation. r knitcitations::citep(manual["Grolemund_2017"])

Logger Devices

The R package kwb.logger r knitcitations::citep(manual["Sonnenberg_2018"]) helps to import raw data from loggers used in different KWB projects into the software R r knitcitations::citep(citation()), which is used for data processing (e.g. data cleaning, aggregation and visualisation).

{block2, type = 'rmdtip'} For details, which loggers currently are supported by the R packages [kwb.logger](https://kwb-r.github.io/kwb.logger) please check the [documentation website](https://kwb-r.github.io/kwb.logger/reference/index.html).

Spreadsheets

General recommendations for working with EXCEL spreadsheets is given in the FAQs section.

Import Data From One Excel File

• Save the original file in the rawdata zone.

Import Data From Many Excel Files

Files Are In the Same Format

Import Excel files of the same format by

• defining a function that is able to read the data from that file
• calling this function in a loop for each file to import.

Files Are In Different Formats

We developed a general approach of importing data from many Excel files in which the formats (e.g. more than one table area within one sheet, differing numbers of header rows) differ from file to file.

KWB-R/fakin.doc documentation built on Sept. 27, 2019, 9:53 p.m.