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 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

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?