Python Convert a list into a dataframe

Question

I have a list that consists of lists. Looks something like this:

[[1,2,3,4,5],['john','leo','steve','ben','sally'],['22','55','66','11','33'],['blue','green','red','yellow','pink']]

I want to convert this into a dataframe that looks like this:

      1     2     3      4     5
0  john   leo steve    ben sally
1    22    55    66     11    33
2  blue green   red yellow  pink

Any suggestions?

I tried to play around with the reshape function, but I can't get it to work.

I also tried looking at ValueError: Shape of passed values is (1, 6), indices imply (6, 6) but that didn't help either.

`pd.DataFrame(x[1:], columns=x[0])` if x is the list - or do Dani's solution...same concept — Derek Eden, Jan 06 '21 at 21:11

score 2 · Answer 1 · answered Jan 06 '21 at 21:12

You could do:

import pandas as pd


columns, *data = [[1,2,3,4,5],['john','leo','steve','ben','sally'],['22','55','66','11','33'],
                  ['blue','green','red','yellow','pink']]
df = pd.DataFrame(data=data, columns=columns)
print(df)

Output

      1      2      3       4      5
0  john    leo  steve     ben  sally
1    22     55     66      11     33
2  blue  green    red  yellow   pink

score 2 · Accepted Answer · answered Jan 06 '21 at 21:13

2

How about:

pd.DataFrame(data[1:], columns=data[0])

Output:

      1      2      3       4      5
0  john    leo  steve     ben  sally
1    22     55     66      11     33
2  blue  green    red  yellow   pink

answered Jan 06 '21 at 21:13

Quang Hoang

146,074
10
56
74

This is perfect – Chicken Sandwich No Pickles Jan 06 '21 at 21:18

Python Convert a list into a dataframe

2 Answers2