IMPORTANT REQUIREMENTS:
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:
function 1:
calculates the number of letters or characters (exclude whitespace) and then adds that as a separate column called “Name Length”
function 2
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)
QUESTION 2
write 2 functions and clearly comments on them
function 1:
Calculate the summary statistics for the “Name Length” column.
function 2:
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)