Fill missing data based on the other columns same data

Asked Dec 10 '18 at 07:16

Active Dec 10 '18 at 07:23

Viewed 44 times

The data like below:

index  Column A    Column B       Column C   
  0       a           1             NaN  
  1       b           1             12
  2       a           1             11
  3       c           2              5
  4       d           3              7
  5       b           2             NaN

I want to fill the Column C missing data by the same key in Column A and Column B, the output I want is:

index  Column A    Column B       Column C   
  0       a           1             11  
  1       b           1             12
  2       a           1             11
  3       c           2              5
  4       d           3              7
  5       b           2             NaN

How I can get this result? Thanks

edited Dec 10 '18 at 07:23

Khalil Al Hooti

4,207
5
23
40

asked Dec 10 '18 at 07:16

Starry

1

`df.groupby(['Column A', 'Column B'])['Column C'].apply(lambda x: x.ffill().bfill())` – user3483203 Dec 10 '18 at 07:26
Not clear, could you please put more details on this question @Starry – RavinderSingh13 Dec 10 '18 at 07:31
@RavinderSingh13 the first answer works, thank you for your reply – Starry Dec 10 '18 at 07:39
@user3483203, thanks for sharing this code, I am new to pandas could you please explain it a bit, will be grateful to you(I didn't understand question also fully to be honest that is why asked OP for clarifications). – RavinderSingh13 Dec 10 '18 at 07:41

Fill missing data based on the other columns same data

0 Answers0