I have a dataset of spectral measurements (x,y), for which the middle part (y) is missing (below is a subsample, missing is a series of spectrum data from 470nm to 570 nm):300,07  9,742307,07  11,245318,07  12,543342,07  13,599360,07  14,194370,07  14,574375,07  14,734392,07  15,246405,07  15,654420,07  16,238467,07  17,257524,07  539,07  593,07  20,65608,07  21,21621,07  21,745625,07  21,898629,07  21,941650,07  22,788671,07  23,475687,07  24,087692,07  24,29I want to reconstruct the curve by estimating the missing y values by interpolation (either linear or spline) in an automated manner (I have more than 2000 files to process, so Excel is not an option!). I tried spline from plotutils (https://linux.die.net/man/1/spline) to do this, but the result doesn't make any sense:300.07 9.742317.888 12.5286335.706 13.4152353.525 13.9548371.343 14.6128389.161 15.2838406.979 16.1991424.797 10.6369442.615 -22.6927460.434 -13.5454478.252 111.849496.07 318.928513.888 495.58531.706 530.808549.525 406.078567.343 214.289585.161 54.9759602.979 17.0519620.797 21.7555638.615 22.1998656.434 23.0396674.252 23.5829692.07 24.29I searched for other options but haven't found anything specific for this. My programming experience is still very limited, so if anyone has any quick solution for this I would be very thankful!
Interpolation to fill missing data (x,y)
text processing;numeric data