affect_loop_to_parent: Add rows of the parent dataframe

In sharonorengo/koboloops: Operations for kobo loops

Description

Add rows of the parent dataframe

Usage

affect_loop_to_parent(loop, parent, aggregate.function, variable.to.add,
  uuid.name.loop = NULL, uuid.name.parent = NULL)

Arguments

loop	a dataframe containing the loops
parent	a dataframe containing the parent informations
aggregate.function	function specify by the user to aggregate the variable specified in variable.to.add. This function should take a vector as a parameter and return a single output.
variable.to.add	a name character vector. This vector contains the exact variable(s) name(s) of the loop dataframe that the user wants to aggregate. If there are multiple variables, the variables should be aggregate with the same function. The names of the variables if specified are going to be the name of the parent column.
uuid.name.loop	optional: a string that specify the name of the loop column containing the uuids. If not specify, searches for column containing uuid string.
uuid.name.parent	optional: a string that specify the name of the parent column containing the uuids. If not specify, searches for column containing uuid string.

Details

Add to the parent dataframe, column(s) that is(are) the result of the aggregation made on the loop dataframe. This aggregation is defined by the function aggregate.function.

Value

the parent dataframe to which column(s) has been added. The column(s) contains for each parent the result of the aggregation on the loop rows that correspond to the same parent.

Examples

variable.to.add = c(sum_of_child_age="age_child")
parent <- data.frame(uuid=1:10, age_parent=sample(10,30,60),gender=sample(c("F","M"),10,replace = T) )
child <- data.frame (parent_uuid=sample(1:10,20,replace = T), age_child=sample(20,1,18)  gender=sample(c("F","M"),20,replace = T))
family <- affect_loop_to_parent(child, parent,aggregate.function = sum , variable.to.add)

sharonorengo/koboloops documentation built on June 30, 2019, 10:56 a.m.