MATLAB: Remove empty cells and values for correlations

correlationempty cellMATLAB

Hi,

I have a 32×2 cell and I would like to do a correlation for the values in the first column with the values in the second column. However, there are blank cells in the first column. Could anyone help me find a way to do a correlation that excludes all the blank cells and their corresponding values in the second column?

Thanks!

Best Answer

Does this do what you want?

CData = {45 20;  16 32;  [] 10;  17 6};
CE = cellfun(@isempty, CData(:,1));
Data = cell2mat(CData(~CE,:));
[R, P] = corrcoef(Data)

Related Solutions

MATLAB: Putting certain blocks of numeric array data into its own cell each in a cell array. – tried num2cell and an index method to do this…

A = rand(1364, 16);
B = reshape(A, 11, 1364/11, 16);
B = permute(B, [1, 3, 2]);
C = num2cell(B, [1, 2]);
C = C(:);

But inside NUM2CELL you have a FOR loop also, so it might be more efficient to write it explicitely:

C = cell(124, 1);  % Pre-allocate
B = reshape(A, 11, 1364/11, 16);
for iC = 1:numel(C)
  C{iC} = reshape(B(:, iC, :), 11, 16);
end

MATLAB: Replace elements of a cell

testcell={'R1(2)' 'R1(1)' 'R1(0)'};
vfinal = cell(4,10);
vfinal(1,1:3) = testcell

Best Answer

Related Solutions

MATLAB: Putting certain blocks of numeric array data into its own cell each in a cell array. – tried num2cell and an index method to do this…

MATLAB: Replace elements of a cell

Related Question