expand_binned: Expand binned frequency data to one record per item

In JenC36/JACtools: A Set of Relatively Useful Functions

Expand binned frequency data to one record per item

Description

This function takes binned data and expands it to one record per item, returning an expanded data frame. For large data sets, this may take a while

Usage

expand_binned(x)

Arguments

x	A dataframe with one column called 'FREQUENCY'. Each row of the dataframe is copied 'FREQUENCY' times.

Value

a dataframe with sum(FREQUENCY) number of records

Examples

Covariate <- c('Red', 'Blue','Red','Red','Blue','Blue')
FREQUENCY <-  c(5,4,5,3,4,1)
ID <- c(1,2,3,4,5,6)

test.dat <- data.frame(ID,Covariate,FREQUENCY)
for(i in 1:length(test.dat$ID)) { 
 if(i==1) expanded.test.dat <- expand_binned(test.dat)
 if (i>1) expanded.test.dat <- rbind(expanded.test.dat, expand_binned(test.dat))
}
test.dat
expanded.test.dat

JenC36/JACtools documentation built on Oct. 20, 2024, 8:05 a.m.