Hash every element of a list of strings in a pandas Dataframe column

Question

So I have a dataframe like this

   customer     location       trip_len
0     a      ['1', '2', '3']      3
1     b      ['4', '5']           2

And I am trying to hash, for every row, every element on the list of strings on the column 'location' in order to improve efficiency in my model. How would this be possible?

What do you mean by "hash" in this context? It'd help if you could edit to describe what you actually want to achieve please. eg: after this "hash"ing... what would your DF look like or what would you want to be doing with it? Providing more context here would be fabulous - thanks. — Jon Clements
– Jon Clements, Commented Sep 28, 2019 at 16:35
Do you want to categorize your values? Perhaps something like sklearn's ordinal encoder? — Chris
– Chris, Commented Sep 29, 2019 at 2:16

Alex Fish · Accepted Answer · 2019-09-28 16:35:57Z

1

Lists are not natively hashable as those are mutable objects. If only storage is of interest converting to a tuple is an option.

df.location = df.location.apply(lambda locations: hash(tuple(locations)))

answered Sep 28, 2019 at 16:35

Alex Fish

7887 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Hash every element of a list of strings in a pandas Dataframe column

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related