TypeError: unhashable type: 'list' pandas python

Question

df is the database with weather as column

 Weather
 Rain, freezing cold
 Rain, and thunder
 Thunderstorm, and dust
 Drizzle, for half an hour
 Drizzle, for sometime
 Rain, non stop
 Slight rain

Code

heavy_rain_indicator = ['Rain,','Thunderstorm,',]
light_rain_indicator = ['Drizzle,','Slight rain']

df['Heavy Rain Indicator'] = (df['Weather'].str.contains(heavy_rain_indicator))
df['Light Rain Indicator'] = (df['Weather'].str.contains(light_rain_indicator))

Expected output:

 Weather                  Heavy Rain Indicator    Light Rain Indicator
 Rain, freezing cold         TRUE                      FALSE
 Rain, and thunder           TRUE                      FALSE
 Thunderstorm, and dust       TRUE                      FALSE
 Drizzle, for half an hour   FALSE                     TRUE
 Drizzle, for sometime       FALSE                     TRUE
 Rain, non stop              TRUE                      FALSE
 Slight rain                 FALSE                     TRUE

Actual output

 TypeError: unhashable type: 'list'
 ----> 4     df['Heavy Rain Indicator'] = (df['Weather'].str.contains(heavy_rain_indicator))

I want the columns Heavy rain indicator to be TRUE when heavy rain indicators are present and light rain indicator to be TRUE when light rain indicators are present

Someone suggested to use isin (and then deleted the post) but I cannot type the exact expression, so for heavy rain indicator for eg I want all values beginning with Rain, to be in heavy indicator column and so on. Pls answer accordingly

stackoverflow.com/q/19371358/11301900, stackoverflow.com/q/13675296/11301900 — AMC
– AMC, Commented Jan 25, 2020 at 22:14
Does this answer your question? Python, TypeError: unhashable type: 'list' — AMC
– AMC, Commented Jan 25, 2020 at 22:15

riffle_shuffle · Accepted Answer · 2020-01-25 15:21:59Z

2

Comments

Sociopath · Accepted Answer · 2020-01-25 15:09:46Z

2

str.contains takes argument as string but you are passing the list

You can use list comprehension with any like below:

df['Heavy Rain Indicator'] = [any(i.lower() in j.lower() for i in heavy_rain_indicator) for j in df["Weather"].values]

df['Light Rain Indicator'] = [any(i.lower() in j.lower() for i in light_rain_indicator) for j in df["Weather"].values]

answered Jan 25, 2020 at 15:09

Sociopath

13.4k22 gold badges53 silver badges82 bronze badges

1 Comment

AMC Over a year ago

Why are you using .values? It shouldn't be a huge issue here, but the correct way of performing a case-insensitive comparison is using str.casefold().

yganalyst · Accepted Answer · 2020-01-25 15:11:56Z

2

you can try this:

def get_TF(x, info_list):
    return any([True for i in info_list if i in x])
heavy_rain_indicator = ['Rain,','Thunderstorm,']
light_rain_indicator = ['Drizzle,','Slight rain']

df['Heavy Rain Indicator'] = df['Weather'].apply(lambda x : get_TF(x, heavy_rain_indicator))
df['Light Rain Indicator'] = df['Weather'].apply(lambda x : get_TF(x, light_rain_indicator))
df


                     Weather  Heavy Rain Indicator  Light Rain Indicator
0        Rain, freezing cold                  True                 False
1          Rain, and thunder                  True                 False
2     Thunderstorm, and dust                  True                 False
3  Drizzle, for half an hour                 False                  True
4      Drizzle, for sometime                 False                  True
5             Rain, non stop                  True                 False
6                Slight rain                 False                  True

answered Jan 25, 2020 at 15:11

yganalyst

4942 silver badges7 bronze badges

1 Comment

AMC Over a year ago

You really don't need .apply(), an entire function, and a lambda for this. Why use any([True for i in info_list if i in x]) instead of just any(i in x for i in info_list) ?

Collectives™ on Stack Overflow

TypeError: unhashable type: 'list' pandas python

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related