I have a pandas series of dates in string format, but some of the values are a non-date string. I tried updating them individually to circumvent the non-date strings, but even though the values appear to be changed inside the for loop, the list remains unchanged once printed out of the loop.
diedlist = df['Died'].tolist()
for item in diedlist:
if item == '(living)':
continue
print(item)
item = dt.datetime.strptime(item, ("%b %d, %Y"))
print(item)
The initial print(item) prints out the date in the existing format MMM DD, YYYY.
The print(item) after the strptime() function prints out the date in the new date format ("%b %d, %Y") , and returns a datetime object of YYYY-MM-DD as expected.
However, upon printing the list outside the loop, the items appear in their old format once again, as if untouched.
thank you for your help in advance.