In Python, how can I create a dataframe from a list of lists?

Question

I am trying to take a list of lists and transform it into a dataframe such that the dataframe has only one column and each sublist takes one row in the dataframe. Below is an image of what I have attempted, but each word within each sublist is being put in different columns.

Current dataframe

Essentially, I want a table that looks like this: How I want the dataframe to look

It would make it easier for people to answer if you could replicate a minimal example of what your problem is in the question. — Robert King
– Robert King, Commented May 7, 2020 at 10:32

Paddy Harrison · Accepted Answer · 2020-05-07 10:38:32Z

1

How about something like this, using list comprehension:

import pandas as pd

data = [[1,2,3], [4,5,6]]

# list comp. loops over each list in data (i)
# then appends every element j in i to a string
# end result is one string per row
pd.DataFrame([' '.join(str(j) for j in i) for i in data], columns=['Review'])
>>>   Review
    0  1 2 3
    1  4 5 6

edited May 7, 2020 at 10:38

answered May 7, 2020 at 10:31

Paddy Harrison

2,0421 gold badge11 silver badges26 bronze badges

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

Comments

CKM · Accepted Answer · 2020-05-07 10:33:38Z

0

Here you go.

import pandas as pd
data=[['a b'],['c d']] # assuming each sublist has reviews 

data=[ i[0] for i in data] # make one list 

df = pd.DataFrame({'review':data})
print(df)

Output:

 review
0    a b
1    c d

answered May 7, 2020 at 10:33

CKM

2,0012 gold badges25 silver badges33 bronze badges

Collectives™ on Stack Overflow

In Python, how can I create a dataframe from a list of lists?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related