Expanding a data set

Question

You're given a set of data that is aggregated on a monthly basis (as illustrated in Table A). Can you write code that can expand this monthly table into a daily table which spreads revenue across the 30 day period (as shown in Table B)?

You can assume each month has 30 days and that Table A is in a dataframe named "df".

Table A

Month Revenue
0 1 300
1 2 330
2 3 390

Table B

Month Day Revenue
0 1 1 10
1 1 2 10
2 1 3 10
... ... ... ...
30 2 1 11
31 2 2 11
... ... ... ...
60 3 1 13
... ... ... ...
89 3 30 13

Solution

Access restricted

Subscribe to premium account to see the solution.

Get premium now