CommencerCommencer gratuitement

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'

Cet exercice fait partie du cours

Writing Efficient Code with pandas

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

start_time = time.time()

# Replace all non-Hispanic ethnicities with 'NON HISPANIC'
names['Ethnicity'].____[(names["Ethnicity"] == ____) | 
                      (____["Ethnicity"] == ____) | 
                      (____[____] == ____) | 
                      (____[____] == ____)] = ____

print("Time using .loc[]: sec".format(time.time() - start_time))
Modifier et exécuter le code