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.
2 Answers
is this what you are looking for?
df.groupby(['Cabin_letter'],as_index=False).sum().reset_index()
df['died'] = df['Survived'] - df['No.passangers']
Check if it helps:
df =pd.pivot_table(df, index=["Cabin_letter"], columns=["Survived"], values=["No. Passengers"])
df.columns = ["dead", "Survived"]
df.reset_index()
Related