Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

by

You can use the dayfirst parameter in pd.to_datetime.

pd.to_datetime(df.tmp, dayfirst=True)

Output:

0   2015-06-11 00:56:55
1   2015-06-11 04:16:38
2   2015-06-12 16:13:30
3   2015-06-12 21:24:03
4   2015-06-13 02:31:44
5   2015-06-13 02:37:49
Name: tmp, dtype: datetime64[ns]

More Related Contents:

  1. How to convert index of a pandas dataframe into a column
  2. Pandas filtering for multiple substrings in series
  3. How to join two dataframes for which column values are within a certain range?
  4. Filtering Pandas DataFrames on dates
  5. How to print pandas DataFrame without index
  6. datetime dtypes in pandas read_csv
  7. df.append() is not appending to the DataFrame
  8. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  9. Combining two Series into a DataFrame in pandas
  10. Convert pandas Series to DataFrame
  11. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  12. Python Pandas Group by date using datetime data
  13. Removing the timestamp from a datetime in pandas dataframe
  14. Pandas filter dataframe rows with a specific year
  15. how do I calculate a rolling idxmax
  16. Python/Pandas convert string to time only
  17. Remove name, dtype from pandas output of dataframe or series
  18. Convert pandas data frame to series
  19. Convert Pandas Series to DateTime in a DataFrame
  20. Compute the running (cumulative) maximum for a series in pandas
  21. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  22. Python pandas integer YYYYMMDD to datetime
  23. Using replace efficiently in pandas
  24. Group DataFrame in 5-minute intervals
  25. What values are valid in Pandas ‘Freq’ tags?
  26. Python Pandas iterate over rows and access column names
  27. Python: Adding hours to pandas timestamp
  28. Get weekday/day-of-week for Datetime column of DataFrame
  29. Plot pandas dates in matplotlib
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment