Clear Filters
Clear Filters

Undefined operator './' for input arguments of type 'cell'.

2 views (last 30 days)
NN on 23 Apr 2021
Answered: Ronit on 23 Feb 2024
Hi , i am using the below command and getting the error:
date_num2 = datenum(testdates)+table2array(Data(1:end,2))./24;
Undefined operator './' for input arguments of type 'cell'.
please help
Md Abdur Rahman
Md Abdur Rahman on 23 Apr 2021
Try this:
date_num2 = datenum(testdates)+table2array{idx}(1:end,2)./24; % idx is index of Data in table2array cell
Scott MacKenzie
Scott MacKenzie on 23 Apr 2021
NN, you didn't say anything about the organization of the Data table. The problem, it seems to be, is that the 2nd column of the Data table likely contains text. The array2table function therefore produces a cell array of character strings. Hence the error message.
If the 2nd column of the Data table contains numeric data, the array2table function would yield a numeric vector and there would be no error message.

Sign in to comment.

Answers (1)

Ronit on 23 Feb 2024
I understand you're encountering an error due to the use of the element-wise division operator ‘./’ with a cell array in MATLAB.
As it is mentioned in the comments as well, this issue arises because MATLAB's ‘./’ operator is designed for numerical arrays and cannot be directly applied to cell arrays.
It seems like the problem maybe arising when you extract data from a table using table2array, particularly the column Data(1:end,2), it returns a cell array. If the cells within Data(:,2) contain numeric values, these must be converted into a numeric array format before you can perform any element-wise division
To resolve this, it's essential to work with numeric arrays for such arithmetic operations. You can use cell2mat to convert a cell array of numeric values to a numeric array.
Here’s how it can be resolved:
% First, convert the cell array to a numeric array if the cells contain numeric data.
if iscell(Data{:,2})
numericColumn = cell2mat(Data{:,2}); % Convert cells to numeric array
numericColumn = table2array(Data(:,2)); % If the data is already numeric, just convert to an array
% Now perform the division by 24 and add to the serial date numbers from 'datenum'
date_num2 = datenum(testdates) + numericColumn ./ 24;
Please refer to the following documentations for further details:
Hope this helps!


Find more on Dates and Time 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!