How to solve readcell 1x1 missing ?

24 views (last 30 days)
I am using readcell command in order to read a file. But some numbers/data in columns show 1x1 missing. How could I solve this problem?
I ve tried
data=readcell('input.txt')
y=rmmissing(readtable(data(3:end,8)))
but no use.
Could you please help me?
  2 Comments
Walter Roberson
Walter Roberson on 21 Feb 2021
The input to readtable() has to be a character vector or scalar string object. However, data(3:end,8) would be a cell, not a character vector or string scalar. data(3:end,8) would also typically be non-scalar unless the cell just happened to have exactly 3 rows.
Ivan Mich
Ivan Mich on 21 Feb 2021
Ok , what to do then in order to separate my problem?

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 21 Feb 2021
data = readtable('input.txt', 'readvariablenames', false);
rmdata = rmmissing(data);
y = table2cell(rmdata);

More Answers (0)

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!