row_range not working about django-pivot

[martsberger]

It looks like maybe the documentation in the Readme is wrong. The first parameter to pivot is the row and the second parameter is the column. In order to fill in the date using row_range you'd want

row_range = [date(2022, 3, 28) + timedelta(days) for days in range(8)]
trackings = pivot(trackings, 'date', 'project', 'time', row_range=row_range)

[GarikFirst]

Thank you for your very quick response!

Oh, I got the point - if I want to populate dates by row_range - date should always be first parameter (which is row).

I ended up with something like this

dates = [datetime.date(2022, 3, 28), datetime.date(2022, 3, 29), datetime.date(2022, 3, 30), datetime.date(
    2022, 3, 31), datetime.date(2022, 4, 1), datetime.date(2022, 4, 2), datetime.date(2022, 4, 3)]

tracks = [{'project': 1, '2022-03-28': datetime.timedelta(seconds=14400), '2022-03-29': None, '2022-03-30': None},
{'project': 2, '2022-03-28': datetime.timedelta(seconds=90), '2022-03-29': None, '2022-03-30': datetime.timedelta(seconds=3900)},
{'project': 3, '2022-03-28': None, '2022-03-29': datetime.timedelta(seconds=21600), '2022-03-30': None}]

for t in tracks:
    for d in dates:
        if str(d) not in t:
            t[str(d)] = None

And get list of dicts as I wanted (to easy iterate in Django template later):

[{'project': 1, '2022-03-28': datetime.timedelta(seconds=14400), '2022-03-29': None, '2022-03-30': None, '2022-03-31': None, '2022-04-01': None, '2022-04-02': None, '2022-04-03': None}, {'project': 2, '2022-03-28': datetime.timedelta(seconds=90), '2022-03-29': None, '2022-03-30': datetime.timedelta(seconds=3900), '2022-03-31': None, '2022-04-01': None, '2022-04-02': None, '2022-04-03': None}, {'project': 3, '2022-03-28': None, '2022-03-29': datetime.timedelta(seconds=21600), '2022-03-30': None, '2022-03-31': None, '2022-04-01': None, '2022-04-02': None, '2022-04-03': None}]

[GarikFirst]

As designed