Mask and then fillnan#

a b c 
1 1 5.0
1 1 None
1 1 4.0
1 2 1.0
2 1 2.0
2 1 None

mask = (df['a']==1) & (df['b']==1)
mean = df.loc[mask, 'c'].mean()
df.loc[mask, 'c'] = df.loc[mask, 'c'].fillna(mean)

Source: stackoverflow.com

Similar codes

2 votes215 views2 answers
Super in django manager
Python
0 vote188 views1 answer
Pandas groupby without reset index
Python
3 votes149 views1 answer
Pylint no name in module cv2
Python
0 vote223 views1 answer
Vertica long running queries
Python
0 vote185 views1 answer
Aws lambda environment variables python
Python
1 vote198 views1 answer
What is an integer in python
Python
0 vote195 views1 answer
How to make a nan value in a list
Python
2 votes181 views1 answer
How to find the text inside button in tkinter
Python
0 vote214 views1 answer
Flask windows auto reload
Python Flask
0 vote185 views1 answer
Pandas read excel nan
Python