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

6 次查看（过去 30 天）

显示更早的评论

Zuzana Pániková 2022-5-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724765-create-a-new-column-in-the-table-with-conditional-values-of-1-or-0

评论： Zuzana Pániková 2022-5-23

采纳的回答： Jonas

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Jonas 2022-5-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1724765-create-a-new-column-in-the-table-with-conditional-values-of-1-or-0#answer_969225

编辑：Jonas 2022-5-22

在 MATLAB Online 中打开

you could use

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

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

2 个评论
显示无隐藏无

dpb 2022-5-22

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á 2022-5-23

Thank you very much,it works great.

请先登录，再进行评论。

类别

Reporting and Database Access Database Toolbox

Computational Finance Database Toolbox

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

产品

MATLAB

版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by