Python String to Datetime format

Question

I have an incoming data set where the time periods for data is in quarters i.e 4 quarters in a year. It is represented as as string ['2016:01:00', '2016:02:00','2016:03:00', 2016:04:00'] representing data for each quarter. How can I convert this to datetime format? My expected output for example will be 2016:01:00 for the first quarter of 2016. Thanks in advance

crcvd · Accepted Answer · 2021-03-15 21:41:46Z

1

Fetch the year and the quarter from your string and convert the quarter number into a calendar month.

from datetime import datetime


def convert_to_date(value):
    year, quarter, _ = value.split(":")
    return datetime(int(year), 3 * int(quarter), 1)


values = ["2016:01:00", "2016:02:00", "2016:03:00", "2016:04:00"]

list(map(convert_to_date,  values))

answered Mar 15, 2021 at 21:41

crcvd

1,5451 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python String to Datetime format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related