Removing entire column if any of the value in that column contains a NaN

2 Ansichten (letzte 30 Tage)
I am trying to clean up my dataset. Therfore I want to remove any columns that contain any Nan values.
The dataset is of form table. I have tried a few approaches but did not succeed

Akzeptierte Antwort

Voss
Voss am 4 Apr. 2022
% make a table with some NaNs:
A = magic(5);
A([7 15]) = NaN;
t = array2table(A)
t = 5×5 table
A1 A2 A3 A4 A5 __ ___ ___ __ __ 17 24 1 8 15 23 NaN 7 14 16 4 6 13 20 22 10 12 19 21 3 11 18 NaN 2 9
% remove columns/table-variables with any NaNs:
t(:,any(isnan(t{:,:}),1)) = []
t = 5×3 table
A1 A4 A5 __ __ __ 17 8 15 23 14 16 4 20 22 10 21 3 11 2 9

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by