Create a new column in the table with conditional values ​​of 1 or 0

Hi,

I imported a spreadsheet from Excel to Matlab:

I need to create a new column where the condition evaluates from column G (Odstup_s_) so that all values ​​that are <= 5 will be 1 and the others will be 0

in excely it would look like: =IF(G2<5;1;0)

Thank you for help.

Answer 1

[Jonas]

you could use

LLT.newVar=LLT{:,6}<=5

or

LLT.newVar=LLT.Odstub_s_<=5;

but i cannot see the whole variable name

of course you could use an other name instead of newVar for the table variable name

[dpb]

And as a nicety, one could use addvars to locate the column position in which to add the new variable if would be more appropriate somewhere besides adding it to the RH side.

[Zuzana Pániková]

Thank you very much,it works great.