Effacer les filtres
Effacer les filtres

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

1 vue (au cours des 30 derniers jours)
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

Réponse acceptée

Voss
Voss le 4 Avr 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

Plus de réponses (0)

Catégories

En savoir plus sur NaNs dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by