View source: R/table_updateColumn.R
table_updateColumn | R Documentation |
For matching locationID
, records the associated
locationData
is used to replace any existing value in columnName
.
NA
values in locationID
will be ignored.
table_updateColumn( locationTbl = NULL, columnName = NULL, locationID = NULL, locationData = NULL, verbose = TRUE )
locationTbl |
Tibble of known locations. |
columnName |
Name to use for the new column. |
locationID |
Vector of |
locationData |
Vector of data to used at matching records. |
verbose |
Logical controlling the generation of progress messages. |
Updated tibble of known locations.
table_addColumn
table_removeColumn
library(MazamaLocationUtils) locationTbl <- get(data("wa_monitors_500")) wa <- get(data("wa_airfire_meta")) # We will merge some metadata from wa into locationTbl # Record indices for wa wa_indices <- seq(5,65,5) wa_sub <- wa[wa_indices,] locationID <- table_getLocationID( locationTbl, wa_sub$longitude, wa_sub$latitude, distanceThreshold = 500 ) locationData <- wa_sub$siteName locationTbl <- table_updateColumn(locationTbl, "siteName", locationID, locationData) # Look at the data we attempted to merge wa$siteName[wa_indices] # And two columns from the updated locationTbl locationTbl_indices <- table_getRecordIndex(locationTbl, locationID) locationTbl[locationTbl_indices, c("city", "siteName")]
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.