convert list of list to dataframe in python

Question

list = [[1,1,56],
        [20,2,78],
        [30,3,34],
        [40,4,98]]

this is my list of list and i want to make a dataframe like this-;

i did a code

df = pd.DataFrame(list) df = df.transpose() df.columns = ["a", "b", "c"]

it gives me a error like Length mismatch: Expected axis has 4 elements, new values have 3 elements

please help me thanks in advance

Remove the transpose. df = pd.DataFrame(list) gives you a df of dimensions (4 rows, 3 cols). Transpose changes it to (3 rows, 4 cols) and then you will have to 4 col names instead of three. — Ic3fr0g
– Ic3fr0g, Commented Feb 6, 2019 at 7:31

jezrael · Accepted Answer · 2019-02-06 07:32:19Z

3

First dont use list because reserved code word in python and then only pass columns parameter, transpose is not necessary:

L = [[1,1,56],
      [20,2,78],
      [30,3,34],
      [40,4,98]]

df = pd.DataFrame(L, columns=["a", "b", "c"])
print (df)
    a  b   c
0   1  1  56
1  20  2  78
2  30  3  34
3  40  4  98

answered Feb 6, 2019 at 7:32

jezrael

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

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

3 Comments

user10963388 Over a year ago

and if i want to convert that (dataframe into list of list) , how can we do that?

jezrael Over a year ago

Use L = df.values.tolist()

user10963388 Over a year ago

amazing bro, take a HUG from my-side<3

Collectives™ on Stack Overflow

convert list of list to dataframe in python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related