Info

此问题已关闭。 请重新打开它进行编辑或回答。

Check if number in Row, if not delete the complete column

1 次查看(过去 30 天)
Hello, this is the Data:
TestData = {'A','B','C','D';...
3,4,8,7;...
4,9,5,9;...
5,[],2,[];...
7,[],2,[];...
1,[],6,[]}
1. Check if in row 4 is a number
2. If not, delete the complete column where is not a number.
3. In this case this means: Delete column B and D.
The real data is very big, over 10000 rows...
How can I do this ?

回答(1 个)

goerk
goerk 2015-10-13
You can try this
mask = cellfun(@isempty, TestData);
deleteColumn = sum(mask)>0;
TestData(:,deleteColumn) = [];

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by