Is there a way to calculate between two value of NaN value?

Question

i'm having a trouble to code into finding in between values in pandas dataframe. the dataframe:

the formula is like this:

value before nan - ((value before nan - value after nan)/div by no. of nan in between the values)

example of expected value should be like this:

30 - (30-25)/2 = 27.5 27.5 - (27.5-25)/1 = 25

so the expected dataframe will look like this:

Sounds like you are trying to interpolate data between NaNs (although if you are your formula isn't quite right). If so look at df.interpolate function: check out https://stackoverflow.com/a/34694772/2794417 — Galo do Leste, Feb 13 '23 at 10:43
i'm still new to pandas and dataframe. i'm not familiar with the interpolate method.. for now, i only know to do for loop. @GalodoLeste — Nazmi Husaini, Feb 13 '23 at 10:51

score 0 · Accepted Answer · answered Feb 13 '23 at 11:12

IIUC, you can generalize your formula into two parts:

{value-before-nan} - ({value-before-nan} - {value-after-nan})/1 = {value-after-nan}

So you can use bfill with interpolate:

df.bfill(limit=1).interpolate()

Output:

1 Answers1