Pandas Pivot Titanic: Calculate number of women and men were in a particular cabin class

Last update on December 21 2024 07:52:23 (UTC/GMT +8 hours)

Write a Pandas program to create a Pivot table and calculate number of women and men were in a particular cabin class. Go to Editor

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_csv('titanic.csv')
result = df.pivot_table(index=['sex'], columns=['pclass'], aggfunc='count')
print(result)

Sample Output:

       Unnamed: 15       adult_male      ...  survived       who          
pclass           1  2  3          1    2 ...         2    3    1    2    3
sex                                      ...                              
female           0  0  0         94   76 ...        76  144   94   76  144
male             0  0  0        122  108 ...       108  347  122  108  347

[2 rows x 42 columns]            

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 find survival rate by gender, age of the different categories of various classes. Add the fare as a dimension of columns and partition fare column into 2 categories based on the values present in fare columns.
Next: Write a Pandas program to create a Pivot table and find survival of both gender and class affected.