How to create a list of column names, row names, and values from data frame in panda?

Question

I am very new to python. I have a data frame that looks like this:

I want to convert this data frame to a list that looks like this:

  [[E, A, 0], [E, B, 1], [F, A, 2], [F, B, 3]]

Any idea?

Zero · Accepted Answer · 2017-11-07 17:40:15Z

2

Use

In [197]: df.stack().reset_index().values.tolist()
Out[197]: [['E', 'A', 0L], ['E', 'B', 1L], ['F', 'A', 2L], ['F', 'B', 3L]]

answered Nov 7, 2017 at 17:40

Zero

77.4k22 gold badges153 silver badges153 bronze badges

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

1 Comment

You win for 3s :-)

BENY · Accepted Answer · 2017-11-07 17:40:18Z

2

df.reset_index().melt('index').values.tolist()
Out[1423]: [['E', 'A', 0], ['F', 'A', 2], ['E', 'B', 1], ['F', 'B', 3]]

answered Nov 7, 2017 at 17:40

BENY

324k22 gold badges176 silver badges250 bronze badges

@BahadorSaket Go ahead :-)