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

2 views (last 30 days)
Lu Da Silva
Lu Da Silva on 17 Jan 2022
Commented: Lu Da Silva on 17 Jan 2022
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)

Community Treasure Hunt

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

Start Hunting!