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

2 votes193 views1 answer
Groups the DataFrame using the specified columns
Python
17 votes195 views4 answers
How to get int input in python
Python
0 vote195 views1 answer
Pylatex add package
Python
0 vote186 views1 answer
Newsapi in python
Python
2 votes182 views1 answer
Renaming row value in pandas
Python
0 vote205 views1 answer
How to set pywal permenent
Python
3 votes147 views1 answer
Cannot import name 'flask' from partially initialized module 'flask' (most likely due to a circular import)
Python
1 vote189 views2 answers
Group by dateime pandas
Python
4 votes205 views1 answer
Any python
Python
0 vote186 views1 answer
Webdriver.chrome() python not working
Python