Sorting csv file with Python 3

Question

I'm having trouble sorting a csv file which has in its second column the UTC time as: 2010-01-01 00:00:00

I have a file that is like this:

name        utc_time             longitude    latitude
A           2010-01-01 00:00:34  23           41
B           2011-01-01 10:00:00  26           44
C           2009-01-01 03:00:00  34           46
D           2012-01-01 00:00:00  31           47
E           2010-01-01 04:00:00  44           48
F           2013-01-01 14:00:00  24           41

Which I want it to be outputted in a csv file keeping the same structure but sorted by date:

Output:

name        utc_time             longitude    latitude
C           2009-01-01 03:00:00  34           46
A           2010-01-01 00:00:34  23           41
E           2010-01-01 04:00:00  44           48
B           2011-01-01 10:00:00  26           44
D           2012-01-01 00:00:00  31           47
F           2013-01-01 14:00:00  24           41

I'm actually trying this:

fileEru = pd.read_csv("input.csv")
fileEru = sorted(fileEru, key = lambda row: datetime.strptime(row[1],'%Y-%m-%d %H:%M:%S'), reverse=True)
fileEru.to_csv("output.csv")

But it doesn't work.

Why it doesn't work? Please add an explanation to your question. — 0xdb
– 0xdb, Commented May 20, 2018 at 17:02

MaxU - stand with Ukraine · Accepted Answer · 2018-05-20 14:24:06Z

2

try this:

(pd.read_csv("input.csv", parse_dates=['utc_time'])
   .sort_values('utc_time')
   .to_csv("output.csv", index=False))

answered May 20, 2018 at 14:24

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

Sorting csv file with Python 3

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