add_intid: Add a grouped integer ID to a dataframe

In arestrom/remisc: Some simple utility functions for personal use

Description

Adds a new unique ID to each member of a group in a dataframe. This is especially useful when processing data for upload to a database that uses integer IDs as unique primary keys. A single unique ID can be generated for each member of a group without first having to separate out the group and filtering to unique values.

Usage

add_intid(dat, key_cols, id_name, start_id)

Arguments

dat	A dataframe
key_cols	The group of variables that will be assigned a unique ID
id_name	The name to assign to the ID variable
start_id	The ID value used to start the ID sequence. If 0 the IDs start at 1.

Examples

# Create an example dataframe
dat = tibble::tibble(lat = c(rep(47.6590, 7),
                             rep(47.6348, 3),
                             47.9033),
                     lon = c(rep(-122.4657, 4),
                             rep(-122.8743, 3),
                             rep(-122.8876, 2),
                             -122.8345, -122.4443),
                     species = c("chum", "chin", "chin",
                                 "sthd", "chin", "sthd",
                                 "sthd", "chum", "chum",
                                 "pink", "pink"))

# Add an integer ID, grouped by the key columns
dat = add_intid(dat, key_cols = c("lat", "lon", "species"),
                id_name = "survey_id", start_id = 100)

arestrom/remisc documentation built on July 16, 2020, 8:48 a.m.