Converting pandas series timestamp to list of unique dates

Question

I have a column in pandas dataframe in timestamp format and want to extract unique dates (no time) into a list. I tried following ways doesn't really work,

1. dates =  datetime.datetime(df['EventTime'].tolist()).date()
2. dates =  pd.to_datetime(df['EventTime']).date().tolist()
3. dates =  pd.to_datetime(df['EventTime']).tolist().date()

can anyone help?

Try `pd.to_datetime(df['EventTime']).dt.date.unique().tolist()`. — Psidom, Mar 14 '17 at 19:28
thank you @Psidom it is a really good and straightforward answer — lehalle, Dec 27 '17 at 09:21

score 12 · Accepted Answer · answered Mar 14 '17 at 19:35

You can use dt to access the date time object in a Series, try this:

pd.to_datetime(df['EventTime']).dt.date.unique().tolist()
# [datetime.date(2014, 1, 1), datetime.date(2014, 1, 2)]

df = pd.DataFrame({"EventTime": ["2014-01-01", "2014-01-01", "2014-01-02 10:12:00", "2014-01-02 09:12:00"]})

Converting pandas series timestamp to list of unique dates

1 Answers1

Linked