How to remove rows which match some conditions in scv file?

Hi, I started to learn Matlab and am doing my thesis on finance.

I want to use only rows in the table which contain 10, 11 in collumn 3, so remove all other rows wichi do not contain 10, 11 in collum 3.

How can I code this from the start on Matlab?

Please let me know how to do! thank you

[Geoff Hayes]

jintaek - what have you tried so far? Have you written the code to read the data from the csv file?

Answer 1

[Suryaansh Mata]

After importing the table into MATLAB language as an array of type double follow these steps -:

1) Run a loop on each row of the array/table. Since we would be deleting the rows during our operation, it is advisable to use a 'while' loop and put in the stopping criteria as counter = numel(array), i.e stop when the counter reaches the last element of the array(modified).

2) Put in an if condition check inside the loop for each row, i.e if ~(row(3)==10 || row(3)==11) delete the row, in order to delete the row, use array(counter) = [], where counter denotes the current row being looked at in the array.

These 2 steps should do the job.