Hi I am trying to do an incremental increase on the data I have for NaN values for example:
| Day | Reding | 
|---|---|
| 1 | NaN | 
| 2 | 2.5 | 
| 3 | NaN | 
| 4 | NaN | 
| 5 | NaN | 
| 6 | 3.9 | 
| 7 | NaN | 
| 8 | 3.4 | 
To this:
| Day | Reading | 
|---|---|
| 1 | 2.5 | 
| 2 | 2.5 | 
| 3 | 2.85 | 
| 4 | 3.2 | 
| 5 | 3.55 | 
| 6 | 3.9 | 
| 7 | 3.65 | 
| 8 | 3.4 | 
Advertisement
Answer
As Pranav mentioned, you can try using interpolation
from cmath import nan
import pandas
dataframe = pandas.DataFrame({'Day': list(range(1,8+1)), 'Reding': [nan, 2.5, nan, nan, nan, 3.9, nan, 3.4]})
dataframe.Reding = dataframe.Reding.interpolate()
print(dataframe)
Output
Day Reding 0 1 NaN 1 2 2.50 2 3 2.85 3 4 3.20 4 5 3.55 5 6 3.90 6 7 3.65 7 8 3.40