MATLAB: Remove all NaN values from an array.

Question

I have a an arary with NaN values and Im trying to return the array with no NaN rows but the command Im using only returns the first column and not the remaining 2. Here is what I have.

D = [0	0	0
NaN	NaN	NaN
NaN	NaN	NaN
0.0279587435128966	0.0380588867245362	1.99938731654588
0.830388266617646	0.583999369869120	0.978401571089338
-1.07826433834531	-1.64452537544960	0.267810795303313
0.168715496407312	0.263085998125572	2.96351922435162
-0.791458202545459	0.611268411797120	0.998070417818667
-1.41124221175034	-0.289407593850698	0.0506110237693017
1.69942938355116	1.04462646221878	1.15892918358242
-1.55216375501531	-2.44987966243271	0.623934110066297
0.188310075544404	0.501770043093754	3.93441879647330
-1.44603145623221	1.35107113546187	1.15371676572365
-2.35391403973316	0.0183196401577155	0.179737992978120
2.59879677816763	1.38804628951095	1.42948622326796
-1.92629974765512	-3.28302931738291	1.03122259685150
0.190461468181228	0.731318108759712	4.90771374511875
-2.01837467713375	2.14014570650778	1.37684130228734
-3.30531517848174	0.217844651708771	0.414313445558867
3.50709118523837	1.65551615551852	1.75113998255253
-2.23204460424917	-4.13488361866807	1.45650407075820
NaN	NaN	NaN
-2.51244231909718	2.97180232130260	1.63030617210704
-4.25650570961388	0.357419056329789	0.689550723301627
4.41845060685608	1.87363023778730	2.10021053665969
NaN	NaN	NaN
0.204283419234320	1.13357858075284	6.86677329350173
0.617793464714887	0.0559247730198438	6.10612769252045
-2.96417360323821	3.81704174520463	1.91580426879081
-5.20242439373799	0.476408999682868	0.991344090368801
NaN	NaN	NaN
-2.69346338350278	-5.85030685131976	2.37470982965291
NaN	NaN	NaN
-3.26247612265381	-4.91985596911837	1.29018005288354
1.20197539596291	-0.580347098756520	6.61000225666269
-3.37592827171665	4.67443410026770	2.22457026832058
-6.14584567995603	0.584770610127789	1.30473528056482
6.23299868743130	2.22581272192086	2.86321400922248
-2.89467385558292	-6.70726873056154	2.84918921113506
0.209717491582492	1.53184472980862	8.82655723451965
5.28440710514136	1.17097130314088	2.91964410258613
0.576278852478300	2.24513662818586	7.66753960818188
-4.04653068178957	-4.84646596151352	0.673842194982372
1.72465217643194	-1.18852390077965	7.20743841278270
-3.76500316313530	5.53715317053961	2.54758193166533
NaN	NaN	NaN
7.13773556686645	2.38268963160310	3.25924533904186
NaN	NaN	NaN
0.176682672356017	1.77636612069925	9.79563823738556
5.70892694024996	0.283366758099107	3.09836478191717
0.834848920291403	3.20098548783449	7.80716223363894
2.23645813228566	-1.80307906039568	7.80775218019269
-4.13663420978661	6.40608142770811	2.87446730769027
-8.01389420090031	0.739303774953617	2.00147044244114
8.04005085003118	2.54735749010561	3.65763161659614
-3.28567882346993	-8.41947317913047	3.80597816799600
0.151573909742903	2.03767830086445	10.7605659520551
-6.82918401328041	0.278600280775844	2.52363667248442
-3.41363523840503	-7.08870431609608	4.14330417016278
6.35396040499232	-0.474663609164808	3.19491420795479
1.06216210967955	4.10256481833496	8.17524296492560
NaN	NaN	NaN
-4.49887555491066	7.27474744137621	3.21240304800297
-8.93747200633802	0.809847032829654	2.37833604988111
8.93679366464217	2.75035659507643	4.05087923302196
NaN	NaN	NaN
0.120474891403918	2.30220475044321	11.7244428158357
-6.57337445354577	-0.109648927503134	3.40897503798041
-3.90131441220521	-6.94494653825290	5.00440969491056
7.05097560070378	-1.18529470189817	3.29069138158143
1.32262284552297	4.97356081042056	8.59180771001900
3.28964279764057	-2.99261263184027	9.02232637002263
NaN	NaN	NaN
-9.85594939518955	0.878289437178573	2.76784204913582
9.82550611659926	2.98592839011066	4.44419349302377
NaN	NaN	NaN
NaN	NaN	NaN
2.70499218347696	-3.21391766868317	7.83232794441650
-2.84203085926377	-9.70887276953909	3.66930583711619
-6.31756489381112	-0.497898135782113	4.29431340347640
-4.51675110863053	-6.94038338635526	5.79258280428302
7.75826716048403	-1.87839080959415	3.42981878707837
1.60739083428736	5.83327554833172	9.01583337197052
3.81380630124427	-3.57090289370221	9.64749274349896
NaN	NaN	NaN
NaN	NaN	NaN
NaN	NaN	NaN
-3.95158917741763	-10.9629681728992	5.25047121091495
0.0248941422755761	2.76290060345524	13.6682049701363
-3.96468559986903	8.59207273742804	3.45422268973630
-4.53038653298116	-10.2195319906366	4.18835254129213
-0.734431529015096	3.08504028776024	12.4898020857790
-2.18726969349390	-10.1465354228472	3.05307599549947
NaN	NaN	NaN
8.48339326062922	-2.55215288868641	3.57207489297718
1.87742850700644	6.69346716517060	9.44844178339196
4.34166392226097	-4.13247115672692	10.2846798572246
-5.56586475306079	9.87609452074379	4.25855918503254
-11.6790955983398	1.00013474235130	3.58093780141378
NaN	NaN	NaN
-4.18146681245015	-11.8107110275511	5.72847573526420
NaN	NaN	NaN
-5.01771380444628	8.68859923819887	4.83503477926363
-11.0707910122348	1.74054196871139	2.65548002992040
10.2917897254122	4.11482407379025	5.04531576505119
-3.07709698838759	9.04058598690315	3.34923544377891
-5.33828987167225	-10.3219163109967	3.60799950539401
-1.60132614934718	3.53709322295485	12.6999017312361
-1.54894146943167	-10.9162967049884	3.05092033274107
-5.87207894426689	-7.27706132354742	7.22111044525916
9.19708150516313	-3.23729396366693	3.71778280967578
2.16246638659714	7.53688036140245	9.90386201528819
NaN	NaN	NaN
NaN	NaN	NaN
-12.5869638683005	1.05847582076227	3.99611429757949
12.4741903052370	3.72782154860583	5.64162962731677
NaN	NaN	NaN
-0.117831313836442	3.14704466454439	15.6256399113056
-5.12263905580093	-6.24497463333129	7.08967813609694
12.0192752473739	2.63683252321002	4.91950741082613
-0.356383752786310	2.06753636958251	14.9538690730106
-4.82432683709907	8.36778828543718	5.76222505825084
-11.3714796721173	2.54423656126421	2.14200039865984
10.3409483652828	5.09523642848482	5.23603818871536
-2.51827909594159	9.86832727523858	3.29857063679199
-6.25287770866922	-10.7132000972666	3.50589129309214
-2.36401978788600	4.08667038317993	13.0408758632335
-0.941294777818615	-11.7075913421376	3.11887837413883
-6.51646991582703	-7.52932313772351	7.94299980858319
9.93129489441437	-3.89612248749318	3.88172083222431
2.45085479064993	8.37904274966252	10.3594875635271
5.39615235240609	-5.23588347020414	11.5771562315967
-6.29838637588652	11.5959090468773	4.96946613020946
-13.4934939139550	1.11849800090105	4.41396668086456
13.3560587039941	3.97879980976837	6.04077626665814
-4.66083770281051	-13.5064555635579	6.67424974487417
-0.190305773751641	3.31825851790663	16.6082045499309
4.13276375502586	-5.36192414439805	10.9492091807728
-6.84925817295722	10.5529744324725	4.27430148858789
-3.42985131666424	-12.8060653848291	6.29189321974903
12.4472782156548	1.79262097515382	4.59683060460787
-0.969265697396593	1.42667520840022	15.4161165111417
-4.63093986975185	8.04697733267548	6.68941533723806
-11.6721683319997	3.34793115381702	1.62852076739927
10.6473935222220	6.04693718707337	5.25493347623640
-2.09526230734272	10.7732584413744	3.25213378591261
NaN	NaN	NaN
-3.08518409537750	4.55381355839857	13.5524413971067
NaN	NaN	NaN
-7.16852618011623	-7.79029561184318	8.65483967537421
NaN	NaN	NaN
2.74961575841824	9.22006080501373	10.8105202837497
5.91940373192585	-5.77856538198014	12.2341983432318
NaN	NaN	NaN
NaN	NaN	NaN
14.2375127196790	4.23033796821957	6.44048537723224
-4.90482548750795	-14.3518797364834	7.14935807857455
-0.256842361487731	3.48257364865100	17.5923658275175
3.48805865151945	-5.82474564990843	11.5576100219539
-7.79593956238966	10.5156318246102	3.95430168149372
-2.69053395428282	-13.0676366817852	6.91236908091534
-1.29634453936260	0.769338413903471	16.0950331258588
-12.3613490661253	4.05304663560079	1.79538020842352
11.0346392338491	6.96769520707450	5.30231941750650
NaN	NaN	NaN
NaN	NaN	NaN
-3.81673862218978	4.92047366125538	14.1272355718106
0.213902760915944	-13.3203136651040	3.37224349197126
-7.80941982068187	-8.09513320654039	9.35934615677928
11.4394151193908	-5.16054876632176	4.23758075512965
NaN	NaN	NaN
6.43252234323779	-6.32079827045224	12.8995499686033
-7.07383211143869	13.2865901807563	5.70445905497955
-15.3051405282058	1.27037829270024	5.24752068389201
15.1210159202846	4.46599515103718	6.84531594266179
-5.14577002098655	-15.2045147789262	7.61299502294531
-0.317983164395781	3.64456026340699	18.5772628469361
-6.80918548282506	-12.0951514887109	3.35339561881141
0.00275989453789699	-12.3969081554810	2.31548506416491
10.0498269131924	-5.30349412732105	4.05386717860708
-6.34542195316620	12.4337141825404	6.27819395873748
-14.0406792094496	1.95053205584888	5.37168728895026
-8.74262095182211	10.4782892167480	3.63430187439955
-2.08352898087897	-13.4234093997585	7.62298201030021
-1.62524823898295	0.211018782708093	16.8566771016099
-13.0527957686776	4.76641632870353	1.90942028248537
NaN	NaN	NaN
-1.32926749943234	12.6191808692371	3.20187853145089
-8.90427697394364	-12.0983808002039	3.70902405907705
-4.51857327441548	5.31193362454265	14.7223718739115
0.739300604758317	-14.1587446992919	3.51712450037627
-8.43054105986156	-8.41008941943678	10.0769888186925
12.1985960786231	-5.78454274897244	4.42271794954178
3.33844027279261	10.8961815262662	11.7291473862868
6.94294011628082	-6.86470681874592	13.5656109178075
-7.46598788455492	14.1318951491447	6.06732729557058
NaN	NaN	NaN
16.0112859156820	4.67611727972418	7.24938032655521
-5.39694063534771	-16.0560765461907	8.07316442546440
-0.359469527949568	3.81121880610849	19.5624043655940
-0.747709604554860	11.3779605923202	3.08852783265774
-8.09383401386771	-11.2018455074188	2.69585974539909
3.75110759331782	9.57249180495519	11.7797612981313
-6.47678125713324	-13.0198369952679	3.16775040690011
0.360714828155154	-12.2854802745923	1.38841867341412
9.41501216911018	-6.07615850312901	4.05392243315696
-13.8481356477298	2.59576697880873	6.11101054100802
-9.68930234125455	10.4409466088857	3.31430206730538
-1.60745955872613	-13.8495647316542	8.39223459455837
-1.94703058918923	-0.307729555113839	17.6487353577393
-13.7442424712299	5.47978602180627	2.02346035654721
11.9429109087455	8.73084113673968	5.55577703258029
-1.00477140505283	13.5647675900978	3.22571208058463
-9.76733823915033	-12.5811137614715	3.85766503796782
-5.22084381102272	5.67144425611393	15.3368376574996
1.24761575742093	-15.0060030095178	3.67129668115682
-9.04920952346571	-8.72484355300147	10.7968354464859
12.9744574472080	-6.38443237076507	4.61809343009919
NaN	NaN	NaN
NaN	NaN	NaN
-7.86115222565276	14.9737647632398	6.43488776187240
-17.1207809139953	1.45270057745400	6.06610794276213
NaN	NaN	NaN
-5.64050889897158	-16.9076093645874	8.53745567042661
-0.395958217804795	3.98754965607510	20.5460587799402
11.6866341603745	7.72821246056025	4.44594231798566
-16.1494189640715	0.436209689206202	6.04514885215503
4.45852778666915	9.08548174838511	12.2919896406099
8.95466697371231	-6.86576447969623	4.45963748444717
-13.9271135357709	3.24378043048029	6.86853351732841
-10.6359837306870	10.4036040010235	2.99430226021121
-1.10734575133845	-14.5110802383990	8.95105783494515
-2.25139454178835	-0.791390125818375	18.4693662349941
-14.4356891737822	6.19315571490901	2.13750043060905
NaN	NaN	NaN
-0.725571696083408	14.5238659788103	3.27237902049252
-10.6252613684968	-13.0684341668608	4.02041246997108
-5.88586170467024	6.04949425299450	15.9809101697117
1.73611627579122	-15.8625155287376	3.83789064254728
NaN	NaN	NaN
13.7509123493449	-6.98171271957671	4.81902617972214
3.92405850323373	12.5486744299962	12.6915691277980
7.96103751866152	-7.90888207294304	14.9341554167865
NaN	NaN	NaN
-18.0299304999991	1.55494418139621	6.46983219980150
17.7859772304655	5.08465416433844	8.07612282369167
-5.88403223550341	-17.7550603867257	9.00917926496181
NaN	NaN	NaN
3.38780053422142	12.3238258253377	11.4473862753113
8.10848399806722	-7.54642881834149	13.5042927950555
16.4031124230795	5.16380548642338	8.48246305217231
11.8992366843369	7.59744035509705	3.47759381499846
-16.2254118910385	-0.560896369036376	6.04728980216135
5.16594798002048	8.59847169181504	12.8042179830885
8.49432177831443	-7.65537045626345	4.86535253573739
-14.0951071553711	3.79557246499152	7.68542010335095
-11.5826651201194	10.3662613931612	2.67430245311704
-0.622458442067566	-15.2462660663604	9.42475192998195
-2.56737557682325	-1.25015104411963	19.2998446545437
-15.2279243766539	6.80204727738904	2.17768063060336
12.9463887571846	10.4331978151573	5.86201704957991
-0.471652724772864	15.4900449601076	3.31736048454099
-11.4655318016348	-13.5846710626766	4.18607799623557
-6.53880277643117	6.40190146331705	16.6513407141534
2.21311726135150	-16.7240671145918	4.01166902062269
-10.2827342108816	-9.35451822574042	12.2396149809030
14.5410263085169	-7.55927637065563	5.02430686676793
4.21582843880528	13.3718652033541	13.1786289345517
NaN	NaN	NaN
-8.67379478231009	16.6488945584513	7.16530450365852
-18.9374091544050	1.65248740886100	6.87844914826717
18.6731711082141	5.27381098713477	8.49696331565370
-6.12034875678495	-18.6035660269905	9.48266915947725
-0.348514723722292	4.39052464466011	22.5040065576216
11.9484733206090	9.72386977605710	6.57026626776704
-8.92816181116463	-9.62056134853024	11.8356525425317
-8.13987620381568	16.3185406571723	5.94398618721482
-1.27492329145761	3.75809807231079	21.7290766474160
3.65639961267246	13.0529691555231	10.8179384704049
8.76319874000865	-7.70048555897965	12.7642825739447
16.2842656140784	5.08756357145612	9.47244416633177
-16.6552648971854	-1.42221710574932	6.31812735792999
5.87336817337180	8.11146163524497	13.3164463255671
8.03397658291656	-8.44497643283067	5.27106758702760
-14.2631007749714	4.34736449950275	8.50230668937348
-0.142811350904760	-16.0124892957301	9.85235060948581
-2.84701100106894	-1.70798055384049	20.1437618125253
NaN	NaN	NaN
13.4769296919795	11.2655716888664	6.02226701330350
-0.231354562640324	16.4580436946344	3.38971546522787
-12.3030495209246	-14.1015247682576	4.36335268958685
-7.18505905497382	6.76216334642940	17.3240696328276
2.67289544925346	-17.5943550954080	4.18831230064357
NaN	NaN	NaN
NaN	NaN	NaN
NaN	NaN	NaN
8.98050542470168	-8.92186016116511	16.3250335776569
NaN	NaN	NaN
NaN	NaN	NaN
19.5626618706631	5.45125434022741	8.91805717687839
NaN	NaN	NaN
NaN	NaN	NaN
8.61530293741684	-7.60569437463693	16.1965385004939
11.4664727885113	9.85651793537151	7.43633783114276
-8.18365659048897	-10.2058073246621	12.1568987468799
-8.01336894573400	16.8240764484434	5.09050538637828
-2.15746855286469	3.33358051320934	21.9313109263661
3.92499869112350	13.7821124857084	10.1884906654986
NaN	NaN	NaN
NaN	NaN	NaN
6.58078836672313	7.62445157867490	13.8286746680457
7.57363138751868	-9.23458240939789	5.67678263831782
NaN	NaN	NaN
NaN	NaN	NaN
-3.12122400696338	-2.15845866773152	20.9933950841805
-16.8128747191129	8.01642207213020	2.29168372097269
14.0164049860572	12.0898505200579	6.19411233773586
0.00462245548876461	17.4268423296657	3.46550498743487
-13.1368177072443	-14.6241238309460	4.54145611784816
NaN	NaN	NaN
3.13240809874509	-18.4642225971160	4.36769639812544
NaN	NaN	NaN
16.1242996640050	-8.70298336445797	5.45447035060678
4.80539840815086	14.9962648607360	14.1854170783994
NaN	NaN	NaN
-9.47335413073380	18.3272039797292	7.90284215314443
-20.7585982094875	1.87199531458561	7.67527614704669
20.4547412574092	5.61980979298467	9.33732251898120
-6.59922414985601	-20.3149197819155	10.4002147259244
NaN	NaN	NaN
-15.7582056606071	7.78933154518827	3.13008738301755
-10.6386873232721	-8.83131873299640	13.4422199430469
14.7900790473943	-8.97631581833030	5.27199063956830
3.65111490855044	14.1915945930287	14.1893275483861
-8.82703493030805	17.3582962554301	8.49224596857910
-20.2774931673641	1.85377171555111	6.38283923174221
-7.31874869753475	-19.4283115192963	9.65621149828923
-0.503351921657539	5.56832424157329	23.2694401160909
8.75835703162792	-6.79548462095931	16.7649535611451
10.9844722564136	9.98916609468592	8.30240939451848
-7.43915136981330	-10.7910533007941	12.4781449512280
-2.87513348838056	3.13229847465998	22.5979761956643
4.19359776957454	14.5112558158938	9.55904286059216
16.4120733574899	5.08185007111748	11.4683481060638
-17.8993398196900	-2.84237060507588	6.96600226948473
7.28820856007446	7.13744152210483	14.3409030105243
7.11328619212081	-10.0241883859651	6.08249768960803
-14.8948452892519	5.47562392156407	10.0280620908734
NaN	NaN	NaN
NaN	NaN	NaN
-17.6414609459457	8.57374770420015	2.34490969715619
14.5628303447710	12.9101044946189	6.36323579728967
0.236068705665117	18.3943786670750	3.56702379885394
-13.9675950902049	-15.1477313350790	4.73025262622873
-8.46351646228333	7.45082062889987	18.6992905886821
3.58992504142291	-19.3332031486778	4.55624625405279
-12.0692471403047	-10.3637906911440	14.4280178641330
16.9206035320915	-9.26423357755979	5.68007697276928
5.09966881897469	15.8025762257741	14.6985124963522
9.98852190876383	-9.90088471968374	17.7480004759850
-9.87026098628898	19.1683884261992	8.27009366781817
-21.6700513959356	1.99387503201625	8.06821179494925
NaN	NaN	NaN
-6.83970562112134	-21.1770885924228	10.8461223443459
-0.139800966186520	5.07106447953570	25.4180293480892
16.6066557368028	6.04688166946379	10.5564450732623
-16.675508

            

            
            
            

    

        

	
    

        
Best Answer
    

    

								

								
Use these lines
idx = any(isnan(D), 2);
E = D(~idx, :);
						    
						
		
    
        

    

Related Solutions
MATLAB: FFT code on time series

								

								
hi Sam,
in case you have verified the properties of the signal in the above comment,we can proceed as the following :
We have a signal of length L=3950 taken every 12 hours for 2563.5 days. So formally the sampling rate is Fs= 3950/2563 =~1.54 Hz .
For these types of times series , the range is dynamically changing therefore we plot the frequency in dB to expand the low values and compress the high ones :
1)Solution 1:
Fs=1.55; %  
L=length(Thermocline);
N=ceil(log2(L));
FFTherm=fft(Thermocline,2^N);
f=(Fs/2^N)*(0:2^(N-1)-1);
Power=FFTherm.*conj(FFTherm);
figure,
semilogy(f,Power(1:2^(N-1)))
xlabel('  Frequency (Hz)'), ylabel(' Magnitude (w)'),
title('  Power Spectral Density'), grid on;
2) Solution : 2
 % Directly you type in the C.P :
  psd(Thermocline)
So the frequency is in the range [0,...,0.1] Hz. To see if this result, physically, makes sens, try to check :
"Stochastic climate models, Part I1, Application to sea-surface temperature anomalies and thermocline variability" by CLAUDE FRA NKIG NOUL :
And another paper: "MEAN AND EDDY DYNAMICS OF THE MAIN THERMOCLINE" by GEOFFREY K. VALLIS
http://www.princeton.edu/~gkv/papers/thermocline.pdf
These two papers give a general idea on how much an estimate of the frequency must be .
I hope this helps .
KHMOU Youssef.
						    
						
MATLAB: How to do the following in a simpler and smarter way

								

								
C=repmat(1:21,12,1)
C=C(:)'
%or
C=1:21;
C=reshape(C(ones(12,1),:),1,[])
						    
						
        
        

            
            
            
Related Question
Consecutive combination of numbers from a list
How to measure an angle of peaks in a plot
Import Data From Text File and Analyse
Subtract two matrices each with NaN values in different cells
How to convert this into a 2d matrix of 50×50 in Matlab
How to rearrange data in matrix rows
        
    

Answer 1

Use these lines

idx = any(isnan(D), 2);
E = D(~idx, :);