Learn R Programming

healthcareai (version 1.2.4)

groupedLOCF: Last observation carried forward

Description

Carries the last observed value forward for all columns in a data.table grouped by an id.

Usage

groupedLOCF(df, id)

Arguments

df

data frame sorted by an ID column and a time or sequence number column.

id

A column name (in ticks) in df to group rows by.

Value

A data frame where the last non-NA values are carried forward (overwriting NAs) until the group ID changes.

References

http://healthcareai-r.readthedocs.io

See Also

healthcareai

Examples

Run this code
# NOT RUN {
df <- data.frame(personID=c(1,1,2,2,3,3,3),
                wt=c(.5,NA,NA,NA,.3,.7,NA),
                ht=c(NA,1,3,NA,4,NA,NA),
                date=c('01/01/2015','01/15/2015','01/01/2015','01/15/2015',
                       '01/01/2015','01/15/2015','01/30/2015'))

head(df,n=7)

dfResult <- groupedLOCF(df, 'personID')

head(dfResult, n = 7)
# }

Run the code above in your browser using DataLab