Sorting the lists in dataframe column

Question

I want to know to sort each list of a data frame column(pandas). For example:

id       values
------------------------
 1      ['cdf','abc','efg']
 2      ['xyz' ,'rsy','abc']

Expected :

 id       values
------------------------
 1      ['abc','cdf','efg']
 2      ['abc' ,'rsy','xyz']

Thanks: I would also like to know the same if comma seperated strings are present instead of list.

user3483203 · Accepted Answer · 2018-07-13 04:10:11Z

9

Simply using apply with sorted

df['values'].apply(sorted)

0    [abc, cdf, efg]
1    [abc, rsy, xyz]
Name: values, dtype: object

For comma separated values, thanks @AChampion:

df = pd.DataFrame({'id': [1,2], 'values': ['cdf, abc, efg', 'xyz, rsy, abc']})
df['values'].apply(lambda x: ','.join(sorted(x.split(','))))

0     abc, efg,cdf
1     abc, rsy,xyz
Name: values, dtype: object

You can also use a list comprehension to increase performance:

df['values'] = [','.join(sorted(i.split(','))) for i in df['values']]

edited Jul 13, 2018 at 4:10

answered Jul 13, 2018 at 3:59

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

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

1 Comment

AChampion Over a year ago

And df['values'].apply(lambda x: ','.join(sorted(x.split(',')))) for comma separated strings.

Collectives™ on Stack Overflow

Sorting the lists in dataframe column

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