Dot indexing not supportedd

10 views (last 30 days)
Farrah Vogel-Javeri
Farrah Vogel-Javeri on 10 Dec 2020
Edited: Jon on 10 Dec 2020
I am trying to write a function which converts all answers to a Likart survey to 1 and 0. The code itself works, but when I trz to run the function itself i get an error stating "Dot indexing is not supported for variables of this type.
Error in funclikart2 (line 5)
header = T.Properties.VariableNames; % keep table variable names"
This is my code:
function T = funclikart2(tabName, sheetnumber)
% check input data type if necessary
T = xlsread(tabName, sheetnumber);
header = T.Properties.VariableNames; % keep table variable names
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
Can anyone help me out?

Answers (1)

Jon
Jon on 10 Dec 2020
Edited: Jon on 10 Dec 2020
T = xlsread( ) returns an array of double values, not a table so T.xxx is not meaningful
I suggest using readtable instead.

Community Treasure Hunt

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

Start Hunting!