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

0 vote164 views1 answer
Platform.system() return value
Python
0 vote214 views1 answer
Creating empty set and append python
Python
4 votes167 views1 answer
Python pygame screen example
Python
0 vote190 views1 answer
Remove whitespace around figure matplotlib
Python
0 vote191 views1 answer
With torch.no_grad() if condition
Python
10 votes165 views4 answers
Write text in list to text file python
Python
25 votes197 views3 answers
Python catch all exceptions
Python
1 vote184 views1 answer
Replace all spacec column with underscore in pandas
Python
0 vote271 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python
0 vote174 views1 answer
Scaling Operation in SkLearn
Python