List of unequal lists to dataframe

Question

ch_idx = [[1], [2, 3], [3, 4, 5], [2], [3, 4], [3]]

I want to convert this to a dataframe where, for each list, index 1 becomes the first column, idx 2 the second column, etc. This means, as the lists are unequal, that some columns will need to be filled with NaN.

Desired outcome:

1  NaN  NaN
2   3   NaN
3   4    5
2  NaN  NaN
3   4   NaN
3  NaN  NaN

NB: this does not answer my question

anky · Accepted Answer · 2019-03-30T16:27:48.603

3

You can try with:

ch_idx = [[1], [2, 3], [3, 4, 5], [2], [3, 4], [3]]
df=pd.DataFrame(ch_idx).set_index(0)
print(df)

     1    2
0          
1  NaN  NaN
2  3.0  NaN
3  4.0  5.0
2  NaN  NaN
3  4.0  NaN
3  NaN  NaN

Note : you can remove the .set_index() if you dont want

df=pd.DataFrame(ch_idx)

edited Mar 30 '19 at 16:27

answered Mar 30 '19 at 16:22

anky

74,114
11
41
70

Oh, so simple. Thanks – syntheso Apr 01 '19 at 06:44
1

Indeed! I was trying more complicated things when the answer was right there. : ) – syntheso Apr 01 '19 at 06:51

List of unequal lists to dataframe

1 Answers1