Convert column to date when date in format dd.mm.yyyy

Question

I have a df where date is in format dd.mm.yyyy. I want to convert this column into date datatype.

df

Date        Col1   Col2
23.11.2020  V1     100
22.10.1990  V2     200
31.12.1890  V4     79

How to convert date column to date type. Right now Date column is object type.

score 3 · Answer 1 · answered Dec 12 '20 at 06:12

3

Does this solve your question?

pd.to_datetime(df['Date'], format='%d.%m.%Y')

Any other queries on this question are welcome!
Happy Coding!

answered Dec 12 '20 at 06:12

Aryan

1,093
9
22

Since OP wants only `date` part, you can do this: `pd.to_datetime(df['Date'], format='%d.%m.%Y').dt.date`. – Mayank Porwal Dec 12 '20 at 08:39

m0nhawk · Accepted Answer · 2020-12-12T06:24:10.957

2

You can use pandas to_datetime:

import pandas as pd
d = {"Date": ["23.11.2020", "22.10.1990", "31.12.1890"], "Col1": ["V1", "V2", "V4"], "Col2": [100, 200, 79]}
df = pd.DataFrame(d)
df["Date"] = pd.to_datetime(df["Date"], format='%d.%m.%Y', errors='coerce').dt.date
df

    Date    Col1    Col2
0   2020-11-23  V1  100
1   1990-10-22  V2  200
2   1890-12-31  V4  79

df.dtypes

Date    object
Col1    object
Col2     int64
dtype: object

edited Dec 12 '20 at 06:24

answered Dec 12 '20 at 06:11

m0nhawk

22,980
9
45
73

How to get only date, no datetime – noob Dec 12 '20 at 06:15
@noob What resulting type you want? I have added extra info about types. – m0nhawk Dec 12 '20 at 06:18
I want to return only dates , i dont want datetime. Only the date part should come not the time stamp – noob Dec 12 '20 at 06:21
Ok, to get `datetime.date` you can use `.dt.date` with `to_datetime`. I've updated an answer. – m0nhawk Dec 12 '20 at 06:24
@m0nhawk - The format applied to the `Date` column isn't preserved. The original is `dd-mm-yy`. While here it becomes `yy-mm-dd`. – etch_45 Dec 12 '20 at 06:25

Convert column to date when date in format dd.mm.yyyy

2 Answers2