merge two columns into one, Part 2

1 Ansicht (letzte 30 Tage)
alpedhuez
alpedhuez am 11 Jun. 2020
Kommentiert: alpedhuez am 11 Jun. 2020
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.

Akzeptierte Antwort

madhan ravi
madhan ravi am 11 Jun. 2020
Bearbeitet: madhan ravi am 11 Jun. 2020
nansum([A, B],2)
%or
sum([A, B],2,'omitnan')
  5 Kommentare
madhan ravi
madhan ravi am 11 Jun. 2020
Yes
alpedhuez
alpedhuez am 11 Jun. 2020
thank you.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Produkte


Version

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by