converting datetime for entire column

Question

[Still unanswered]

Hello I recently identified a solution to convert a time format into hours and minutes.

from datetime import datetime

x = datetime.strptime('2017-01-01T19:33:28+0000', '%Y-%m-%dT%H:%M:%S%z')\ .strftime('%H:%M')

However I can only do this for one value in a column. How do you apply it to all values in an entire column?

Here are the column values I want to convert: image

Edit 1: Here is my failed attempt The error says "TypeError: strptime() argument 1 must be str, not Series"

Edit 2: Here is my 2nd attempt This error says SyntaxError: unexpected character after line continuation character

and also NameError: name 'pandas' is not defined (even though I'm using pandas which is confusing?)

Thanks!

@Pallison, So how do you select your column of data? Are you using `pandas`? — jpp, May 21 '18 at 21:38
Yes I have a jupyter notebook and I'm using pandas. I can select a column of data by writing df.first_event_date — Pallison, May 21 '18 at 21:39

sebashc3712 · Answer 1 · 2018-05-23T21:38:28.020

0

It's always better work with pandas when you work with data.

import pandas as pd

df --> dataframe

df['column']=pd.to_datetime(df['column'], format=...)

edited May 23 '18 at 21:38

answered May 21 '18 at 21:43

sebashc3712

Thanks -- the other problem is that I want to separate hours and minutes – Pallison May 21 '18 at 21:52
Can anyone else help? Thanks – Pallison May 23 '18 at 21:25
Hi, @Pallison, did you "import pandas"? because "NameError: name 'pandas' is not defined" means that you didn't imported – sebashc3712 May 23 '18 at 21:29
Try with "import pandas as pd" and df['column']=pd.to_datetime(df['column'], format=...). I forgot that – sebashc3712 May 23 '18 at 21:36

1 Answers1