Geek Answers Handbook

Alphabetical order values ​​in pandas dataframe

I have a column in the pandas function associated with a DataFrame. I want to order the "feature" values ​​in alphabetical order. For example, in the table below, how can I get all the values ​​under age in order of 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
+4
source share
1 answer

Here is one way, but to be honest, I don't like this:

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
+3
source

More articles:


All Articles