# Undefined function 'log' for input arguments of type 'table'.

36 views (last 30 days)
Erik Öhrner on 21 Apr 2017
Commented: Erik Öhrner on 24 Apr 2017
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 CommentsShowHide 1 older comment
Erik Öhrner on 24 Apr 2017
Yes, the problem was that I needed the Excel data to be in Numeric format and when I changed that it worked. Thanks for answering.

Eng. Fredius Magige on 21 Apr 2017
Hi try: log10 it should work
Erik Öhrner on 21 Apr 2017
Thanks for answering so quick, but same outcome however.

Eng. Fredius Magige on 21 Apr 2017
Hi Why not try: Ln_P=log10(Price);
Ln_X=log10(X);

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.

### Categories

Find more on Logical 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!