Undefined function 'log' for input arguments of type 'table'.
3 views (last 30 days)
Show older comments
I'm trying to import Excel sheets into Matlab and then performing log function on them but always get "Undefined function 'log' for input arguments of type 'table'.". Its a fresh install of Matlab and I have just started working with the software.
So, I have two sheets which I just renamed to X and Price and then type the following: Ln_P=log(Price);
And I also tried with the other one Ln_X=log(X);
Still same errors.
2 Comments
Adam
on 21 Apr 2017
Your data is in a table object. As the error says, the log function does not accept 'table' types. If your data is purely numeric then just load it into a regular array. Otherwise look at
and the section on 'Applying Functions to Table Contents'
Answers (3)
Steven Lord
on 21 Apr 2017
Tables can contain data of any type. Operate on just the variable(s) that contain numeric data. There are several ways to do this:
% Sample table
T = table(categorical({'M';'F';'M'}),[45;32;34],...
{'NY';'CA';'MA'},logical([1;0;0]),...
'VariableNames',{'Gender' 'Age' 'State' 'Vote'})
% Extract the variable by name
meanAge = mean(T.Age);
% Extract the variable by variable number
didAllVote = all(T{:, 4}) % the Vote variable
% Extract the variable by type
oldest = max(T{:, vartype('double')})
For more techniques you can use to work with data in a table, see the "Access Data in a Table" and "Calculations on Tables" section of the documentation for table.
Personally, where possibly I try to use the syntax involving the name of the variable -- that's independent of the order of the variables in the table and usually the most self-documenting option. When you see meanAge = mean(T.Age); in a block of code, you can understand the purpose of that code pretty quickly.
0 Comments
See Also
Categories
Find more on Time Series Collections in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!