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'
This exercise is part of the course
Writing Efficient Code with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample 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))