CODEWITHSUNDEEP
pythonpandasimport-from-excel
indiffer
indiffer

Reputation: 39

Importing excel data with pandas showing date-time despite being date value

I've just started using pandas and I'm trying to import an excel file but I get Date-Time values like 01/01/2019 00:00:00 instead of the 01/01/2019 format. The source data is Date by the way, not Date-Time.

I'm using the following code

import pandas as pd 
df = pd.read_excel (r'C:\Users\abcd\Desktop\KumulData.xlsx')
print(df)

The columns that have date in them are "BDATE", "BVADE" and "AKTIVASYONTARIH" which correspond to 6th, 7th and 11th columns.

What code can I use to see the dates as Date format in Pandas Dataframe?

Thanks.

Upvotes: 1

Views: 1066

Answers (2)

Sergey Bushmanov
Sergey Bushmanov

Reputation: 25249

For the sake of completeness, your goal can be achieved by:

df[["BDATE", "BVADE", "AKTIVASYONTARIH"]].astype("datetime64[D]")

Upvotes: 1

kudeh
kudeh

Reputation: 913

If they're already datetimes then you can extract the date part and reassign the columns:

df[["BDATE", "BVADE", "AKTIVASYONTARIH"]] = df[["BDATE", "BVADE", "AKTIVASYONTARIH"]].apply(lambda x: x.dt.date)

solution updated..

Upvotes: 1

Related Questions