Change dataframe values automatically

Question

I have a table.

Row_count EXP1 EXP2
2544       24   22

I want it like this:

Row_count EXP TOTAL_I.V
2544      EXP1   24
2544      EXP2   22

use melt https://stackoverflow.com/questions/28654047/pandas-convert-some-columns-into-rows — Serge, Apr 25 '19 at 21:15

score 1 · Accepted Answer · answered Apr 25 '19 at 21:17

1

df2 = pd.melt(df, id_vars=["Row_count"], 
              var_name="Exp", value_name="TOTAL_I.V")

answered Apr 25 '19 at 21:17

Serge

1 Answers1