How do I delete all rows in a table depending on one column's NaNs?

1 view (last 30 days)
Hi,
I have a table A:
1 2 3
NaN 4 5
3 4 NaN
I need to delete all rows where column 3 has a NaN, so as to obtain B:
1 2 3
NaN 4 5
Thanks!

Accepted Answer

KSSV
KSSV on 17 Jan 2022
A = [1 2 3
NaN 4 5
3 4 NaN ] ;
A(isnan(A(:,3)),:)=[]
A = 2×3
1 2 3 NaN 4 5

More Answers (0)

Categories

Find more on Cell Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!