Replace a list value with another array in pandas

Question

I am tring to replace a list value with another list value in a pandas but it raises an error : cannot set using a multi-index selection indexer with a different length than the value. Is it wrong practice to work with list values in pandas? Thank you

import pandas as pd

cars = {'Brand': ['Honda Civic','Toyota Corolla','Ford Focus','Audi A4'],
        'Price': [[123, 123123],[123, 123123],[123, 123123],[123, 123123]]
        }
df = pd.DataFrame(cars, columns = ['Brand', 'Price'])
df[1, 'Price'] = [2342, 23423]

print(df)

jezrael · Accepted Answer · 2020-09-25 09:22:43Z

1

Use DataFrame.loc:

df.loc[1, 'Price'] = [2342, 23423]

print(df)
0     Honda Civic  [123, 123123]
1  Toyota Corolla  [2342, 23423]
2      Ford Focus  [123, 123123]
3         Audi A4  [123, 123123]

Is it wrong practice to work with list values in pandas?

I think working with lists in pandas is not good idea, if possible create 2 columns here.

answered Sep 25, 2020 at 9:22

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

SunilG · Accepted Answer · 2020-09-25 10:28:51Z

0

You better create two columns of out your Price column like this. But if you still have a good reason to have a list in the Price column and want to update it, use below code:

df.iloc[1, 1] = [2342, 23423]

This is integer-location based indexing for selection. 'Price' is in the index=1 position column wise.So, the 2nd 1 refers to 'Price' column and the 1st 1 refers to the actual row index.

answered Sep 25, 2020 at 10:28

SunilG

3451 gold badge4 silver badges10 bronze badges

Collectives™ on Stack Overflow

Replace a list value with another array in pandas

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related