How to reshape a DataFrame

Question

This is my dataFrame and I want it to look like this:

I think I should use pd.melt() but I am not very sure how.

score 1 · Answer 1 · answered Sep 22 '20 at 11:43

1

is this what you are looking for?

df.groupby(['Cabin_letter'],as_index=False).sum().reset_index()
df['died'] = df['Survived'] - df['No.passangers']

answered Sep 22 '20 at 11:43

adir abargil

score 1 · Accepted Answer · edited Sep 22 '20 at 11:59

1

Check if it helps:

df =pd.pivot_table(df, index=["Cabin_letter"], columns=["Survived"], values=["No. Passengers"])
df.columns = ["dead", "Survived"]
df.reset_index()

edited Sep 22 '20 at 11:59

Pygirl

answered Sep 22 '20 at 11:57

Subasri sridhar

Thank you, this is the solution I searched for. – Andreea Elena Sep 22 '20 at 12:03

2 Answers2