Some scopes have date ranges as a key indicator as opposed to a certain individual date. However, it may be important to see values on those lines by a specific date.
For example, this row has important data to be compiled:
> df.iloc[0]
id 582823
days 48
from 2021-11-15
to 2022-01-01
And if we want to see the days
split out per year and month? The result would output multiple rows where the chosen VALUES
would aggregate
> df.iloc[0:3]
id days daysCalculated yearCalculated monthCalculated from to
0 582823 48 16 2021 11 2021-11-15 2021-01-01
1 582823 48 31 2021 12 2021-11-15 2021-01-01
2 582823 48 1 2022 1 2021-11-15 2021-01-01