Applying a function across all columns of a table

Question

Farrah Vogel-Javeri 2020-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/684893-applying-a-function-across-all-columns-of-a-table

评论： Farrah Vogel-Javeri 2020-12-8

T = readtable('agree'); %%name of table
T.Q1(strcmpi(T.Q1,'Agree')) = {1}; %% change all results in column called Q1 to 1 if agree appears
T.Q1(strcmpi(T.Q1,'Strongly Agree')) = {1}; %% change all results in column called Q1 to 1 if strongly agree appears
T.Q1(strcmpi(T.Q1,'Disagree')) = {0}; %% change all results in column called Q1 to 0 if disagree appears
T.Q1(strcmpi(T.Q1,'Neither Agree Nor Disagree')) = {0};%% change all results in column called Q1 to 0 if neither agree nor disagree appears
T.Q1(strcmpi(T.Q1,'Strongly Disagree')) = {0}; %% change all results in column called Q1 to 0 if strongly disagree appears
T.Q1(strcmpi(T.Q1,"Don't know")) = {0} %% change all results in column called Q1 to 0 if Don't know appears

I have a table of 40 columns which has data from a survey based on a 5 point Likert scale. I want to change the results to binary results, where strongly agree and agree are represented by 1 and everything else is represented by 0. The code above achieves this, but I want to make it into a function which runs it for the whole table and doesnt require me to change the name of the column each time. Could anyone help?

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

请先登录，再进行评论。

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

Answer 1

Ive J 2020-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/684893-applying-a-function-across-all-columns-of-a-table#answer_568123

编辑：Ive J 2020-12-7

在 MATLAB Online 中打开

Working with strings/cell is easier.

T = readtable('agree');
header = T.Properties.VariableNames; % keep table variable names
T = string(T{:, :}); % convert to string
yesIdx = ismember(T, {'Agree', 'Strongly Agree'}); % index of YES answers
T(yesIdx) = 1; T(~yesIdx) = 0; % assign 1/0 values
T = array2table(T, 'VariableNames', header); % convert back to table 

I also notice strcmpi in your example above. If you are looking for case insensitive situations, you can further change 4th line to:

yesIdx = ismember(lower(T), {'agree', 'strongly agree'}); % index of YES answers

5 个评论
显示 3更早的评论隐藏 3更早的评论

Ive J 2020-12-7

编辑：Ive J 2020-12-7

在 MATLAB Online 中打开

Yep, just copy them into a simple function:

function T = char2numAnswerSheet(tabName)
% check input data type if necessary
% blah blah blah
T = readtable(tabName);
header = T.Properties.VariableNames; % keep table variable names
T = string(T{:, :}); % convert to string
yesIdx = ismember(lower(T), {'agree', 'strongly agree'}); % index of YES answers
T(yesIdx) = 1; T(~yesIdx) = 0; % assign 1/0 values
T = array2table(T, 'VariableNames', header); % convert back to table 
end % END

Farrah Vogel-Javeri 2020-12-8

That's fantastic thanks! Do you know how I'd go about adapting the code to be able to cope with an array of data that also has dates and time in it? Could I somehow build it so that it returns the other cploumns with non-likart data as is, but just change the likart data?

请先登录，再进行评论。

Answer 2

Ameer Hamza 2020-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/684893-applying-a-function-across-all-columns-of-a-table#answer_568098

在 MATLAB Online 中打开

See varfun(): https://www.mathworks.com/help/matlab/ref/varfun.html.

Convert your code into a function like this

function y = myFunc(x)
    x(strcmpi(x,'Agree')) = {1}; %% change all results in column called Q1 to 1 if agree appears
    x(strcmpi(x,'Strongly Agree')) = {1}; %% change all results in column called Q1 to 1 if strongly agree appears
    x(strcmpi(x,'Disagree')) = {0}; %% change all results in column called Q1 to 0 if disagree appears
    x(strcmpi(x,'Neither Agree Nor Disagree')) = {0};%% change all results in column called Q1 to 0 if neither agree nor disagree appears
    x(strcmpi(x,'Strongly Disagree')) = {0}; %% change all results in column called Q1 to 0 if strongly disagree appears
    x(strcmpi(x,"Don't know")) = {0} %% change all results in column called Q1 to 0 if Don't know appears
end

and then try this

T;
T_new = varfun(@myFunc, T)

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

Farrah Vogel-Javeri 2020-12-7

Thanks so much! I'm still very new to matlab, so could you explain the last part of the code to me please? When should I call the function to input which column it needds to look at?

请先登录，再进行评论。