Create a list including row name, column name and the value from dataframe [duplicate]

Question

I have the following dataframe:

    A   B   C  
A   1   3   0    
B   3   2   5     
C   0   5   4   

All I want is shown below:

my_list = [('A','A',1),('A','B',3),('A','C',0),('B','B',2),('B','C',5),('C','C',4)]

Thanks in advance!

Answer 1

IIUC, you can do:

df.stack().reset_index().agg(tuple,1).tolist()

---

[('A', 'A', 1),
 ('A', 'B', 3),
 ('A', 'C', 0),
 ('B', 'A', 3),
 ('B', 'B', 2),
 ('B', 'C', 5),
 ('C', 'A', 0),
 ('C', 'B', 5),
 ('C', 'C', 4)]

Answer 2

You can stack and use to_records to obtain a record array from the result:

df.stack().to_frame().to_records().tolist()
# [('A', 'A', 1), ('A', 'B', 3), ('A', 'C', 0), ('B', 'A', 3),...