refresh: Working with refreshable dataframes/tables

In refreshr: Work with Refreshable Datasets that Update their Data Automatically

Working with refreshable dataframes/tables

Description

Refreshes a refreshable dataframes/table by downloading the data from the source and executing the data preparation code (if such code has been specified).

Usage

refresh(df, silent = FALSE)

Arguments

df	The refreshed dataframe/table that is to be updated.
silent	If TRUE then refresh() will not show any outputs on the screen.

Value

The refreshed dataframe/table with up-to-date data.

Examples

## Not run: 

library(data.table)
library(dplyr)

# Load US unemployment rate from Bureau of Labor Statistics
data <- fread("https://download.bls.gov/pub/time.series/ln/ln.data.1.AllData", sep="\t")

# Make refreshable and specify code for data preparation (filter raw data for
# the overall US employment rate) with # being a placeholder for the downloaded
# raw data
data_refresh <- make_refreshable(data,
                     load_code = "data.table::fread(
                        \"https://download.bls.gov/pub/time.series/ln/ln.data.1.AllData\",
                        sep=\"\t\")",
                     prep_code = "filter(#, series_id==\"LNS14000000\")")

# Save refreshable dataframe as RData file (e.g. to share dataset with coworkers or public)
save(data_refresh, file = "refresh.RData")

# Remove dataframe and reload it from file
rm(data_refresh)
load(file = "refresh.RData")

# Refresh the dataframe
data_refresh <- refresh(data_refresh)

# Show properties of refreshable dataframe
properties(data_refresh)

# Check if refreshable dataframe is up-to-date with the remote data source
uptodate(data_refresh)

## End(Not run)

refreshr documentation built on March 18, 2022, 5:55 p.m.