How do I create dummy variables with if statements?
Show older comments
I have a dataset with excess return, R, which consists of 10 000 rows and 1 column.
I want to create a new variable X that takes the value of 1 for each row in R if R>0 for all rows in R. And it takes the value of 0 if R<0.
Probably a simple question, but couldnt find any other answers out there that worked for me.
Answers (1)
madhan ravi
on 6 Nov 2020
Edited: madhan ravi
on 6 Nov 2020
X = R > 0
5 Comments
Walter Roberson
on 6 Nov 2020
X = nan(size(R));
X(R > 0) = 1;
X(R < 0) = 0;
The nan is needed because the user did not define the result for R == 0 exactly.
madhan ravi
on 6 Nov 2020
Thank you sir Walter
Tobias M
on 6 Nov 2020
Tobias M
on 6 Nov 2020
madhan ravi
on 6 Nov 2020
So I won't "predict" anything.
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!