the data set: https://github.com/pcsanwald/kaggle-titanic/blob/master/train.csv

1. Show all female passengers on the titanic_test dataset.

2. Show all passengers age 60 and above in titanic_test dataset.
3. Show all first-class passengers of the titanic_test dataset.

Data Pre-Processing

6. What is the average age of female passengers in both titanic_train and titanic_test dataset?
7. Count the number of empty values of Age variable in the titanic_test dataset.
8. Compute the median age for both male and female in the titanic_test dataset.
9. What is the total number of male and female that have survived in both titanic_train

and titanic_test datasets.

10. What is the percentage of male and female that have survived in both titanic_train and

titanic_test datasets.

11. Replace the missing values of age variable of male passengers by the median age of

all male passengers in the titanic_test dataset.

12. Replace the missing values of age variable of female passengers by the median age of all female passengers in the titanic_test dataset.