read.dcf.parsed: read configuration files as (list of) data frames.

In delftfews: delftfews R extensions

Description

these functions are meant for reading various types of configuration files, returning the content as (lists of) data frames.

'read.sheet' reads a file that contains named data.frames and returns the single requested sheet.

Usage

read.sheet(file, sheet, header, sep, fileEncoding, stringsAsFactors, strip.white, ...)

Arguments

file	the name of -or an open connection to- the configuration file.
sheet	the name of the sheet that is to be read
header	in read.sheet, sets default value to TRUE, as opposed to read.table, where it is FALSE.
sep	in read.sheet, sets default value to "\t", as opposed to read.table, where it is " ".
fileEncoding	the encoding of the file to be read.
stringsAsFactors	in read.sheet, sets default value to FALSE, as opposed to read.table, where it is TRUE.
strip.white	in read.sheet, sets default value to TRUE, as opposed to read.table, where it is FALSE.
...	passed to included functions

Details

the first block is assumed to hold only one textual record.

all following blocks are assumed to hold named records formed of only numeric values. the first field is the name of the data.frame in the resulting list, the value of the first field is the name of the record (the row in the data.frame).

an example will help understand. imagine you need defining the global properties fileDescription and sourceSystem and two 'scenario' records, named 'nat' and 'droog'. you put the information in a dcf file, looking something like this:

    fileDescription: overstortput, by LzScripter
    sourceSystem: Lizard G-A Functions

    scenario: nat
    aanslagpeil: -0.38
    afslagpeil: -0.40
    gemaalcapaciteit: 300.0

    scenario: droog
    aanslagpeil: -0.42
    afslagpeil: -0.44
    gemaalcapaciteit: 300.0
  

reading the above file using read.dcf.parsed will give you a list with two elements, named '"fileDescription"' and '"scenario"'. the two elements would look like this:

    $fileDescription
                  fileDescription         sourceSystem
    1 overstortput, by LzScripter Lizard G-A Functions

    $scenario
            aanslagpeil afslagpeil gemaalcapaciteit
      nat         -0.38      -0.40              300
      droog       -0.42      -0.44              300
    

write.PI uses this format for one of its input parameters.

Examples

read.sheet(textConnection('-- first
ts v
"2009-09-30 10:00:00" -2.081609
"2009-09-30 10:15:00" -2.079778

-- second
a b
3 4
2 2'), 'first', sep=" ")

read.sheet(textConnection('-- first
ts v
"2009-09-30 10:00:00" -2.081609
"2009-09-30 10:15:00" -2.079778

-- second
a b
3 4
2 2'), 'second', sep=" ")

delftfews documentation built on May 31, 2017, 2:12 a.m.