Python add percantace of specific value per group

Asked Feb 21 '23 at 09:37

Active Feb 21 '23 at 09:37

Viewed 10 times

I have a dataframe:

df = age  is_A
      1    True
      1    False
      2    True
      3    True
      3    True
      3    True
      3    False

I want to have the ratio of 'is_A' for each age

out = age  ratio
       1   0.5
       2    1
       3   0.75

What is the most efficient way for that?

asked Feb 21 '23 at 09:37

Cranjis

1

`df.groupby('age')['is_A'].mean().reset_index(name='ratio')` – jezrael Feb 21 '23 at 09:37
1

Simply use a `mean`: `df.groupby("age")['is_A'].mean()`, or `df.groupby('age', as_index=False).agg(ratio=('is_A', 'mean'))` – mozway Feb 21 '23 at 09:38
a simple solution. – Tornike Kharitonishvili Feb 21 '23 at 09:39

0 Answers0