Sort values in a Pandas DataFrame using the python sort function

Question

I have the following dataset where I am trying to sort the row value in each column, but have not been able to find an efficient way of performing the operation. I was hoping someone would be able to point me in a more optimized way of sorting:

Essentially, I am trying to rearrange the list of items in the Column_to_sort alphabetically and separated by a comma.

I wrote the following code to perform the operation, however I don't believe it is the best way of performing the operation:

 def sort_val(x):
    String_ = x.split(",")
    String_.sort()
    return (String_)

df['Desired_Output'] = df['Column_to_Sort'].apply(lambda x: sort_val(x))

ah perfect, for some reason I ran it on my machine twice and it was exceptionally slow. Just tried it again and no issues. I should have waited before posting the question. Sorry about that — Raptor776
– Raptor776, Commented Nov 20, 2019 at 14:59
@Raptor776 you can always delete your question if you choose to. — Quang Hoang
– Quang Hoang, Commented Nov 20, 2019 at 15:07

BENY · Accepted Answer · 2019-11-20 15:01:25Z

2

Solution by use dot and get_dummies

s=df['Column_to_Sort'].str.get_dummies(', ').sort_index(axis=1)
s.dot(s.columns+',').str[:-1]
Out[547]: 
0       a,c,x,z
1    apple,ball
dtype: object

answered Nov 20, 2019 at 15:01

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Sort values in a Pandas DataFrame using the python sort function

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