将列占总数的列添加到Pandas数据框 [英] Add column for percentage of total to Pandas dataframe

问题描述

我有一个数据框，正在执行 groupby()来获取列值的计数.我正在尝试为总计百分比"添加一个附加列.我不确定如何做到这一点.

I have a dataframe that I am doing a groupby() on to get the counts on a column's values. I am trying to add an additional column for "Percentage of Total". I'm not sure how to accomplish that.

我查看了一些groupby选项，但似乎找不到合适的东西.

I've looked at a few groupby options, but can't seem to find anything that fits.

我的数据框如下:

              DAYSLATE
DAYSLATE          
-7 days          1
-5 days          2
-3 days          8
-2 days          9
-1 days         45
0 days         589
1 days          33
2 days           8
3 days          16
4 days          14
5 days          16
6 days           2
7 days           6
8 days           2
9 days           2
10 days          1

推荐答案

选项1

df['DAYSLATE_pct'] = df.DAYSLATE / df.DAYSLATE.sum()

选项2
使用 pd.value_counts 而不是 groupby

pre_df.DAYSLATE.value_counts(normalize=True)

这篇关于将列占总数的列添加到Pandas数据框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！