0

Hello I've seen posts similar to this one which describe how users can add missing values to a time series using Python. I currently have a list of services with no time component that I'd like to create a row per day for.

Currently the data looks like Service1 Service2

And I'd like it to look like: Service1 2017-01-01 .... Service1 2017-12-31 Service2 2017-01-01 .... Service2 2017-12-31

user7065877
  • 9
  • 4
  • How do you know what date to use? – Peter Wood Jun 07 '17 at 17:28
  • I would be joining to another table to get the counts per day so I guess I could retrofit the linked answer. Do you know how/if the solution posted would work on groups? All the solutions I found look like they apply to a single series rather than a multiple series for multiple groups. – user7065877 Jun 07 '17 at 17:34
  • Each service also has a child service that I want to capture. I need the missing dates in case the child service has a count on a 0 day for the parent. – user7065877 Jun 07 '17 at 17:35

0 Answers0