Pandas: calculating the mean values of duplicate entries in a dataframe

groupby the sample_id column and use mean

df.groupby('sample_id').mean().reset_index()
or
df.groupby('sample_id', as_index=False).mean()

get you