Question: Q 1 3 : For the castaway _ details DataFrame, there is a full _ name column and a short _ name column. It would
Q: For the castawaydetails DataFrame, there is a fullname column and a shortname column. It would be helpful for future analysis to have the contestants first and last name split into separate columns. First copy the castawaydetails DataFrame to a new DataFrame called Q so that we do not change the original DataFrame.
Create two new columns and add the contestant's first name to a new column called firstname and their last name to a new column called lastname. Add these columns to the Q DataFrame. Put the firstname and lastname columns between the fullname and shortname columns.
Note: Be careful as some players have last names with multiple spaces. For example, Lex van den Berghe. You should code Lex as his first name and van den Berghe as his last name.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
