Date conversion in python

Question

I have some data in a text file in the following format:

50 Cent     1975-07-06
75 Cents    1933-01-29
9th Wonder  1975-01-15
A Fine Frenzy   1984-12-23

I want to convert it as like:

50 Cent     July 6, 1975
75 Cents    January 29, 1933
9th Wonder  January 15, 1975
A Fine Frenzy   December 23, 1984

Could any of you please help me.Thanks in advance!

@ Sentinel: No, it's part of DB data conversion.I am quite new in python, don't understand really what to do. — Forhad
– Forhad, Commented Jul 3, 2011 at 19:37
Read the data line by line, split each line at the right whitespace (rsplit()) and then convert the date using strptime() as suggested....this is the blueprint...the rest is up to you...come back if you have some code. — user2665694
– user2665694, Commented Jul 3, 2011 at 19:39
By the way: No need to convert a perfectly normal date format, that is the standard around the world. It's ISO 8601. — stesch
– stesch, Commented Jul 3, 2011 at 19:43

Acorn · Accepted Answer · 2011-07-03 20:03:04Z

4

import time

text = """50 Cent     1975-07-06
75 Cents    1933-01-29
9th Wonder  1975-01-15
A Fine Frenzy   1984-12-23"""

for line in text.splitlines():
    dob = line.rsplit(None, 1)[-1]
    dob_new = time.strftime('%B %d, %Y', time.strptime(dob, '%Y-%m-%d'))

    print line.replace(dob, dob_new)

Result:

50 Cent     July 06, 1975
75 Cents    January 29, 1933
9th Wonder  January 15, 1975
A Fine Frenzy   December 23, 1984

Bonus:

A strftime cheatsheet

edited Jul 3, 2011 at 20:03

answered Jul 3, 2011 at 19:28

Acorn

50.8k30 gold badges143 silver badges180 bronze badges

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

Comments

Artsiom Rudzenka · Accepted Answer · 2011-07-03 19:50:41Z

3

You can use strftime and strptime from datetime module Please find below my sample code:

output = []
with open(filename, 'r') as f:
    for line in (l.strip() for l in f if l.strip()):
        data = line.split()
        output.append(line.replace(data[-1], datetime.strptime(data[-1],'%Y-%m-%d').strftime('%B %d, %Y')))

answered Jul 3, 2011 at 19:50

Artsiom Rudzenka

29.3k5 gold badges36 silver badges53 bronze badges

Comments

jcomeau_ictx · Accepted Answer · 2011-07-03 19:21:19Z

0

one way is to use time.strptime to parse and time.strftime to format. pydoc time for the documentation.

answered Jul 3, 2011 at 19:21

jcomeau_ictx

38.6k7 gold badges98 silver badges114 bronze badges

1 Comment

kusut Over a year ago

@Forhad Open your terminal / command prompt and type pydoc time. Alternatively, google "python date time conversion formatting"

Collectives™ on Stack Overflow

Date conversion in python

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related