BUG: pd.to_datetime() produces NaN when first row is a time in the current month about pandas HOT 4 CLOSED

Thanks for the report! This is caused by the current method of guessing the date format which just guesses the date format for the first item and applies it to the other items, and the problem here is that it cannot actually identify if you want 'full month name' (May) or 'abbreviated month name' (also May).

Currently it just guesses full month name for whenever it sees May, but, there is an effort to fix this in #58328
I recommend passing the format parameter to stop relying on the broken guessing behavior e.g. to_datetime(..., format="%a, %d %b %Y %H:%M:%S %z")

from pandas.

Thank you, add the format string worked.

from pandas.

Your code is work, i check this . Please see the above images.

from pandas.

Closing as duplicate, feel free to continue discussion in the original issue.

from pandas.