Replace multiple values II
As discussed in the video, instead of using the .replace() function multiple times to replace multiple values, you can use lists to map the elements you want to replace one to one with those you want to replace them with.
As you have seen in our popular names dataset, there are two names for the same ethnicity. We want to standardize the naming of each ethnicity by replacing
'ASIAN AND PACI'to'ASIAN AND PACIFIC ISLANDER''BLACK NON HISP'to'BLACK NON HISPANIC''WHITE NON HISP'to'WHITE NON HISPANIC'
In the DataFrame names, you are going to replace all the values on the left by the values on the right.
Deze oefening maakt deel uit van de cursus
Writing Efficient Code with pandas
Oefeninstructies
- Replace all the ethnicities by their respective alternative, as indicated above.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
start_time = time.time()
# Replace ethnicities as instructed
names['Ethnicity'].replace([____,____, ____], [____,____,____], inplace=True)
print("Time using .replace(): {} sec".format(time.time() - start_time))