Info

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

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

3 次查看（过去 30 天）
jintaek sung
jintaek sung 2019-6-17
关闭： MATLAB Answer Bot 2021-8-20
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 youScreen Shot 2019-06-17 at 4.58.37 PM.png
  1 个评论
Geoff Hayes
Geoff Hayes 2019-6-17
jintaek - what have you tried so far? Have you written the code to read the data from the csv file?

此问题已关闭。

回答（1 个）

Suryaansh Mata
Suryaansh Mata 2019-6-18
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.

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by