DataFrame to list of lists

Question

I have a DataFrame df with several columns, including expiry and iv. I would like to create a lol = list-of-list [[]] so that each row in the lol corresponds to a given expiry. For example, say df look like this:

df =


expiry             iv
===========================
2019-01-18,        .18
2019-01-18,        .17
2019-01-18,        .16
2019-02-18,        .14
2019-02-18,        .13
2019-02-18,        .12

the lol would look like this:

lol = [
[0.18, 0.17, 0.16],
[0.14, 0.13, 0.12]]

So each row of the lol would correspond to the corresponding date in the df.

BENY · Accepted Answer · 2020-01-08 19:44:53Z

2

IIUC

LoL=df.groupby('expiry').iv.agg(list).tolist()
LoL
[[0.18, 0.17, 0.16], [0.14, 0.13, 0.12]]

answered Jan 8, 2020 at 19:44

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

DataFrame to list of lists

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related