Sort a alphanumeric column in pandas and replace it with original column of the dataset

Asked Nov 22 '17 at 07:46

Active Nov 22 '17 at 07:46

Viewed 61 times

My input is

Name        Date                  ID
Ram    2017-04-01 00:00:00      ABCD12A
Rahul  2017-04-11 20:00:00      ABCD12B
Vivek  2017-04-03 06:00:00      ABCD11C

Expected Output:

Name        Date                  ID
Vivek  2017-04-03 06:00:00      ABCD11C
Ram    2017-04-01 00:00:00      ABCD12A
Rahul  2017-04-11 20:00:00      ABCD12B

asked Nov 22 '17 at 07:46

FunnyCoder

Do you want `df = df.sort_values('ID')` ? If yes, it is dupe :( – jezrael Nov 22 '17 at 07:47
No. It is not as the other question. Here 'ABCD' is to be taken as string and 11 as integer and again C or B or A as string – FunnyCoder Nov 22 '17 at 08:46
Can you explain more? – jezrael Nov 22 '17 at 08:47
Can you please unmark it as duplicate, so that other's can answer – FunnyCoder Nov 22 '17 at 11:32
Sorry, can you add more data for better explanation? Why `df = df.sort_values('ID')` does not work? Or is necessary cut `ID` column for 3 separately columns and sort by them? Or need `natsorting` ? – jezrael Nov 22 '17 at 11:34
I can and I want reopen it, but I think your question need more information. Can you add it? – jezrael Nov 22 '17 at 11:50

Sort a alphanumeric column in pandas and replace it with original column of the dataset

0 Answers0