Given a table, how can I delete rows not satisfying a certain property?

1 view (last 30 days)
Given a table, i want to build a new table keeping only rows where values of column 1 are 35<x<40 and values of column 2 are 20<y<22, other values doesn't interest me. Alternatively i want column vectors without not desiderate values

Accepted Answer

Bhaskar R
Bhaskar R on 24 Jan 2020
Assuming t is your table variable and variable names are col_1 and col_2,
cond = (35>t.col_1 & t.col_1<40)&(20>t.col_2 & t.col_2<20); % your condition
new_t = t(cond, :) ; % your new table based on condition

More Answers (0)

Categories

Find more on Structures in Help Center and File Exchange

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!