How do I remove hours and seconds from my DataFrame column in python?

Question

I have a DataFrame :

Age Gender Address     Date
15    M    172 ST   2022-02-07 00:00:00

I Want to remove hh:mm:ss I tried:

import datetime as dt
df["Date"]=df["Date"].dt.Date .

But I am receiving no change in date column format.

All I want is that the date column has only (YYYY-MM-DD).

How about `df["Date"]=df["Date"].dt.date`? – Ynjxsjmh May 06 '22 at 17:55 — Ynjxsjmh, May 06 '22 at 17:55
unfortunately this doesnt work – santro paul May 06 '22 at 17:59 — santro paul, May 06 '22 at 17:59
What's the result of `df.dtypes`. – Ynjxsjmh May 06 '22 at 18:01 — Ynjxsjmh, May 06 '22 at 18:01

score 0 · Accepted Answer · answered May 06 '22 at 18:05

0

You can use pd.to_datetime to convert Date column to datetime object.

df['Date'] = pd.to_datetime(df['Date']).dt.date
# or
df['Date'] = pd.to_datetime(df['Date']).dt.strftime('%Y-%m-%d')
# or
df['Date'] = df['Date'].str.split(' ').str[0]

answered May 06 '22 at 18:05

Ynjxsjmh

16,448
3
17
42

score 0 · Answer 2 · edited May 06 '22 at 19:04

0

df['Date'] = df['Date'].dt.date

alternatively try datetime.datetime.strptime(when, '%Y-%m-%d').date() Note that this returns a new datetime object -- now remains unchanged.

if all this dont work, try print Date.date(), type(Date.date()) and let me know outputs

edited May 06 '22 at 19:04

Yuca

5,558
3
21
39

answered May 06 '22 at 18:09

Joe Tha

163
9

How do I remove hours and seconds from my DataFrame column in python?

2 Answers2