Pandas replace values using dictionary with a list of values

Question

I have the following dictionary and Series.

product_type_dic = {'Facial Care':['Facial_cleanser', 'Beard_oil'], 'Eye Care':['Around-eye_cream', 'Eyeliner']}

s = pd.Series(['Facial_cleanser', 'Beard_oil', 'Around-eye_cream', 'Eyeliner'])

My goal is to get the key values of the dictionary using the Series. So the result will be

'Facial Care'
'Facial Care'
'Eye Care'
'Eye Care'

Thank you

Andrej Kesely · Accepted Answer · 2021-07-13 22:50:04Z

1

Use Series.map with inversed product_type_dic dictionary:

product_type_dic = {
    "Facial Care": ["Facial_cleanser", "Beard_oil"],
    "Eye Care": ["Around-eye_cream", "Eyeliner"],
}


inv_product_type_dic = {vv: k for k, v in product_type_dic.items() for vv in v}
s = pd.Series(["Facial_cleanser", "Beard_oil", "Around-eye_cream", "Eyeliner"])

print(s.map(inv_product_type_dic))

Prints:

0    Facial Care
1    Facial Care
2       Eye Care
3       Eye Care
dtype: object

answered Jul 13, 2021 at 22:50

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas replace values using dictionary with a list of values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related