Please use the titanic data from "https://raw.githubusercontent.com/Geoyi/Cleaning-Titanic-Data/master/titanic_clean.csv (Links to an external site.)Links to an external site." for the assignment

1. How many missing values are there in each column

2. Change the name of the last column from 'has_cabin_number' to 'cabin_number'

3. The column 'name' has the last name and the first name separated by a comma. Replace the column 'name' with 2 columns 'last_name' and 'first_name'. The exact method for doing this has not been taught in class. Feel free to use google and stackoverflow to figure out a way.

4. How many of each last name have survived? for example only 1 person with the last name 'allison' has survived even though there were 4 people with that last name on board the ship. We want a table that gives the last name and the number of survivors.