Skip to content

Tag: date

Why are python dates such a mess and what can I do about it?

A common source of errors in my Python codebase are dates. Specifically, the different implementations of dates and datetimes, and how comparisons are handled between them. These are the date types in my codebase You can print them to see: Is there a canonical date representation in Python? I suppose x7: is probably closest… Also, note comparisons are a

List iteration through JSON array with dates (date format conflict)

I’ve been diving into List Comprehensions, and I’m determined to put it into practice. The below code takes a month and year input to determine the number of business days in the month, minus the public holidays (available at Additionally, I want to list all public holidays in that month/year, but I’m struck with a date format conflict. TypeError:

Count occurrences in last 30 days with Pandas Dataframe

I have a pandas Dataframe with an ID column and a date column (YYYY-MM-DD), ID Date 001 2022-01-01 001 2022-01-04 001 2022-02-07 002 2022-01-02 002 2022-01-03 002 2022-01-28 There may be gaps in the date field, as shown. I would like to have a new column, “occurrences_last_month” where it counts the number of occurrences for each ID in the last

I want to add date range where value is True in pandas

Dt 1/2/21 2/2/21 3/2/21 4/2/21 5/2/21 6/2/21 7/2/21 Attendance(Expected output in python) san TRUE TRUE TRUE TRUE TRUE TRUE TRUE 1/2/21 – 7/2/21 don TRUE TRUE FALSE TRUE TRUE TRUE TRUE 1/2/21 -2/2/21,4/2/21-7/2/21 sam FALSE TRUE TRUE FALSE TRUE TRUE TRUE 2/2/21 – 3/2/21,5/2/21-7/2/21 den FALSE FALSE TRUE FALSE TRUE TRUE FALSE 3/2/21,5/2/21 – 6/2/21 I want to add Attendance