Retrieves all the time series in a text file (.txt, .csv...)

Retrieves all the time series in a text file (.txt, .csv...)

Usage

txt_data(
  file,
  fmt.locale = NULL,
  fmt.date = NULL,
  fmt.number = NULL,
  fmt.ignoreNumberGrouping = TRUE,
  gathering.period = 0,
  gathering.aggregation = c("None", "Sum", "Average", "First", "Last", "Max", "Min"),
  gathering.partialAggregation = FALSE,
  gathering.includeMissing = TRUE,
  charset = NULL,
  delimiter = c("TAB", "SEMICOLON", "COMMA", "SPACE"),
  txtQualifier = c("NONE", "QUOTE", "DOUBLE_QUOTE"),
  header = TRUE,
  skip = 0
)

Arguments

file

The text file

fmt.locale

Locale language. Null to use the default

fmt.date

Format of the date. Null to use the default of the locale

fmt.number

Format of the number. Null to use the default of the locale

fmt.ignoreNumberGrouping

Ignore number grouping

gathering.period

The annual frequency of the series. If 0, the frequency

gathering.aggregation

The type of the aggregation to be applied on the series (only used if "period" is different from 0)

gathering.partialAggregation

Specifies if the aggregation is performed or not when they are missing periods

gathering.includeMissing

Specifies if missing values at the beginning or at the end of the data are included in the time series

charset

Specifies the charset

delimiter

Specifies the delimiter. Should be in ("TAB", "SEMICOLON", "COMMA", "SPACE")

txtQualifier

Character used to qualify text. Should be in ("NONE", "QUOTE", "DOUBLE_QUOTE")

header

The file contains headers

skip

Skips some columns

Value

A ts collection with all the series

Examples

set_txt_paths(system.file("examples", package = "rjd3providers"))
all <- txt_data("ABS.csv", delimiter = "COMMA")