Creating list of list using Python

Question

Having a data frame as below:need to convert to list of list as below:

Need to create a matrix whose logic is like this:

The output needs to be a list of list of format as below:

[[0,24,20],[12,0,24],[30,24,0]]

I tried the below code:

df.groupby(['product1','product2'])['time'].apply(list)

OK, and what have you tried? This is not terrible complicated. — Tim Roberts
– Tim Roberts, Commented Aug 15, 2022 at 5:34
Can you send this data ? I can give a better answer with it... Though it's not that hard — Ayush Sehrawat
– Ayush Sehrawat, Commented Aug 15, 2022 at 5:36

Prgmaz · Accepted Answer · 2022-08-15 06:02:39Z

3

From the looks of this, this is known as a pivot table. You can create it by using pandas.pivot_table method.

To create the above matrix, you need to write this code.

pt = data.pivot_table(index="product1", columns="product2", values="time")

To get this in list of list form. Store this in a variable and use this.

pt.values.tolist()

answered Aug 15, 2022 at 5:52

Prgmaz

465 bronze badges

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

2 Comments

I need it in as list of list

I have updated the answer, sorry for trouble