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!
Instructions
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 print and .head().
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 leather and animal otherwise.
Our marketing department wants to send out an email to each customer. Using the columns last_name and 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:
| last_name | gender | salutation |
|---|---|---|
| Smith | Male | Dear Mr. Smith |
| Jones | Female | Dear Ms. Jones |