I am trying to write a Python code to automate my work. I have pandas dataframe with date, values & id associated to it. It am trying to backfill values to individual 365 days based on dates & ids given. Below it shows input and output formats.

I started with this but couldn’t go far –

data[‘dayofyear’] = data[‘Date’].dt.dayofyear