adding multiple lists into one column DataFrame pandas

Question

l = {'col1': [[1,2,3], [4,5,6]]}

df = pd.DataFrame(data = l)

     col1
0   [1, 2, 3]
1   [4, 5, 6]

Desired output:

you can change the input to continuous list l = {'col1': sum([[1,2,3], [4,5,6]],[])} — Naga kiran
– Naga kiran, Commented Dec 31, 2019 at 4:35

BENY · Accepted Answer · 2019-12-31 04:29:13Z

3

Here is explode

df.explode('col1')
  col1
0    1
0    2
0    3
1    4
1    5
1    6

answered Dec 31, 2019 at 4:29

BENY

324k22 gold badges176 silver badges250 bronze badges

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

2 Comments

mechanical_meat Over a year ago

My first time seeing .explode, nice!

Hung Ho Over a year ago

Nice. Thanks @YO and BEN_W

mechanical_meat · Accepted Answer · 2019-12-31 04:30:14Z

2

You can use np.ravel to flatten the list of lists:

import numpy as np, pandas as pd 

l = {'col1': [[1,2,3], [4,5,6]]}
df = pd.DataFrame(np.ravel(*l.values()),columns=l.keys())

>>> df
   col1
0     1
1     2
2     3
3     4
4     5
5     6

answered Dec 31, 2019 at 4:30

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

3 Comments

mechanical_meat Over a year ago

Thanks, @anky_91. As you can see I prefer using numpy here, too, but understand how some might not want the additional import.

anky Over a year ago

pandas operates on numpy so for that use case pd.np should work pd.DataFrame(pd.np.concatenate(*l.values()),columns=l.keys()) , but i see what you mean :)

Hung Ho Over a year ago

Thank you very much @bernie

Collectives™ on Stack Overflow

adding multiple lists into one column DataFrame pandas

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related