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