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

35.21% Correct | 64.79% Incorrect
Last Solution submitted on Nov 01, 2024

Problem Comments

Solution Comments

Show comments

Problem Recent Solvers2280

Suggested Problems

More from this Author96

Problem Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!