Great job! In this lesson, you learned how to modify an existing DataFrame. Some of the skills you’ve learned include:
- Adding columns to a DataFrame
- Using lambda functions to calculate complex quantities
- Renaming columns
Let’s practice what you just learned!
Once more, you’ll be the data analyst for ShoeFly.com, a fictional online shoe store.
More messy order data has been loaded into the variable
orders. Examine the first 5 rows of the data using
Many of our customers want to buy vegan shoes (shoes made from materials that do not come from animals). Add a new column called
shoe_source, which is
vegan if the materials is not
Our marketing department wants to send out an email to each customer. Using the columns
gender create a column called
salutation which contains
Dear Mr. <last_name> for men and
Dear Ms. <last_name> for women.
Here are some examples:
|Smith||Male||Dear Mr. Smith|
|Jones||Female||Dear Ms. Jones|