Create new variable using if function from existing array variables

2 次查看(过去 30 天)
Hi,
I have a table 'PMIdata' with 3 columns; 1st column is the date (monthly), 2nd column is a numeric value 'PMInum' corresponding to that date (economic growth) and 3rd column is a moving average of the second column 'PMIave' (so again numeric). I would like to add a fourth column 'AboveMA' to the table that specifies whether for each element in the 2nd column if it is greater than the corresponding element in the 3rd column, i.e. a binary variable of 0 or 1 indicating if the value is greater than its moving average (for all given dates).
I think this should be done using an 'IF' statement but I'm not sure of the syntax to navigate through the arrays and how to append this fourth column to the table.
Any help would be appreciated.
Thanks!

回答(1 个)

Alex Mcaulley
Alex Mcaulley 2019-7-30
Try this:
PMIdata.AboveMA = PMIdata.PMInum > PMIdata.PMIave;

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

产品


版本

R2017b

Community Treasure Hunt

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

Start Hunting!

Translated by