How to convert int64 to datetime in pandas
17,463
You need a capital Y. See Python's strftime directives for a complete reference.
df = pd.DataFrame({'old_date': [20180501, 20181230, 20181001]})
df['new_date'] = pd.to_datetime(df['old_date'].astype(str), format='%Y%m%d')
print(df)
old_date new_date
0 20180501 2018-05-01
1 20181230 2018-12-30
2 20181001 2018-10-01
Related videos on Youtube
06 : 20
Pandas To DateTime | pd.to_datetime()
03 : 16
How to convert object datatype to datetime python pandas|object datatype to datetime
10 : 18
How to convert datetime into a datetime format in Python #pandas #timeseries #backtesting #datetime
35 : 41
Python Pandas Tutorial (Part 10): Working with Dates and Time Series Data
01 : 12
Pandas : How to convert int64 to datetime in pandas
10 : 51
Convert String and Number Datetime format into Datetime Object using 3 Python libraries
01 : 12
Pandas : Pandas: how to convert an index of int64 years to datetime
05 : 37
Convert to DateTime
Author by
HHH
Updated on June 16, 2022Comments
-
HHH almost 2 years
I have a pandas dataframe that has a column of type int64 but this columns represets date, e.g. 20180501. I'd like to convert this column to datetime and I'm having the following code but it returns an error message
df['new_date'] = pd.to_datetime(df['old_date'].astype('str'), format = '%y%m%d')I'm getting the following error message
ValueError: unconverted data remains: 0501How can I fix my code?
-
mirekphd about 4 yearsUnfortunately with or without '.astype(str)' it has not effect (silent fail)... when trying to convert from '%Y-%m-%d' to '%d/%m/%Y'.
