使用 data.table 按组计算值的百分比/比例 [英] Calculate percentages / proportions of values by group using data.table

问题描述

我有一个如下所示的 data.table:

I have a data.table that looks like the following:

x, y, sum(count)
1, 1, 3
1, 2, 7
1, 3, 8
2, 1, 4
2, 2, 3
2, 3, 10

等等.它由 x 和 y 键入，我在 count 列上做了一个 sum.我想按 x 的值将其分解为百分比，使其变为:

And so on. It's keyed by x and y and I did a sum on a count column. I would like to break it down into percentages by the values of x so that it becomes:

x, y, percentage(counts)
1, 1, 16.7
1, 2, 38.9
1, 3, 44.4
2, 1, 23.5
2, 2, 17.6
2, 3, 58.8

这样每个 x 值的总百分比总计为 100%.我正在使用 data.table 包执行此操作.提前感谢您的帮助.

So that the total percentage per x value totals 100%. I am doing this using the data.table package. Thank you in advance for your help.

推荐答案

我不太明白 data.table 已经发布的解决方案，所以我会这样做(我会改变列的名称不要有括号，以避免列名的大量反引号(！):

I don't quite understand the data.table solution already posted, so I would do it like this (and I would change the name of the columns to not have parentheses to avoid lots of backtick quoting(!) of column names):

dt[ , `percentage(counts)` := `sum(count)` / sum( `sum(count)` ) * 100 , by = "x" ]
#   x y sum(count) percentage(counts)
#1: 1 1          3           16.66667
#2: 1 2          7           38.88889
#3: 1 3          8           44.44444
#4: 2 1          4           23.52941
#5: 2 2          3           17.64706
#6: 2 3         10           58.82353

这篇关于使用 data.table 按组计算值的百分比/比例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！