Retrieves a time series from a a text file (.txt, .csv...)
Usage
txt_series(
file,
series,
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.cleanMissing = TRUE,
charset = NULL,
delimiter = c("TAB", "SEMICOLON", "COMMA", "SPACE"),
txtQualifier = c("NONE", "QUOTE", "DOUBLE_QUOTE"),
header = TRUE,
skip = 0
)Arguments
- file
The text file
- series
The name or the 1-based position of the series in the selected sheet
- 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 transformed series. If 0, the actual frequency is used.
- 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.cleanMissing
Specifies if missing values at the beginning or at the end of the data are removed from the 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 lines
Examples
set_txt_paths(system.file("extdata", package = "rjd3providers"))
txt_15 <- txt_series("ABS.csv", series = 15, delimiter = "COMMA")
txt_09 <- txt_series("ABS.csv", series = "0.2.09.10.M", delimiter = "COMMA")