Dot indexing not supportedd

조회 수: 9 (최근 30일)
Farrah Vogel-Javeri
Farrah Vogel-Javeri 2020년 12월 10일
편집: Jon 2020년 12월 10일
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?

답변 (1개)

Jon
Jon 2020년 12월 10일
편집: Jon 2020년 12월 10일
T = xlsread( ) returns an array of double values, not a table so T.xxx is not meaningful
I suggest using readtable instead.

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by