Interpolating DataFrame method=‘index’ help

[tlewick1]

Given the following:

1 2 3 4 5 6 7 8 9

import pandas as pd merged = pd.DataFrame({'Z':(0,1.,2.5,3.),'X':(-1.,None,None,0),'U':(0,1.,1.,0)})   for col in merged:     merged[col] = pd.to_numeric(merged[col], errors='coerce')   print(pd.Series(data=merged['X'].values,index=merged['Z'].values)     .interpolate(method='index')) print('\nvs.\n',merged.interpolate(method='linear'))

Can I interpolate my data within the DataFrame similar to the 'linear' method but get the results achieved by indexing a series? I'm losing data by making the series and don't know how to get my answer otherwise.

Do I need to take my DataFrame, break it up into Series, then turn them back into a new interpolated DataFrame?

[scidam]

You can set index, perform interpolation and drop the index:

1	merged.set_index('Z').interpolate(method='index').reset_index()