How to solve readcell 1x1 missing ?
22 views (last 30 days)
Show older comments
Ivan Mich
on 21 Feb 2021
Answered: Walter Roberson
on 21 Feb 2021
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
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.
Accepted Answer
Walter Roberson
on 21 Feb 2021
data = readtable('input.txt', 'readvariablenames', false);
rmdata = rmmissing(data);
y = table2cell(rmdata);
0 Comments
More Answers (0)
See Also
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!