Sorting pandas dataframe according to first column

Question

I'm trying to sort this dataframe based on the 'ID Name'. How do I get the 'ID Name' values in alphabetical order (while keeping the values' corresponding time stamps and comments)?

          ID Name             Time Stamp         Comments
0          W10D12    2015-01-24 16:40:34     RandComment1 
1           W8D13    2015-01-25 11:51:21     RandComment1   
2           W8D15    2015-01-25 11:51:41     RandComment1  
3           W8D22    2015-01-25 11:51:47     RandComment2 
4           W8D23    2015-01-25 11:51:54     RandComment2
5           W8D25    2015-01-25 11:51:59     RandComment2
6           W2D27    2015-01-25 11:52:03     RandComment2
7          W16D12    2015-01-24 16:41:45     RandComment3
8          W10D13    2015-01-25 11:53:06     RandComment4
9           W8D15    2015-01-25 11:53:27     RandComment4
..            ...                    ...              ...

Incognos · Accepted Answer · 2015-08-13 17:55:06Z

1

You can use the dataframe sort functionality, the rest of the columns will follow along:

result = df.sort_index(by=['ID Name'], ascending=[True])

answered Aug 13, 2015 at 17:55

Incognos

2,0011 gold badge18 silver badges28 bronze badges

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

1 Comment

d_- Over a year ago

.sort_values (.sort_values is deprecated)

Alexander · Accepted Answer · 2015-08-13 18:00:20Z

0

df.sort('ID Name') will sort the DataFrame by rows based on 'ID Name'

you could add a new column that is the sorted ID:

new_col = df['ID Name'].copy()
new_col.sort()
df['sorted ID'] = new_col

answered Aug 13, 2015 at 18:00

Alexander

111k32 gold badges212 silver badges208 bronze badges

Collectives™ on Stack Overflow

Sorting pandas dataframe according to first column

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related