Python Numpy Sort rows

Question

Very new to Python so please bear with me here. I am trying to sort an array that I have imported into python with numpy.sort:

 guy = numpy.sort(sasBody, axis=-0)

The first column is a column of strings, so I would like to alphabetically sort the array. The problem I am having is that it does sort the first column, however all the numbers associated with the prior rows are now not connected to its correct first column counterpart.

What am I doing wrong?

Very new to python, found it on the web and am copy pasting. I don't really know what the axis bit does anyway... — Lererferler, May 29 '15 at 12:09

score 3 · Accepted Answer · answered May 29 '15 at 12:07

3

You need to use np.lexsort though in case of strings that may not work. As a work around, you may use np.argsort

>>> a
array([['xyz', 0],
       ['abc', 5],
       ['ijk', 10]], dtype=object)
>>> i = np.argsort(a[:,0])
>>> a[i]
array([['abc', 5],
       ['ijk', 10],
       ['xyz', 0]], dtype=object)

answered May 29 '15 at 12:07

behzad.nouri

74,723
18
126
124

perfect thank you so much! – Lererferler May 29 '15 at 12:08

score 1 · Answer 2 · answered May 29 '15 at 12:07

1

Sorry a little bit more digging found me the answer guy = sasBody[np.argsort(sasBody[:, 0])]

answered May 29 '15 at 12:07

Lererferler

287
4
19

Python Numpy Sort rows

2 Answers2

Linked

Related