Oct-22-2020, 12:48 AM
You can set index, perform interpolation and drop the index:
merged.set_index('Z').interpolate(method='index').reset_index()