How can i transform this table?

Question

I have a table with 300 rows and 200 columns and i need to transform it. I add an image of the transformation with an example table.

The table above is the original. The one below is the table after the transformation.

I was trying to solve it with excel and Pandas library of Python but i could not solve it. Any ideas?

Try, `df.melt()`. Look at that documentation. – Scott Boston Aug 25 '22 at 18:11 — Scott Boston, Aug 25 '22 at 18:11

score 0 · Accepted Answer · answered Aug 25 '22 at 18:12

0

You can do a melt after reading excel using pandas:

df = pd.read_excel('your_excel_path')
df = pd.melt(df, id_vars='id', value_vars=['variable_1', 'variable_2'])

then write back to excel

df.to_excel('modified_excel.xlsx')

answered Aug 25 '22 at 18:12

SomeDude

1 Answers1