read_dgi | R Documentation |
Reads excel files provided by the DGI (Hydrological Division).
read_dgi(path, by = "day", out_name = NULL, sheet = NULL, get_sheet = FALSE)
path |
path to the xlsx file. |
by |
string with the time step of the series (e.g.: |
out_name |
optional. String vector with user defined variable(s) column(s) name(s). |
sheet |
optional. Sheet to read. Either a string (the name of a sheet), or an integer (the position of the sheet). If neither argument specifies the sheet, defaults to the first sheet. |
get_sheet |
logical indicating whether you want to print available sheet names ( |
A data frame with the data inside the xlsx file. Gaps between dates are filled
with NA_real_
and duplicated rows are eliminated automatically.
# set path to file
path_file <- system.file('extdata', 'dgi_toscas.xlsx',
package = 'hydrotoolbox')
# because dgi files has multiple sheets we take a look
# on them
read_dgi(path = path_file, get_sheet = TRUE)
# read swe with default column names
head( read_dgi(path = path_file, sheet = 'swe') )
# assign name
head( read_dgi(path = path_file, sheet = 'swe', out_name = 'swe(mm)') )
# now read relative humidity
head( read_dgi(path = path_file, sheet = 'hr', out_name = 'rh(%)') )
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.