1. Assuming we want to run analysis using variables: Survived, Pclass, Sex, Age, Fare, Embarked, and want to prepare a dataset for the analysis. Please do the items below:
2. Create a subset of data which only contains selected variables. This should be a new Python variable only containing selected columns.
3. For each variable, please check whether it has any missing values. If yes, how many missing values are there. If you see missing values on variables Survived, Pclass, Sex, Embarked, please removing the missing records.
4. For missing values on variables Age, Fare, please replace the missing value using average age and average fare.
5. If you identify any categorical variable(s), please use one-hot encoding to convert the variables.
6. At the end, please print the final dataset, which only contains selected variable and is well cleaned. Please indicate the number of observations in the dataset.