I have a dataframe:
Between the JOB_START and JOB_END events there can be x number of rows depending on what job steps take place for a given job. The JOB_START and END events are marked with the job_id_number, but the rows between are not. I need to fill the rows in between the existing job_id_nums.
I started with this solution, but this solution is for a multi-index dataframe, whereas mine is not. I can
ffill() the values in I need, but I have to know how many rows I need to fill in as the number of rows to be filled will change job_id_num to job_id_num.
Source: Python Questions