How can I combine values from different columns of a matrix into one single column?
2 次查看(过去 30 天)
显示 更早的评论
Hello,
I have a matrix with three columns and many rows. The first column is the count. There are values in some sections of the second and third columns that I am not interested in. However, they do not overlap. There is no single row for which I want to extract values of both columns. I want to combine the values I am interested in in one single column, either a new column or in one of those two columns.Initially, I assigned NaN to those cells that I am not interested and then I was trying to use a loop but I am new to Matlab so it does not work. Any help will be very much appreciated. Trying to this manually in Excel takes a long time! Thanks!
0 个评论
采纳的回答
Leah
2013-3-8
it would be helpful to see you code so far, but i think this is what you need. A is your original matrix (nx3)
Anew=A(:,2);
index1=isnan(Anew);
Anew(index1,1)= A(index1,3)
you could do this quickly in Excel by using an "if" statement
=IF(ISNA(B1),C1,B1)
更多回答(2 个)
Matt J
2013-3-8
Index the rows of column 3 that you want and then do a vectorized assignment. If A is your matrix and keeprows are the rows of column 3 that you want to keep,
newcol=A(:,2);
newcol(keeprows)=A(keeprows,3);
Azzi Abdelmalek
2013-3-8
编辑:Azzi Abdelmalek
2013-3-8
EDIT
A=[1 4 6;2 nan 14;3 25 nan;4 78 77]
B=A
idx2=find(isnan(A(:,2)))
idx3=find(isnan(A(:,3)))
B(idx2,2)=A(idx2,3)
B(idx3,3)=A(idx3,2)
2 个评论
Azzi Abdelmalek
2013-3-8
编辑:Azzi Abdelmalek
2013-3-8
But the problem is, when values in col2 and col3 are not nan, which one will you choose?
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!