pandas显示百分数_pandas groupby和列中每个值出现的百分比

df['created_column'] = df.groupby('iv_5')['iv_5'].transform('size').div(len(df)).le(0.4).view('i1')

print (df)

iv_1 iv_2 iv_3 iv_4 iv_5 col2rplc created_column

0 0 0 0 0 0 a 0

333 0 0 0 0 0 b 0

222 1 2 3 4 5 aa 1

324 1 2 3 4 5 cc 1

1234 1 0 0 0 1 a 1

1235 0 2 0 4 0 a 0

1236 0 0 3 0 0 a 0

1237 0 0 1 0 0 b 0

1238 0 2 0 2 0 b 0

1239 3 0 0 0 3 b 1

s = df['iv_5'].value_counts(normalize=True)

idx = s.index[s <= 0.4]

df['created_column'] = df['iv_5'].isin(idx).view('i1')

如果需要

Series.between

>=

,

<=

,用于

>

和

<

使用参数

inclusive=False

:

df['created_column'] = df.groupby('iv_5')['iv_5'].transform('size').div(len(df)).between(0.2, 0.5).view('i1')

print (df)

iv_1 iv_2 iv_3 iv_4 iv_5 col2rplc created_column

0 0 0 0 0 0 a 0

333 0 0 0 0 0 b 0

222 1 2 3 4 5 aa 1

324 1 2 3 4 5 cc 1

1234 1 0 0 0 1 a 0

1235 0 2 0 4 0 a 0

1236 0 0 3 0 0 a 0

1237 0 0 1 0 0 b 0

1238 0 2 0 2 0 b 0

1239 3 0 0 0 3 b 0

如需组合

>

和

<=

不能使用between,以下是备选方案:

s1 = df.groupby('iv_5')['iv_5'].transform('size').div(len(df))

df['created_column'] = ((s1 > 0.2) & (s1 <= 0.6)).view('i1')

print (df)

iv_1 iv_2 iv_3 iv_4 iv_5 col2rplc created_column

0 0 0 0 0 0 a 1

333 0 0 0 0 0 b 1

222 1 2 3 4 5 aa 0

324 1 2 3 4 5 cc 0

1234 1 0 0 0 1 a 0

1235 0 2 0 4 0 a 1

1236 0 0 3 0 0 a 1

1237 0 0 1 0 0 b 1

1238 0 2 0 2 0 b 1

1239 3 0 0 0 3 b 0