CODEWITHSUNDEEP
pythonpython-3.xpandasdate
user1315789
user1315789

Reputation: 3649

Inconsistent conversion of date format in panda dataframe date column

I have this panda dataframe df_scaled.

      Name        Date      Sales 
283    AXP  10-02-2009  1.143791
284    AXP  11-02-2009  1.065359
285    AXP  12-02-2009  1.039869
286    AXP  13-02-2009  1.049020
287    AXP  17-02-2009  0.975817
288    AXP  18-02-2009  0.922222

I run the following code to convert the date format in the Date column from dd-mm-yyyy to yyyy-mm-dd.

df_scaled['Date'] = pd.to_datetime(df_scaled['Date']).dt.strftime('%Y-%m-%d')

The result looks like this;

      Name      Date      Sales 
283    AXP  2009-10-02  1.143791  
284    AXP  2009-11-02  1.065359  
285    AXP  2009-12-02  1.039869  
286    AXP  2009-02-13  1.049020  
287    AXP  2009-02-17  0.975817  
288    AXP  2009-02-18  0.922222

In the first 3 rows, the converted date format is yyyy-dd-mm. In the last 3 rows, the converted date format is yyyy-mm-dd. What is wrong with the code to produce this inconsistency in the conversion?

I am using python v3.6

Upvotes: 2

Views: 311

Answers (1)

BENY
BENY

Reputation: 323226

Adding dayfirst

df_scaled['Date'] = pd.to_datetime(df_scaled['Date'], dayfirst=True).dt.strftime('%Y-%m-%d')    
Out[510]: 
283   2009-02-10
284   2009-02-11
285   2009-02-12
286   2009-02-13
287   2009-02-17
288   2009-02-18
Name: Date, dtype: datetime64[ns]

Upvotes: 4

Related Questions