order values in alphabetical order in pandas dataframe

Question

I have a column in a pandas dataframe called feature. I want to order the values of "feature" in an alphabetical order. For example, in the below table, how can I get all the values under age in the order age, color, gender?

ID  Feature
1001    color,age,gender
1002    age,gender,color
1003    age,color,gender
1004    color,age,gender
1005    age,color,gender
1006    color,age,gender
1007    age,color,gender

MaxU - stand with Ukraine · Accepted Answer · 2016-07-14 11:50:42Z

3

Here is one way, but, honestly, i don't like it:

In [24]: df.Feature = df.Feature.str.split(',', expand=True).apply(lambda x: pd.Series(np.sort(x)).str.cat(sep=','), axis=1)

In [25]: df
Out[25]:
     ID           Feature
0  1001  age,color,gender
1  1002  age,color,gender
2  1003  age,color,gender
3  1004  age,color,gender
4  1005  age,color,gender
5  1006  age,color,gender
6  1007  age,color,gender

answered Jul 14, 2016 at 11:50

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

order values in alphabetical order in pandas dataframe

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