Delete entire rows based on one condition

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 个评论
显示 9更早的评论隐藏 9更早的评论

Luna 2019-12-9

编辑：Luna 2019-12-9

在 MATLAB Online 中打开

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 2022-5-29

Thanks it worked

请先登录，再进行评论。

请先登录，再回答此问题。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by