Can only use .dt accessor with datetimelike values

Use format '%Y-%m-%d' and use .dt.strftime("%Y%m")

Ex:

import pandas as pd
testdata['prd_exp_dt'] = pd.to_datetime(testdata['prd_exp_dt'] ,errors = 'coerce',format = '%Y-%m-%d').dt.strftime("%Y%m")

Related Posts:

  1. Python datetime to string without microsecond component
  2. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  3. Converting string into datetime
  4. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  5. How to compare two dates?
  6. Converting between datetime and Pandas Timestamp objects
  7. How to convert string to datetime format in pandas python?
  8. Convert datetime to Unix timestamp and convert it back in python
  9. Convert date to datetime in Python
  10. How do I get the day of week given a date?
  11. Parse date string and change format
  12. datetime to string with series in pandas
  13. Convert Pandas Column to DateTime
  14. How do I find the time difference between two datetime objects in python?
  15. How do I calculate the date six months from the current date using the datetime Python module?
  16. Get current time in milliseconds in Python?
  17. How can I convert a datetime object to milliseconds since epoch (unix time) in Python?
  18. When should I use uuid.uuid1() vs. uuid.uuid4() in python?
  19. ImportError: No module named tensorflow
  20. Best way to convert string to bytes in Python 3?
  21. How do you change the size of figures drawn with Matplotlib?
  22. PermissionError: [Errno 13] Permission denied
  23. How to find if directory exists in Python
  24. What is setup.py?
  25. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  26. Cannot find module cv2 when using OpenCV
  27. What is the purpose and use of **kwargs? [duplicate]
  28. What does random.sample() method in python do?
  29. (Python) TypeError: ‘float’ object is not subscriptable
  30. Pandas: ValueError: cannot convert float NaN to integer
  31. How to find all occurrences of an element in a list
  32. pygame.error: video system not initialized
  33. TypeError: ‘numpy.float64’ object is not callable
  34. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  35. ‘str’ object has no attribute ‘decode’. Python 3 error?
  36. How to find all the indexes of a recurring item in a list?
  37. Is there a way to delete created variables, functions, etc from the memory of the interpreter?
  38. Code for Greatest Common Divisor in Python
  39. ‘DataFrame’ object has no attribute ‘sort’
  40. How to check Django version
  41. How to change the font size on a matplotlib plot
  42. How can I create a dropdown menu from a List in Tkinter?
  43. How to find all occurrences of a substring?
  44. Does “\d” in regex mean a digit?
  45. How do you use subprocess.check_output() in Python?
  46. Purpose of `numpy.log1p( )`?
  47. How do I change the figure size for a seaborn plot?
  48. How to use pyinstaller?
  49. Contains of HashSet in Python
  50. How to take column-slices of dataframe in pandas
  51. Python: Get the first character of the first string in a list?
  52. How to convert string to binary?
  53. Python error load JSON code of google API
  54. How do I find the duplicates in a list and create another list with them?
  55. Get ZeroDivisionError: float division in python
  56. Importing variables from another file?
  57. Difference between BeautifulSoup and Scrapy crawler?
  58. Displaying better error message than “No JSON object could be decoded”
  59. Running Bash commands in Python
  60. Effect of using sys.path.insert(0, path) and sys.path(append) when loading modules
  61. Count unique values using pandas groupby
  62. Running Bash commands in Python
  63. How do you read a file into a list in Python?
  64. How to find elements by class
  65. SSL error : routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
  66. What is the best way to call a script from another script?
  67. Python was not found; run without arguments to install from the Microsoft Store, or disable this shortcut from Settings
  68. Python map object is not subscriptable
  69. Why does pycharm propose to change method to static
  70. append new row to old csv file python
  71. Distributed 1.21.8 requires msgpack, which is not installed
  72. Python Library Path
  73. .pyw files in python program
  74. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  75. What is the Python equivalent of Matlab’s tic and toc functions?
  76. In Flask, what is “request.args” and how is it used?
  77. Conda command is not recognized on Windows 10
  78. pyserial, ImportError: No module named serial
  79. TypeError: only integer arrays with one element can be converted to an index 3
  80. In Flask, what is “request.args” and how is it used?
  81. How do I determine the size of an object in Python?
  82. Python function pointer
  83. How can I change the font size using seaborn FacetGrid?
  84. python math domain errors in math.log function
  85. Append a dictionary to a dictionary
  86. Python way to clone a git repository
  87. List append() in for loop
  88. How to save an image locally using Python whose URL address I already know?
  89. How to throw error and exit with a custom message in python
  90. What is the difference between random.randint and randrange?
  91. How to find length of digits in an integer?
  92. What exactly do “u” and “r” string flags do, and what are raw string literals?
  93. “E: Unable to locate package python3-pip”
  94. Eclipse, PyDev “Project interpreter not specified”
  95. How to exit an if clause
  96. Python a &= b meaning?
  97. TypeError: can only concatenate tuple (not “int”) in Python
  98. No handlers could be found for logger
  99. TypeError: ‘NoneType’ object has no attribute ‘__getitem__’
  100. File “/usr/bin/pip”, line 9, in from pip import main ImportError: cannot import name main

Leave a Comment