Change string format into date time format or separate them via Python?

Question

I have a column of data which is like 20181,20182,20183,20184. I am wondering how to change them to the 2018Q1, 2018Q2 format or separate them into two columns one for years and the other for quarters.

question from:https://stackoverflow.com/questions/65838344/change-string-format-into-date-time-format-or-separate-them-via-python

Answer 1

Since years are in the foreseeable future always 4 characters long, you can simply split at the 4th character like this:

s = '20181'
year, quarter = s[:4], s[4:]
# You can now use year and quarter separately or merge them back in the given format:
print(year + 'Q' + quarter)