how to have a loop if for a column in a table
조회 수: 2 (최근 30일)
이전 댓글 표시
I have a table with many columns... I want to iterate into one column, that have many numbers valores. is there someone that can help me?
the pseudocode is
if table.column > number
table.new_column= 'Ok'
else
table.this_new column='nok'
finally i wil have a new columns with ok and nok depending of the valor of the column
댓글 수: 0
채택된 답변
Ameer Hamza
2018년 5월 14일
편집: Ameer Hamza
2018년 5월 14일
You don't need a for loop, use arrayfun(),
words = {'nok', 'ok'};
table.newColumn = arrayfun(@(x) words((x>number)+1), table.column);
댓글 수: 3
Ameer Hamza
2018년 5월 14일
It is not clear what you are trying to do but you can access and change values of a table just like a cell array using table{1,1} (first column, first element). Similarly, use can assign as
table{1,1} = 1; % it will assign the value
추가 답변 (1개)
Peter Perkins
2018년 5월 14일
Ameer's solution works, but arrayfun is really not needed:
words = {'nok', 'ok'};
table.newColumn = words(table.column>number)+1);
But also, a cell array of 'ok' and 'nok' is likely not all the helpful. I'd suggest making a categorical variable:
table.newColumn = categorical(table.column>number,[false,true],{'nok' 'ok});
Like Ameer, I'm not able to fully understand the followup question.
댓글 수: 2
Peter Perkins
2018년 5월 17일
I can't follow this. I suggest you open a new thread, with a short, clear example of what you have and what you want.
참고 항목
카테고리
Help Center 및 File Exchange에서 Line Plots에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!