1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Efficient Code with pandas

Exercise

Replace multiple values I

In this exercise, you will apply the .replace() function for the task of replacing multiple values with one or more values. You will again use the names dataset which contains, among others, the most popular names in the US by year, gender and Ethnicity.

Thus you want to replace all ethnicities classified as black or white non-hispanics to non-hispanic. Remember, the ethnicities are stated in the dataset as follows: ['BLACK NON HISP', 'BLACK NON HISPANIC', 'WHITE NON HISP' , 'WHITE NON HISPANIC'] and should be replaced to 'NON HISPANIC'

Instructions 1/2

undefined XP
  • 1
    • Replace all the ethnicities that are not Hispanic in the dataset to 'NON HISPANIC' using the.loc()` indexer.
  • 2
    • Replace all the ethnicities that are not Hispanic in the dataset to 'NON HISPANIC' using the .replace() function.