Question: I nned help with this R Studio work Here is the .csv file on google drive https://drive.google.com/open?id=1mm7A0C7lNkjHPd6sDgA4wKS4KUnbj7tO 1. Name column consists of three elements: LastName,

I nned help with this R Studio work

Here is the .csv file on google drive https://drive.google.com/open?id=1mm7A0C7lNkjHPd6sDgA4wKS4KUnbj7tO

1.

Name column consists of three elements: LastName, Title and Name. For example, in the first observation (Allen, Miss. Elisabeth Walton) Allen is the last name, Miss is the title of the passenger and Elisabeth Walton is the name (some passengers has more than 2 names) of the passenger. Separate the Name column into two columns, namely Title and Name_Last, which will include passenger titles, and full names of the passengers, respectively. Assign it to titanic1. Show the first 2 rows of titanic1. 2.

Check for Sex column, correct the typos and replace male with M, and female with F in Sex variable. Assign it to titanic2. 3.

Check for the Passenger.Class column. How many distinct values does it have? Correct the typo, replace 33 with 3. Assign it to titanic3. 4.

HomeDestination column includes home and destination of the passengers which is separated by a forward slash (/). Separate this variable into two columns, namely Home and Destination. Assign it to titanic4. 5.

Check for missing values and make sure that Body and Distance have many missing values. In addition, there are some redundant/unused columns such as Ticket.., "Cabin", Title and "Midpoint.age" columns. So, delete all these columns from the dataset. Assign it to titanic5. Show the first 2 rows of titanic5.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!