How to replace rows contain NaN with values from another matrix?
    3 Ansichten (letzte 30 Tage)
  
       Ältere Kommentare anzeigen
    
    hanif hamden
 am 16 Mai 2019
  
    
    
    
    
    Kommentiert: hanif hamden
 am 16 Mai 2019
            A = [728140.500000000 	 1840.00 
728140.541666667 	 1780.00 
728140.583333333 	 NaN 
728140.625000000 	 NaN 
728140.666666667 	 NaN 
728140.708333333 	 NaN 
728140.750000000 	 NaN 
728140.791666667 	 NaN 
728140.833333333 	 NaN 
728140.875000000 	 NaN 
728140.916666667 	 NaN 
728140.958333333 	 NaN ]
B = [728140.500000000 	 1863.53 
728140.541666667 	 1830.47 
728140.583333333 	 1802.11 
728140.625000000 	 1782.74 
728140.666666667 	 1779.32 
728140.708333333 	 1803.74 
728140.750000000 	 1868.99 
728140.791666667 	 1981.78 
728140.833333333 	 2137.96 
728140.875000000 	 2318.80 
728140.916666667 	 2492.02 
728140.958333333 	 2621.85 ]
Above is the Matrix A and B where first column of both matrix has the same value.. I need to replace the NaN from matrix A with the values from Matrix B. can anyone help this? should i use ismember function as well?
0 Kommentare
Akzeptierte Antwort
  Alex Mcaulley
      
 am 16 Mai 2019
        A(isnan(A)) = B(isnan(A))
3 Kommentare
  Alex Mcaulley
      
 am 16 Mai 2019
				
      Bearbeitet: Alex Mcaulley
      
 am 16 Mai 2019
  
			Do you mean this?
idx = ~isnan(A(:,2));
A(~idx,2) = B(~idx,2);
A(idx,:) = [];
Weitere Antworten (0)
Siehe auch
Kategorien
				Mehr zu Resizing and Reshaping Matrices finden Sie in Help Center und File Exchange
			
	Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

