Help with table variables calculation

Question

Nina Perf 2022-5-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1715325-help-with-table-variables-calculation

编辑： Nina Perf 2022-5-14

采纳的回答： Clay Swackhamer

在 MATLAB Online 中打开

Hi,

I have a

table 'T'

with a column variable named 'rank', which includes categorical numbers: from 1 to 3.

I want to check if the 'rank' numbers are below or equal to 2. I do that with this:

i12 = (str2num(char(T.rank)) <= 2);

I need help with the following:

If i12 is True, then I want to reassign the rank to be '2'.

So, in the end, I have the variable 'rank' going from 2 to 3.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Rik 2022-5-10

编辑：Rik 2022-5-10

I recovered the removed content from the Google cache (something which anyone can do). Editing away your question is very rude. Someone spent time reading your question, understanding your issue, figuring out the solution, and writing an answer. Now you repay that kindness by ensuring that the next person with a similar question can't benefit from this answer.

This page is now on archived on the Wayback Machine.

请先登录，再进行评论。

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

Answer 1

Clay Swackhamer 2022-5-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1715325-help-with-table-variables-calculation#answer_960650

在 MATLAB Online 中打开

% Define the table
T = table;
T.rank = [1,3,2,4,2,5,1,3,2,4]';
T.rank = categorical(T.rank);
% Create another column to store the 2s
T.updatedRank = 2*ones(height(T),1);
T.updatedRank = categorical(T.updatedRank);
% Find values <= 2
ix = str2num(char(T.rank)) <= 2; % True for rank 1 and 2
% Replace values
T.rank(ix) = T.updatedRank(ix)
% Get rid of updated rank column (optional)
% T.updatedRank = [];