replace null values using other records (Python)

Question

I have a dataframe as below:

name    category
----    ----
C58     UP 
D96     DOWN
C58     null

There are lots of null values in category column while they can easily be replaced using other rows for example we know C58 is UP so the null value shoud be UP.

user7864386 · Accepted Answer · 2022-03-31 22:57:18Z

1

IIUC, you want to fill the missing values in category by the values elsewhere in the same column with the same "name". Then you could use groupby + ffill:

df['category'] = df.groupby('name')['category'].ffill()

If each name has exactly one category value, you could also use groupby + transform('first'):

df['category'] = df.groupby('name')['category'].transform('first')

Output:

  name category
0  C58       UP
1  D96     DOWN
2  C58       UP

answered Mar 31, 2022 at 22:57

user7864386

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

replace null values using other records (Python)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related