Deliver File Type: ipynb.
Need to work with: CSV file (,unzip the attachment open with MacBook)
QUESTION 1 (work with Name column in CSV file):
In THIS titanic dataset, please write two functions and clearly comment on them:
calculates the number of letters or characters (exclude whitespace) and then adds that as a separate column called “Name Length”
calculates the number of letters or characters (exclude special symbols like: “ ”， ’ ‘， （ ）， -, . ) and then adds that as a separate column called “Name Length 2”
(4 points for the whitespace excluded calculation, 4 points for adding the separate column with this new data and 2 points for good clear comments = 10 points)
write 2 functions and clearly comments on them
Calculate the summary statistics for the “Name Length” column.
What is the length of the longest and the shortest names print out that name;
(4 points for summary statistics, 4 points for the rest, and 2 points for clear comments = 10 points)