Create DayCounter in Pandas/Python
Budget: $10 – $20 USD
I have a pandas dataframe that contains daily data.
This report needs to be aggregated on a weekly/monthly basis and the number of days in that week needs to be added in a new column.
However, if the week splits across two months (such as calenders week 35), two rows will need to be created.
One with the the count of days in that week within august and another with the count of days in that week within September.
I'll provide a sample dataset as well as the expected outcome.
Only the lines for the day count are relevant, everything else already exists. With bidding and after payment the code will be mine to freely use in any given way.
This report needs to be aggregated on a weekly/monthly basis and the number of days in that week needs to be added in a new column.
However, if the week splits across two months (such as calenders week 35), two rows will need to be created.
One with the the count of days in that week within august and another with the count of days in that week within September.
I'll provide a sample dataset as well as the expected outcome.
Only the lines for the day count are relevant, everything else already exists. With bidding and after payment the code will be mine to freely use in any given way.