Dot indexing not supportedd

5 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.

Categories

Find more on Cell Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!