How to add a list of lists as one row to dataframe, with each list in one cell? - Python

Question

I have a lists of lists, that I want to convert to one row in a DataFrame. Each list should come in a cell in the DataFrame. When completed, I want to add the next list of lists in the same way.

This is what I do:

import pandas as pd
lst1 = [['a', 'b', 'c'], ['d', 'e', 'f'], ['g', 'h', 'i']]    
lst2 = [['j', 'k', 'l'], ['m', 'n', 'o'], ['p', 'q', 'r']]    
DataFrame = []
df = pd.DataFrame(lst1)
df = pd.DataFrame(lst2)

Resulting in:

          0     1    2
0         j     k    l
1         m     n    o
2         p     q    r

But what I would like is this:

         0                1                2
0        ['a', 'b', 'c']  ['d', 'e', 'f']  ['g', 'h', 'i']
1        ['j', 'k', 'l']  ['m', 'n', 'o']  ['p', 'q', 'r']

Is there a simpler and elegant way to do this?

BENY · Accepted Answer · 2018-03-19 16:24:33Z

1

So is this what you need ?

pd.DataFrame([lst1,lst2])
Out[500]: 
           0          1          2
0  [a, b, c]  [d, e, f]  [g, h, i]
1  [j, k, l]  [m, n, o]  [p, q, r]

answered Mar 19, 2018 at 16:24

BENY

324k22 gold badges176 silver badges250 bronze badges

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

9 Comments

twhale Over a year ago

Yes, that is what I would like.

Vaishali Over a year ago

Man, you are too fast!

BENY Over a year ago

@Vaishali haha , just time to break , so looking around the site . :-)

twhale Over a year ago

Can lst1, lst2 etc, also be added in a loop? So that it becomes possible to do the same for 100k lists of lists?

jpp Over a year ago

@twhale, this is a different question. But my advice is combine first into a list of lists, then combine into one dataframe at the end. Appending to a list is much cheaper than appending to a dataframe.

|

Collectives™ on Stack Overflow

How to add a list of lists as one row to dataframe, with each list in one cell? - Python

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related