time data '193003' does not match format '%y-%m' (match)

Question

I have this problem with converting string to datetime in python. but it didn't work.

Please post you code and error output as text. Screenshots of code can not be accepted on Stack Overflow. — Klaus D., Jun 04 '21 at 08:33

AmineBTG · Answer 1 · 2021-06-04T08:56:44.957

0

For 193003, The format should be

# change data type to str if not already the case
cus_data["TYMD"] = cus_data["TYMD"].astype(str)
cus_data["TYMD"] = cus_data["TYMD"].str[:4] + "-" + cus_data["TYMD"].str[4:]

or

cus_data["TYMD"] = cus_data["TYMD"].apply(lambda x: str(x)[:4] + "-" + str(x)[4:])

edited Jun 04 '21 at 08:56

answered Jun 04 '21 at 08:33

AmineBTG

597
3
13

OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 9999-12-01 00:00:00 what's wrong?:( – 박혜림 Jun 04 '21 at 08:38
What is your desired output ? – AmineBTG Jun 04 '21 at 08:43
I just want to convert a string series to a date type. And it wants to be expressed like '1930-03'. – 박혜림 Jun 04 '21 at 08:50
you shold use other string method as the date is not a complete date. check my answer – AmineBTG Jun 04 '21 at 08:53

score 0 · Answer 2 · answered Jun 04 '21 at 08:41

0

%y is for short year. Ex, 2018 will be represented as 18, and %Y is for long year. In your case, your format is %y-%m, so your format should be 30-03. If you want the full year, %Y%m will work.

answered Jun 04 '21 at 08:41

OutOfBoundsDatetime: Out of bounds nanosecond timestamp: 9999-12-01 00:00:00 what's wrong?:( – 박혜림 Jun 04 '21 at 08:44
https://stackoverflow.com/questions/32888124/pandas-out-of-bounds-nanosecond-timestamp-after-offset-rollforward-plus-adding-a refer to this – Jun 04 '21 at 08:50

time data '193003' does not match format '%y-%m' (match)

2 Answers2