Effacer les filtres
Effacer les filtres

Delete entire rows based on one condition

143 vues (au cours des 30 derniers jours)
Khayroon Suleyman
Khayroon Suleyman le 5 Déc 2019
Commenté : Ayush Jain le 29 Mai 2022
Hello,
I am a beginner in Matlab. I have a table that has 7 columns and 240 rows.
I need to delete entire rows based on the following condition:
1. if a value of column 7 is superior than 1000 and inferior than 100 => delete this row
I have attached an image of how the datset looks like. Please help!

Réponses (1)

Luna
Luna le 5 Déc 2019
Modifié(e) : Luna le 6 Déc 2019
Hi,
Try this:
data = num2cell(randi(5000,240,7)); % sample random data in a cell array
my_Table = cell2table(data); % convert cell array to table
new_table = my_Table(~(my_Table.data7 > 1000 | my_Table.data7 < 100),:); % filter and remove
  11 commentaires
Luna
Luna le 9 Déc 2019
Modifié(e) : Luna le 9 Déc 2019
Use the fullfile path and name together for example:
readtable('C:\Users\Desktop\...\CourseworkFinalDATAEXCEL.xlsx','ReadRowNames',true);
The path is where your excel file is.
Ayush Jain
Ayush Jain le 29 Mai 2022
Thanks it worked

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by