Forum Discussion
linear interpolation of sparse data
I have several lists of data, each sampled at different varying intervals. I want to merge them into an average set of readings, but since they are each missing data and have readings at different times, I need to first fill-in all missing data using some (linear) interpolation.
For example; I want to merge all three months of data into one average month summary:
| 1-Mar | 0 |
| 3-Mar | 2 |
| 10-Mar | 8 |
| 14-Mar | 11 |
| 17-Mar | 14 |
| 21-Mar | 14 |
| 24-Mar | 19 |
| 28-Mar | 22 |
| 31-Mar | 33 |
| 1-Apr | 0 |
| 1-Apr | 0 |
| 7-Apr | 2 |
| 11-Apr | 2 |
| 18-Apr | 3 |
| 21-Apr | 9 |
| 25-Apr | 10 |
| 28-Apr | 14 |
| 30-Apr | 14 |
| 1-May | 0 |
| 5-May | 3 |
| 9-May | 4 |
| 12-May | 8 |
| 16-May | 9 |
| 23-May | 13 |
| 26-May | 16 |
| 30-May | 17 |
| 31-May | 18 |
| 1-Jun | 0 |
| 1-Jun | 0 |
| 6-Jun | 3 |
| 9-Jun | 7 |
| 13-Jun | 9 |
| 20-Jun | 15 |
| 23-Jun | 19 |
| 30-Jun | 22 |
No RepliesBe the first to reply