Problem 71. Read a column of numbers and interpolate missing data

Given an input cell array of strings s, pick out the second column and turn it into a row vector of data. Missing data will be indicated by the number 9999. If you encounter missing data, you should perform linear interpolation to the nearest accurate data points (missing data will not occur in the first or last element).

The first row is always descriptive text. So if the input cell array s is

 s = { ...
    'Day  Temp'
    '  1   -5'
    '  2   19'
    '  3   1'
    '  4   9999'
    '  5   3'};

then the output variable t is the following row vector.

 t = [-5 19 1 2 3];

Here's an example of real-world data.

Solution Stats

25.26% Correct | 74.74% Incorrect
Last Solution submitted on Jul 06, 2020

Problem Comments

Solution Comments

Problem Recent Solvers1361

Suggested Problems

More from this Author95

Problem Tags