Pandas interpolate data with units,df['depth'] = df['depth'].interpolate(method='values')