Changing to MYSQL compliant date format using python

Question

I currently have a csv file containing a column of dates that is formatted as dd/mm/yyyy but i want to change it to yyyy/mm/dd

I have written the code below:

import csv
csv_in = open('news.csv','rb')

for rows in csv.reader(csv_in):
    value = rows[0]
    day= value[:2]
    year= value[-4:]
    month= value[3:5]
    edited = year +'/'+month+'/'+day
    rows[0] = edited
    writer =csv.writer(open('newsedit.csv', 'wb'))
    writer.writerow(rows)

for some reason the code above will only write one row and stop and i can't seem to figure out why this is happening.

try open('newsedit.csv', 'a').

ichbinblau
– ichbinblau

2016-12-08 07:45:48 +00:00
Commented Dec 8, 2016 at 7:45 — ichbinblau
– ichbinblau, Commented Dec 8, 2016 at 7:45
thanks worked like a charm

kimpster
– kimpster

2016-12-08 07:51:19 +00:00
Commented Dec 8, 2016 at 7:51 — kimpster
– kimpster, Commented Dec 8, 2016 at 7:51
it works, but it is not a good idea :)

SheepPerplexed
– SheepPerplexed

2016-12-08 08:12:41 +00:00
Commented Dec 8, 2016 at 8:12 — SheepPerplexed
– SheepPerplexed, Commented Dec 8, 2016 at 8:12

ichbinblau · Accepted Answer · 2016-12-08 07:52:08Z

1

Try convert the date by datetime module.

import datetime
datetime.datetime.strptime("25/01/2013", '%d/%m/%Y').strftime('%Y/%m/%d')

The strptime function loads a string to datetime object while strftime converts the datetime to another format as string.

answered Dec 8, 2016 at 7:52

ichbinblau

4,8395 gold badges26 silver badges38 bronze badges

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

Comments

SheepPerplexed · Accepted Answer · 2016-12-08 07:50:53Z

1

It is because you keep initializing a new writer in each iteration. This causes that the output is being replaced over and over again. You should create a writer object only once, then you can use its writerow() method repeatedly.

(Btw. there is a nice datetime module that makes working with dates easy...)

answered Dec 8, 2016 at 7:50

SheepPerplexed

1,16210 silver badges21 bronze badges

Collectives™ on Stack Overflow

Changing to MYSQL compliant date format using python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related