Info

This question is closed. Reopen it to edit or answer.

How to filter a datasheet?

1 view (last 30 days)
Jasraj Soni
Jasraj Soni on 10 Sep 2019
Closed: MATLAB Answer Bot on 20 Aug 2021
I imported a datasheet from Excel in Matlab. So it is a table of 130 * 23 (rows = 130, columns = 23).
Now I have a column vector,
lets say
A = [1;4;6;10;23;25;35;44;60] // these values are basically the position of rows I want to filter from the table
So how to filter these rows and possibly import the result in a new table and also as an excel file?
  2 Comments
Walter Roberson
Walter Roberson on 10 Sep 2019
Does "filter from the table" mean that you want to extract the rows with those indices?
NewTable = YourTable(A, :);
Does it mean that you want to remove those rows leaving all the other ones?
NewTable = YourTable;
NewTable(A,:) = [];
Does it mean that you want to extract the rows in which those particular A values appear in one particular column?
Jasraj Soni
Jasraj Soni on 10 Sep 2019
Thank you Walter Roberson for your response.
Yes I wanted to extract the rows with those indices, so the first code is working.
Thank you once again.

Answers (0)

Community Treasure Hunt

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

Start Hunting!