Pandas Pivot Titanic: Create a Pivot table and find survival of both gender and class affected

Pandas: Pivot Titanic Exercise-12 with Solution

Write a Pandas program to create a Pivot table and find survival of both gender and class affected. Go to Editor

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_csv('titanic.csv')
result = df.groupby(['sex', 'class'])['survived'].aggregate('mean').unstack()
print(result)

Sample Output:

class      First    Second     Third
sex                                 
female  0.968085  0.921053  0.500000
male    0.368852  0.157407  0.135447            

Python Code Editor:

Pivot Titanic.csv:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to create a Pivot table and calculate number of women and men were in a particular cabin class.
Next: Write a Pandas program to create a Pivot table and compute survival totals of all classes along each group.