CODEWITHSUNDEEP
python-3.xsortingdatetimetimestampepoch
Shekhar Joshi
Shekhar Joshi

Reputation: 29

Why Sorting the timestamp using sort_values is not working?

I have a column of timestamp converted to human readable form. I have tried to sort it from epochtime as well as after converting. It's giving me 

Fri, 08 Feb 2019 17:24:16 IST
Mon, 11 Feb 2019 02:19:40 IST
Sat, 09 Feb 2019 00:22:43 IST

which is not sorted.

I have used sort_values()

each_tracker_df = each_tracker_df.sort_values(["timestamp"],ascending=True)

why it isn't working??

Upvotes: 0

Views: 428

Answers (1)

Justice_Lords
Justice_Lords

Reputation: 969

Since all the time is in IST. Replace the string IST with NULL.

>>import datetime
>>times=['Fri, 10 Feb 2010 17:24:16','Fri, 11 Feb 2010 17:24:16','Fri, 11 Feb 2019 17:24:16']
>>change_format=[]
>> for time in times:
         change_format.append(datetime.datetime.strptime(time, '%a, %d %b %Y %H:%M:%S'))
>>change_format.sort()

Upvotes: 1

Related Questions