How can I convert a str type to date type using python

Question

I'm trying to convert a str type ( like :"1995-01-09 00:00:00") to date, here is my attempt

for line in ratings_df[['user_id','movie_id','rating','timestamp']].values:
    annee= line[3]
    print datetime.strptime(annee, "%Y-%m-%d %H:%M:%S")

and I got this error:

Please `print annee` to confirm you're working with the kind of value you think you're working with. — deceze, Dec 01 '17 at 10:34

score 0 · Answer 1 · answered Dec 01 '17 at 10:38

0

If your example date string is accurately copied to your question there is a trailing space character at the end. The format string does not have this space, so strptime() is not able to parse the string. You can strip() the date string beforehand:

for line in ratings_df[['user_id','movie_id','rating','timestamp']].values:
    annee= line[3].strip()
    print datetime.strptime(annee, "%Y-%m-%d %H:%M:%S")

Or you could add the space to the end of the format string. I think stripping is better.

answered Dec 01 '17 at 10:38

mhawke

84,695
9
117
138

no there is no space in the end in my code – Hamza Lahbabi Dec 01 '17 at 10:47
Then `annee` is not what you think it is. There must be some deviation from what you've posted. Follow @deceze's advice and `print(repr(annee))` to make sure. – mhawke Dec 01 '17 at 11:02

score 0 · Answer 2 · answered Dec 01 '17 at 10:38

0

>>> annee
'1995-01-09 00:00:00 '
>>> datetime.datetime.strptime(annee, "%Y-%m-%d %H:%M:%S ")
datetime.datetime(1995, 1, 9, 0, 0)

No issues found other than extra space at the end, strip timestamp string and try again

answered Dec 01 '17 at 10:38

Laxmikant Ratnaparkhi

4,745
5
33
49

no there is no space in the end in my code – Hamza Lahbabi Dec 01 '17 at 10:47
@HamzaLahbabi - Then there is no error as well, use debugger like pdb or print the timestamp before your conversion – Laxmikant Ratnaparkhi Dec 01 '17 at 10:59

score -1 · Accepted Answer · answered Dec 01 '17 at 11:30

-1

Try printing value of the variable annee first. This might solve the problem.

answered Dec 01 '17 at 11:30

eiram_mahera

950
9
25

yes you're right the first value returned is the header, I deleted and I solved the problem, Thank you for your help – Hamza Lahbabi Dec 01 '17 at 11:33

How can I convert a str type to date type using python

3 Answers3