TypeError: unhashable type: 'list' dataframe list map

Question

I am trying to map data using a list instead of a string

If the number is inside the list, then map it to xyz

Any way I can do this using a list?

import pandas as pd

df = pd.DataFrame({'INDICATOR': ['0001024561', 'B', '0001024561', 'D'], 'VALUE': [10, 9, 8, 7]})

company_dict = {[
    '0001024561',
    '0001024576',
    ]: 'xyz'}

df['NEW_VALUE'] = df['INDICATOR'].map(company_dict)

print(df)

Error:

TypeError: unhashable type: 'list'

wwnde · Accepted Answer · 2020-05-08 21:17:57Z

1

IICU:

Use dict

company_dict = {'0001024561':'xyz','0001024576':'xyz'}
df['NEW_VALUE'] = df['INDICATOR'].map(company_dict)

Using list

lst=['0001024561','0001024576']
df.loc[df['INDICATOR'].isin(lst),'NEW_VALUE']='xyz'

answered May 8, 2020 at 21:17

wwnde

26.7k6 gold badges22 silver badges38 bronze badges

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

1 Comment

wwnde Over a year ago

Thanks for accepting answer, could you please press the up arrow so that people seeking answers can confidently use solution?

Collectives™ on Stack Overflow

TypeError: unhashable type: 'list' dataframe list map

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related