change multiple columns in pandas dataframe to datetime

by

You can use apply to iterate through each column using pd.to_datetime

data.iloc[:, 7:12] = data.iloc[:, 7:12].apply(pd.to_datetime, errors="coerce")

As part of the changes in pandas 1.3.0, iloc/loc will no longer update the column dtype on assignment. Use column labels directly instead:

cols = data.columns[7:12]
data[cols] = data[cols].apply(pd.to_datetime, errors="coerce")

Related Contents:

  1. Convert Pandas Column to DateTime
  2. Converting between datetime, Timestamp and datetime64
  3. Extracting just Month and Year separately from Pandas Datetime column
  4. Keep only date part when using pandas.to_datetime
  5. Filtering Pandas DataFrames on dates
  6. How to print pandas DataFrame without index
  7. datetime dtypes in pandas read_csv
  8. How to change the datetime format in Pandas
  9. Combine Date and Time columns using pandas
  10. pandas dataframe groupby datetime month
  11. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  12. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  13. how to test if a variable is pd.NaT?
  14. Converting between datetime and Pandas Timestamp objects
  15. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  16. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  17. How to convert string to datetime format in pandas python?
  18. Create a day-of-week column in a Pandas dataframe using Python
  19. Pandas: Subtracting two date columns and the result being an integer
  20. How to convert columns into one datetime column in pandas?
  21. Pandas: Convert Timestamp to datetime.date
  22. Getting min and max Dates from a pandas dataframe
  23. Find the end of the month of a Pandas DataFrame Series
  24. How do I properly set the Datetimeindex for a Pandas datetime object in a dataframe?
  25. Locate first and last non NaN values in a Pandas DataFrame
  26. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  27. Python Pandas Group by date using datetime data
  28. Pandas: Return Hour from Datetime Column Directly
  29. Python pandas convert datetime to timestamp effectively through dt accessor
  30. How to set a variable to be “Today’s” date in Python/Pandas
  31. Add days to dates in dataframe
  32. AttributeError: Can only use .dt accessor with datetimelike values
  33. Get weekday/day-of-week for Datetime column of DataFrame
  34. How to join two dataframes for which column values are within a certain range?
  35. datetime to string with series in pandas
  36. Comparison between datetime and datetime64[ns] in pandas
  37. Generating random dates within a given range in pandas
  38. Get total number of hours from a Pandas Timedelta?
  39. How do I round datetime column to nearest quarter hour
  40. pandas datetime to unix timestamp seconds
  41. Splitting timestamp column into separate date and time columns
  42. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  43. Pandas converting row with unix timestamp (in milliseconds) to datetime
  44. Subtract a year from a datetime column in pandas
  45. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  46. Convert column of date objects in Pandas DataFrame to strings
  47. Convert Pandas Series to DateTime in a DataFrame
  48. Converting a datetime column to a string column
  49. Converting time zone pandas dataframe
  50. Python pandas integer YYYYMMDD to datetime

Leave a Comment