Please help transposing this df. Can’t think of better way doing it:
df: Yellow marked are column names
outcome I’m looking for:
Advertisement
Answer
try via T
attribute,rename_axis()
,reset_index()
and melt()
method:
JavaScript
x
5
1
out=(df.T
2
.rename_axis(index=['Group','Weeks'])
3
.reset_index()
4
.melt(['Group','Weeks'],var_name='Days',value_name='Amount'))
5
OR
via T
attribute,rename_axis()
,stack()
,reset_index()
and rename()
method:
JavaScript
1
6
1
out=(df.T
2
.rename_axis(index=['Group','Weeks'])
3
.stack()
4
.reset_index()
5
.rename(columns={'level_2':'Days',0:'Amount'}))
6