AttributeError: Can only use .dt accessor with datetimelike values

Your problem here is that to_datetime silently failed so the dtype remained as str/object, if you set param errors='coerce' then if the conversion fails for any particular string then those rows are set to NaT.

df['Date'] = pd.to_datetime(df['Date'], errors='coerce')

So you need to find out what is wrong with those specific row values.

See the docs

Related Posts:

  1. how to sort pandas dataframe from one column
  2. How to reset index in a pandas dataframe? [duplicate]
  3. How to iterate over rows in a DataFrame in Pandas
  4. pandas read_json: “If using all scalar values, you must pass an index”
  5. Writing a pandas DataFrame to CSV file
  6. ImportError: No module named pandas
  7. How to change the order of DataFrame columns?
  8. ImportError: No module named pandas. Pandas installed pip
  9. How can I use the apply() function for a single column?
  10. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  11. How to groupby based on two columns in pandas?
  12. “Series objects are mutable and cannot be hashed” error
  13. Merging dataframes on index with pandas
  14. TypeError: ‘Series’ objects are mutable, thus they cannot be hashed problemwith column
  15. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  16. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  17. Convert Python dict into a dataframe
  18. re.sub erroring with “Expected string or bytes-like object”
  19. How do I select rows from a DataFrame based on column values?
  20. DataFrame constructor not properly called! error
  21. Error”Can only compare identically-labeled Series objects” and sort_index
  22. Pandas group-by and sum
  23. Python Pandas – Missing required dependencies [‘numpy’] 1
  24. pandas DataFrame “no numeric data to plot” error
  25. pandas: filter rows of DataFrame with operator chaining
  26. ‘DataFrame’ object has no attribute ‘sort’
  27. Pandas how to use pd.cut()
  28. How to Read .txt in Pandas
  29. How to read a .xlsx file using the pandas Library in iPython?
  30. Get total of Pandas column
  31. Plot pie chart and table of pandas dataframe
  32. Type error: cannot convert the series to
  33. TypeError: ‘DataFrame’ object is not callable
  34. Pandas ‘count(distinct)’ equivalent
  35. How to check whether a pandas DataFrame is empty?
  36. Convert columns to string in Pandas
  37. Change column type in pandas
  38. What does axis in pandas mean?
  39. Python: pandas merge multiple dataframes
  40. How to load a tsv file into a Pandas DataFrame?
  41. How to count the NaN values in a column in pandas DataFrame
  42. xlrd.biffh.XLRDError: Excel xlsx file; not supported
  43. How to iterate over columns of pandas dataframe to run regression
  44. JSON to pandas DataFrame
  45. Pandas – DataFrame object is not callable
  46. Convert pandas data frame to series
  47. How do I combine two dataframes?
  48. Normalize columns of pandas data frame
  49. Converting strings to floats in a DataFrame
  50. Get first row value of a given column
  51. Normalize columns of pandas data frame
  52. Selecting/excluding sets of columns in pandas
  53. How to add title to seaborn boxplot
  54. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  55. How to add an empty column to a dataframe?
  56. Deleting DataFrame row in Pandas based on column value
  57. Pandas join issue: columns overlap but no suffix specified
  58. How to apply a function to two columns of Pandas dataframe
  59. Pandas long to wide reshape, by two variables
  60. Convert categorical data in pandas dataframe
  61. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  62. SettingWithCopyWarning even when using .loc[row_indexer,col_indexer] = value
  63. Loading a file with more than one line of JSON into Pandas
  64. OSError: Initializing from file failed on csv in Pandas
  65. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  66. AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas
  67. Insert a row to pandas dataframe
  68. Python Pandas ValueError Arrays Must be All Same Length
  69. How to save a Seaborn plot into a file
  70. Subtract two columns in dataframe
  71. pandas DataFrame: replace nan values with average of columns
  72. Plot correlation matrix using pandas
  73. Pandas error “Can only use .str accessor with string values”
  74. How to get row number in dataframe in Pandas?
  75. Plotting multiple lines, in different colors, with pandas dataframe
  76. TypeError: cannot concatenate a non-NDFrame object
  77. Rename specific column(s) in pandas
  78. ImportError: No module named ‘xlrd’
  79. How to convert column with dtype as object to string in Pandas Dataframe
  80. Moving Average Pandas
  81. Coalesce values from 2 columns into a single column in a pandas dataframe
  82. Unknown format code ‘f’ for object of type ‘str’- Folium
  83. Pandas: sum up multiple columns into one column without last column
  84. python pandas remove duplicate columns
  85. Convert Pandas Column to DateTime
  86. matplotlib: plot multiple columns of pandas data frame on the bar chart
  87. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  88. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  89. Move column by name to front of table in pandas
  90. Pandas unstack problems: ValueError: Index contains duplicate entries, cannot reshape
  91. Python: Convert timedelta to int in a dataframe
  92. Must have equal len keys and value when setting with an iterable
  93. Pandas dataframe groupby plot
  94. Calculate weighted average using a pandas/dataframe
  95. ValueError: multiclass format is not supported
  96. How to convert .sav file into csv file
  97. ValueError: Must pass DataFrame with boolean values only
  98. Convert list of dictionaries to a pandas DataFrame
  99. Python Pandas : pivot table with aggfunc = count unique distinct
  100. AttributeError: ‘Series’ object has no attribute ‘split’ error in sending emails

Leave a Comment