Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

How to filter a datasheet?

1 vue (au cours des 30 derniers jours)
Jasraj Soni
Jasraj Soni le 10 Sep 2019
Clôturé : MATLAB Answer Bot le 20 Août 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 commentaires
Walter Roberson
Walter Roberson le 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 le 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.

Réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by