pandas how to replace only empty list data?

Question

my dataframe look like this:

   variations_list1          variations_list2
    ["yellow","ornage"]          []
    ["xl","xxl"]                 []
    ["Burger","pizza"]         ["$25","$30"]

expected dataframe:

 variations_list1          variations_list2
    ["yellow","ornage"]         ["yellow","ornage"] #filling emty list with current row data
    ["xl","xxl"]                ["xl","xxl"]
    ["Burger","pizza"]         ["$25","$30"]

BENY · Accepted Answer · 2022-06-02 02:04:09Z

2

You can just do

df.loc[~df['variations_list2'].astype(bool),'variations_list2'] = df['variations_list1']

You have the same issue like before, list is not list

df.loc[df['variations_list2']=='[]','variations_list2'] = df['variations_list1']

edited Jun 2, 2022 at 2:04

answered Jun 2, 2022 at 1:28

BENY

324k22 gold badges176 silver badges250 bronze badges

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

5 Comments

boyenec Over a year ago

it's filling all row of 'variations_list2' but I need to fill only empty list row.["Burger","pizza"] have value ["$25","$30"] so I don't need to replace value of ["$25","$30"]

BENY Over a year ago

@boyenec check update

boyenec Over a year ago

tried but still now same result. it's replacing all value even those are not empty list

BENY Over a year ago

@boyenec it work from my side , you may need to check your column type

boyenec Over a year ago

I checked column type and it's object

Collectives™ on Stack Overflow

pandas how to replace only empty list data?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related