How to convert a list of lists, containing lists, into DataFrame

Question

Hi I have currently been trying to convert a list of lists of lists into a dataframe. Please see the example below:

data = [[[1, 1, 1], [2, 2, 2], [3, 3, 3]],
[[4, 4], [5, 5], [6, 6]],
[[7], [8], [9]]]

and I would like to have a result like this

1        2        3        
1        2        3        
1        2        3        
4        5        6
4        5        6
7        8        9

Could anyone please give me a suggestion or solution? or is there any package being able to handle this problem?

user3483203 · Accepted Answer · 2018-08-24 03:51:45Z

1

Using column_stack:

pd.DataFrame(np.column_stack(data).T)

   0  1  2
0  1  2  3
1  1  2  3
2  1  2  3
3  4  5  6
4  4  5  6
5  7  8  9

answered Aug 24, 2018 at 3:51

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

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

1 Answer 1