CODE EXAMPLE FOR PYTHON

impute data by using groupby and transform

df['value'] = df.groupby(['category', 'name'])['value']
    .transform(lambda x: x.fillna(x.mean()))