清空筛选条件
清空筛选条件

How can I combine values from different columns of a matrix into one single column?

2 次查看（过去 30 天）
Kemal
Kemal 2013-3-8
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!

请先登录，再回答此问题。

采纳的回答

Leah
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
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);
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

Azzi Abdelmalek
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)

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by