How to transforrm a dataframe into 3 big rows

Asked Feb 18 '21 at 06:13

Active Feb 18 '21 at 06:19

Viewed 11 times

How could I transform the following dataframe

Subject A1 A2 A3

S001 24.0 25.0 25.0

S002 12.0 14.0 5.0

S003 10.0 12.0 3.0
...

into the following:

pax score facet

S001 24.0 A1

S002 12.0 A1

S003 10.0 A1

...

S001 25.0 A3

S002 5.0 A3

S003 3.0 A3

df=df.T is not working should I write a for loop? Thank you for you help.

edited Feb 18 '21 at 06:19

asked Feb 18 '21 at 06:13

Frédéric Ooms

Use `df = df.melt('Subject', var_name='facet', value_name='score')` – jezrael Feb 18 '21 at 06:19
yes this was the index – Frédéric Ooms Feb 18 '21 at 06:20
If need remove `O` columns `df.filter(regex='Subject|A').melt('Subject', var_name='facet', value_name='score')` – jezrael Feb 18 '21 at 06:21

0 Answers0