MATLAB: Loading the excel file(cell array contains elements of different dimension) in MATLAB

cell array inside excel to have matrix of different dimensionsMATLAB

Hey all,

I have an excel file, I need to load this excel file in MATLAB, but it is showing NaN for the position where a matrix is built.

Here is an example:

A = xlsread('Area_Matrix.xlsx');

A =

0 NaN 0 0 0 0 23

NaN 0 47 0 0 0 18

But here NaN should be a matrix like below;

[0 0 ; 0 23];

It is like building a cell array in excel to have a matrix of different dimensions.

I need to get the cell array from excel like below:

A = { 0 [ 0 4749.50 ;0 2375.80] 0 0 0 0 [0 0; 0 2375.8 ] ;

[ 0 4749.50 ;0 2375.80 ] 0 [0 0; 0 2375.8 ] 4749.50 0 0 [0 0; 0 1835.80 ];

0 [ 0 0 ; 0 2375.80] 0 0 0 0 0;

0 4749.50 0 0 2375.80 4749.50 [0 0; 0 1835.80 ];

0 0 0 2375.80 0 0 0;

0 0 0 4749.50 0 0 [0 0; 0 2375.8 ] ;

[0 0; 0 2375.8 ] [0 0; 0 1835.80 ] 0 [0 0; 0 1835.80 ] 0 [0 0; 0 2375.8 ] 0};

So I am planning to use excel to enter the data and load it later in MATLAB.

Any suggestions and answers would be most welcomed

Thanks in advance.

Best Answer

Try this:

[num,~,A] = xlsread('Area_Matrix.xlsx');
A(isnan(num)) = cellfun(@str2num,A(isnan(num)),'uni',0); %A is the cell array you want

Related Solutions

MATLAB: How to pass a Matrix of cell array as a input argument to a function

In order to pass elements 'individually at the same time' you need to use something like parfor, which requires the parallel computing tool box, which is not something that I have any knowledge of. Is there a specific reason you need the individual elements at the same time, and not just sequentially?

If you are looking at them sequentially, then your four for loops will work fine, just use the size command I mentioned earlier.

for i = 1:size(A,1) % Each row of cells
    for j = 1:size(A,2) % Each column of cells
        for k = 1:size(A{i,j},1) % Row of cell contents
            for m = 1:size(A{i,j},2) % Column of cell contents
                tmp = A{i,j}(k,m);
            end
        end
    end
end

MATLAB: Finding the percentage of NaN cells in columns

This does everything for all the tables in ‘C’:

D = load('C.mat');
C = D.C;
for k = 1:numel(C)
    C{k}(:,1:4) = fillmissing(C{k}(:,1:4),'nearest');                           % Fills Missing Data
    filename = C{k}{1,2};                                                       % Input Table Name
    fn{k,:} = sprintf('%s.xlsx',filename{:});                                   % Output File Name
    writetable(C{k},sprintf('%s.xlsx',filename{:}))                             % Write Each Table To Separate File
    rowlen{k,:} = size(C{k}(:,9:12),1);                                         % Row Lengtth Of Each Table
    NaN912{k,:} = [varfun(@isnan,C{k}(:,9:12))];                                % Number Of ‘NaN’ Values In Each Table
    PctNaN(k,:) = table2array(varfun(@(x)sum(x)./size(x,1),NaN912{k,:}));       % Percent ‘NaN’ Values In Selected Variables (Columns)
end
VarNms = compose('NAN in %s', string(C{1}.Properties.VariableNames(:,9:12)));   % Variable Names For ‘NaNPercent’ Table
filnam = cell2table(fn,'VariableNames',{'File name'});                          % File Names Table
NaNPercent = array2table(PctNaN, 'VariableNames',VarNms);                       % ‘PctNaN’ Initial Table
NaNPercent = [filnam NaNPercent];                                               % ‘PctNaN’ Final (Output) Table
FirstTen = NaNPercent(1:10,:)                                                   % Display Sample (Delete)

Producing:

FirstTen =
  10×5 table
           File name           NAN in tmax_m    NAN in tmin_m    NAN in rrr24    NAN in tm_m
    _______________________    _____________    _____________    ____________    ___________
    {'Abadan.xlsx'        }      0.088235           0.1299          0.13971         0.1152  
    {'Abadeh.xlsx'        }       0.10539          0.13235           0.1299        0.19118  
    {'Abali.xlsx'         }       0.12162          0.12162          0.15315        0.15766  
    {'Abumusa Island.xlsx'}        0.1464          0.14865          0.11486        0.16892  
    {'Ahar.xlsx'          }       0.21171           0.2027          0.21396        0.24099  
    {'Ahvaz.xlsx'         }      0.051471         0.058824         0.058824       0.056373  
    {'Aligudarz.xlsx'     }        0.1982          0.22523          0.23198        0.23874  
    {'Anar.xlsx'          }       0.22297          0.18919          0.19369        0.23649  
    {'Arak.xlsx'          }      0.068627         0.078431         0.088235       0.093137  
    {'Ardakan (Yazd).xlsx'}       0.21114          0.20882          0.34339         0.2065

The code retains the original data in ‘rowlen’ and ‘NaN912’ as well as the percent NaN results in the ‘NaNPercent’ table.

Best Answer

Related Solutions

MATLAB: How to pass a Matrix of cell array as a input argument to a function

MATLAB: Finding the percentage of NaN cells in columns

Related Question