Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

QA: Can I use rxSummary() to bin my data and compute group percentages?


View products that this article applies to.

One way to do this would be as follows.

You can compute the total group sums using rxSummary() and use that to compute the group percentages:

df <- data.frame(g = c('1', '0', '1', '0'), a=c(1, 2, 3, 4)) 
sums.within.g <- rxSummary(a ~ g, data = df, summaryStats = "Sum") 
sums.within.g <- sums.within.g$categorical[[1]][,3]

numRows <- length(unique(df$g)) 
totSum <- cumsum(sums.within.g) 
totSum <- totSum[length(totSum)] 
df.percentages <- sums.within.g / totSum 
names(df.percentages) <- levels(df$g)

> df.percentages 
0 1 
0.6 0.4

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 3104220
Revision : 1
Created on : 1/7/2017
Published on : 10/29/2015
Exists online : False
Views : 56