Converting integer date value to Datetime in Python

Question

I have a dataframe with tickers, returns, and dates in the format, for example, of "20200101". I'm trying to convert these values to Datetime values. However, when I attempt the following:

fin_data['DATE'] = pd.to_datetime(fin_data['DATE'])

The output is recognizing the date I have (which I'd like to be in YYYY-MM-DD format) as nanoseconds, so the output is something like this:

1970-01-01 00:00:00.020200101

Any help would be greatly appreciated.

Why is it an integer in the first place? If you're reading from a CSV for example, you can specify, pd.read_csv(parse_dates=['DATE']). — wjandrea
– wjandrea, Commented Oct 24, 2021 at 3:07

wjandrea · Accepted Answer · 2021-10-24 03:16:39Z

1

Specify the format:

fin_data = pd.DataFrame({'DATE': [20200101]})

pd.to_datetime(fin_data['DATE'], format='%Y%d%m')

Output:

0   2020-01-01
Name: DATE, dtype: datetime64[ns]

answered Oct 24, 2021 at 3:16

wjandrea

34k10 gold badges69 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting integer date value to Datetime in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related