I need to pivot a pandas dataframe
ID | A1 | A2 | B1 | B2 | C1 | C2 |
---|---|---|---|---|---|---|
1 | 100 | 102 | 99 | 103 | 100 | 100 |
2 | 90 | 92 | 89 | 93 | 90 | 90 |
3 | 120 | 122 | 119 | 123 | 120 | 120 |
into the following form
ID | label_1 | label_2 |
---|---|---|
1 | A1 | 100 |
1 | A2 | 102 |
1 | B1 | 99 |
1 | B2 | 103 |
1 | C1 | 100 |
1 | C2 | 100 |
2 | A1 | 90 |
2 | A2 | 92 |
2 | B1 | 89 |
2 | B2 | 93 |
2 | C1 | 90 |
2 | C2 | 90 |
3 | A1 | 120 |
3 | A2 | 122 |
3 | B1 | 119 |
3 | B2 | 123 |
3 | C1 | 120 |
3 | C2 | 120 |
I tried different combinations of resetting the index, transposing and pivoting without any success.