/Python/Sumif in python on a column and create new column

Sumif in python on a column and create new column

df['treat_rate']=df.treats/df.groupby('pet').treats.transform('sum')
df
Out[153]: 
    pet  treats  lbs  treat_rate
0   cat       2  5.0        0.25
1   dog       1  9.9        0.50
2  snek       3  1.1        1.00
3   cat       6  4.5        0.75
4   dog       1  9.4        0.50

Source: stackoverflow.com

Similar codes

0 vote178 views2 answers
Leer fichero linea por linea python
Python
-1 vote179 views2 answers
Python path absolute
Python
-1 vote212 views1 answer
Flask set mime type
Python Flask
3 votes188 views2 answers
How to check if python is installed on mac
Python
2 votes176 views2 answers
Python greatest common divisor
Python
4 votes182 views3 answers
Read file into list python
Python
2 votes197 views2 answers
Super in django manager
Python
2 votes157 views1 answer
Use of == python
Python
16 votes168 views2 answers
What is self keyword in python
Python
0 vote164 views1 answer
Two legend left and right x asix matplotlib
Python