1. Group on Column E and return the number of customers by male/female.
Female | Male |
XX | XX |
2. Return the count of passengers.
3. filter on the passengers that survived.
4. Split the Passenger name into First Name and Last Name.
5. Find the total cost for all the fares.
6. Change all the null values in the age column to number 20.
7. Crosstab the Pclass column and count the number of customers by Pclass.
8. Concatenate the Ticket column and the Embarked column.
9. Use the data cleansing tool to change all the names in the Name Column to UpperCase.
10. Change the "S" in the Embarked Column to a "G" using a formula tool.
@boomchakalun
Maybe you can try it first then let us know you have any difficulties in that process? 😁