Info
This question is closed. Reopen it to edit or answer.
How to eliminate the rows of data ?
2 views (last 30 days)
Show older comments
I have a large data-set.The data in cell. A sample of this data-set is as follows:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/154312/image.jpeg)
I want to eliminate the number of rows of data that is less than 3 lines in a set (shown in red box). Can I have a simple code to do this?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/154313/image.jpeg)
1 Comment
Christopher Berry
on 12 Aug 2014
Edited: Christopher Berry
on 14 Aug 2014
How is your data stored? double? cell? table? What size is it?
chances are, all you need to do is
rows = [1 4 10];
data(rows,:) = [];
This will remove rows 1 4 and 10 from a 2D matrix of doubles
Answers (2)
Joakim Magnusson
on 12 Aug 2014
Is your data i a matrix? I'm not sure what you want to remove, but for example if you want to remove the first 5 rows, i think you could do like this:
yourMatrix(1:5, :) = [];
But i guess you want to recognize some kind of pattern and remove the rows with the specific pattern?
0 Comments
Ben11
on 12 Aug 2014
If your data is stored in a cell array you could use the following:
% Identify the rows (I) in which there are empty elements
[I,J] = ind2sub(size(YourArray),find(cellfun(@(x) isempty(x),YourArray)))
% Find the unique entries
RowsToDelete = unique(I)
% Delete them
YourArray(RowsToDelete,:) = [];
0 Comments
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!