Remove the entire rows of 'Unknown' from a table

2 views (last 30 days)
Hello :) I have a table that contains some 'Unknown'. I would like to remove the entire rows of any columns that is 'Unknown'.
Thank you

Accepted Answer

Adam Danz
Adam Danz on 9 Oct 2018
Assuming the data are stored in a table named ' Valley ', here's how you can remove any rows that contain an ' Unknown '.
Valley(any(strcmp(table2cell(Valley), 'Unknown'),2), :) = []

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2018a

Community Treasure Hunt

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

Start Hunting!