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 vote124 views1 answer
Set_flip_h( false )
Python
0 vote181 views1 answer
Django populate database in view
Python Django
0 vote139 views1 answer
Bucketizer pyspark
Python
2 votes128 views1 answer
Local ip
Python
0 vote123 views2 answers
Grid list python
Python
1 vote139 views1 answer
Print console sys.stdout
Python
21 votes175 views2 answers
Getting pi in python
Python
3 votes125 views3 answers
Pandas merge two dataframes remove duplicates
Python
0 vote119 views1 answer
For loop get rid of stop words python
Python
1 vote120 views1 answer
How to check if string is camelcase python
Python