I imported data from a large excel file and now I want to delete the rows that have the values of column "dds" equal to 1 or 7. How can I proceed?

1 view (last 30 days)

Show older comments

Eduardo Rocha on 23 Oct 2016

0
Link

Direct link to this question

https://ch.mathworks.com/matlabcentral/answers/308761-i-imported-data-from-a-large-excel-file-and-now-i-want-to-delete-the-rows-that-have-the-values-of-co

Commented: Eduardo Rocha on 23 Oct 2016

Accepted Answer: Walter Roberson

I imported data from a large excel file and now I want to delete the rows that have the values of column "dds" equal to 1 or 7. How can I proceed?

0 Comments
Show -2 older commentsHide -2 older comments

Sign in to comment.

Sign in to answer this question.

Accepted Answer

Walter Roberson on 23 Oct 2016

0
Link

Direct link to this answer

https://ch.mathworks.com/matlabcentral/answers/308761-i-imported-data-from-a-large-excel-file-and-now-i-want-to-delete-the-rows-that-have-the-values-of-co#answer_240331

Open in MATLAB Online

ddscol = 4;   %set according to which column it is in
YourData( ismember(YourData(:,ddscol), [1, 7]), :) = [];   %delete the rows where dds is 1 or 7

1 Comment
Show -1 older commentsHide -1 older comments

Eduardo Rocha on 23 Oct 2016

Already found another way but thank you anyway, that should work as well :)

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Categories

Computational Finance Spreadsheet Link Data Import from MATLAB

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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