Sort values in python

Question

I am using python (jupyter notebook) for some analysis. I would like to sort my values in my panda data frame by the function sort_values(). First it looked like it was working correctly, however it is only working for sorting digits with 2 characters (see figure). What could I do to sort the values correctly for countries > 99?

Please do not add code as images, add them as text and mark them as code (by selecting the whole code and pressing Ctrl+K or the {} button in the toolbar). Otherwise answerers need to manually type any code they need from you, instead of being able to copy & paste. — Graipher
– Graipher, Commented Feb 28, 2018 at 14:49

jezrael · Accepted Answer · 2018-02-28 14:37:19Z

2

There is problem values are strings, so lexicographically sorting.

So need first convert to numeric:

df4 = df4.astype(int)

Sample:

df4 = pd.Series(['102','11','10','10', '119', '14'])
print (df4)
0    102
1     11
2     10
3     10
4    119
5     14
dtype: object

print (df4.sort_values())
2     10
3     10
0    102
1     11
4    119
5     14
dtype: object

df4 = df4.astype(int)
print (df4.sort_values())
2     10
3     10
1     11
5     14
0    102
4    119
dtype: int32

answered Feb 28, 2018 at 14:37

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Sort values in python

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