Python appending a list to dataframe as element

Question

My dataframe is given below

df = 

index    data1
0         20
1         30
2         40

I want to add a new column and each element consiting a list.

My expected output is

df = 

index    data1    list_data
0         20       [200,300,90]
1         30       [200,300,90,78,90]
2         40       [1200,2300,390,89,78]

My present code:

        df['list_data'] = []
        df['list_data'].loc[0] = [200,300,90]

Present output:

    raise ValueError('Length of values does not match length of index')

ValueError: Length of values does not match length of index

Swati Srivastava · Accepted Answer · 2020-01-31 07:41:20Z

2

You can use pd.Series for your problem

import pandas as pd
lis = [[200, 300, 90], [200, 300, 90, 78, 90], [1200, 2300, 390, 89, 78]]
lis = pd.Series(lis)
df['list_data'] = lis

This gives the following output

   index   data1    list_data
0   0        20    [200, 300, 90]
1   1        30    [200, 300, 90, 78, 90]
2   2        40    [1200, 2300, 390, 89, 78]

answered Jan 31, 2020 at 7:41

Swati Srivastava

1,2071 gold badge14 silver badges20 bronze badges

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

Comments

U13-Forward · Accepted Answer · 2020-01-31 03:32:09Z

1

Try using loc this way:

df['list_data'] = ''
df.loc[0, 'list_data'] = [200,300,90]

edited Jan 31, 2020 at 3:32

answered Jan 31, 2020 at 3:30

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

3 Comments

Mainland Over a year ago

df['list_data'] = []' is this wrong? df['list_data'] = ""` is this correct? Because after correcting this, I got the answer.

Mainland Over a year ago

Thanks. I added a new question at stackoverflow.com/questions/59997554/…

U13-Forward Over a year ago

@Mainland Answered

Collectives™ on Stack Overflow

Python appending a list to dataframe as element

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related