Groupby fillna ffill

df['three'] = df.groupby(['one','two'], sort=False)['three']
                .apply(lambda x: x.ffill().bfill())
print (df)
   one  two  three
0    1    1   10.0
1    1    1   10.0
2    1    1   10.0
3    1    2   20.0
4    1    2   20.0
5    1    2   20.0
6    1    3    NaN
7    1    3    NaN

Source: stackoverflow.com

Groupby fillna ffill

print (df)
   one  two  three
0    1    1   10.0
1    1    1   40.0
2    1    1    NaN
3    1    2    NaN
4    1    2   20.0
5    1    2    NaN
6    1    3    NaN
7    1    3    NaN

df['three'] = df.groupby(['one','two'], sort=False)['three']
                .apply(lambda x: x.fillna(x.mean()))
print (df)
   one  two  three
0    1    1   10.0
1    1    1   40.0
2    1    1   25.0
3    1    2   20.0
4    1    2   20.0
5    1    2   20.0
6    1    3    NaN
7    1    3    NaN

Source: stackoverflow.com

Similar codes

1 vote269 views1 answer
Python split path at level
Python
2 votes257 views3 answers
Nested dictionary Python
Python
2 votes252 views2 answers
Read mat file header python numpy
Python
0 vote252 views1 answer
Dependency inversion
Python
0 vote329 views1 answer
Request.build_absolute_uri django
Python Django
0 vote256 views1 answer
Left join two dataframes pandas on two different column names
Python
68 votes268 views5 answers
Python main method
Python
18 votes250 views6 answers
Get ip python
Python
12 votes299 views1 answer
Python copy ddictionary
Python
0 vote259 views1 answer
Python change font in 1 line
Python