Python - Add to dataframe conditioned median values

Question

I have a basic question.

DataFrame:

Name   Value
Albert  5
Dudu    7
Albert  15
Dudu    10
Albert  2
Dudu    4

How to add an additional column with medians for each Name?

To get this output:

Name   Value   Median
Albert  5       5
Dudu    7       7
Albert  15      5
Dudu    10      7
Albert  2       5
Dudu    4       7

thanks

See marked duplicate. The solution is generalizable to arbitrary functions. — jpp, Oct 07 '19 at 09:55

score 0 · Accepted Answer · answered Oct 07 '19 at 09:51

0

You are looking for Transformations:

df['Median'] = df.groupby('Name').transform('median')

answered Oct 07 '19 at 09:51

Marijn van Vliet

1 Answers1