merge two columns into one, Part 2

1 次查看（过去 30 天）
alpedhuez
alpedhuez 2020-6-11
评论： alpedhuez 2020-6-11
I have a speadsheet with column A and B look like
A B
NaN 1
1 NaN
2 NaN
NaN 3
Then I want to create a column C
c
1
1
2
3
That is, the value of column C is the value of A if A is nonempty and the value of B if A is empty. Please advise.

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

采纳的回答

madhan ravi
madhan ravi 2020-6-11
编辑：madhan ravi 2020-6-11
nansum([A, B],2)
%or
sum([A, B],2,'omitnan')
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by