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 vote287 views2 answers
Remove a first array of item in python
Python
0 vote281 views1 answer
Creating a record in python
Python
1 vote290 views1 answer
Print(\'Test set predictions:\\n{}\'.format(y_pred))
Python
0 vote303 views1 answer
Module 'torch' has no attribute 'square'
Python
2 votes281 views1 answer
Mario dance dance revolution
Python
8 votes298 views6 answers
Pandas remove outliers
Python
0 vote292 views1 answer
Python ordered indexs of a list
Python
18 votes264 views6 answers
Gui in python
Python
0 vote289 views2 answers
Composition in python
Python
0 vote285 views1 answer
Qt convert image to base64
Python