MATLAB: Erase row from a cell-array

cellerasefirst

I have the following cell variable with 10000 rows:

 A={ 'x'  'start1'  'end1'
  12  1997   2000
  13  1997   1999
  16  1997   2002 }

And I would like to delete the first row. I tried the following code:

A(cell2mat(A(1,:)))=[];

but it returns the values all in one row, instead of the way theu were originally disposed.

Cna someone help me? Thanks

Best Answer

A(1,:)=[]

Related Solutions

MATLAB: Fill Cell-Array Columns with vectors

Since you're using R2016a, why aren't you using readtable instead of the archaic xlsread? This will read your numeric columns as numeric and text ones as text (and if you were on R2016b or later, you could even tell readtable how to parse each column if it doesn't do it right).

Otherwise, your problem is that you need to convert the numeric column you want to insert in the cell into a cell array itself. You use num2cell for that:

[num,txt,raw] = xlsread(filename);  
GivenData= cell(size(raw));  %simpler syntax than what you were using
GivenData(:, 3) = num2cell(num(:, 3));  %for example

But really, consider using readtable which is a lot more powerful and easier to work with than xlsread.

MATLAB: Select values in a cell 2105×1 cell or 1×2105 cell

You do not have "a matrix column of 2 vectors but in 1 cell." Please see the description of a cell in the FAQ: https://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F

What you describe is a cell ARRAY (actually a row vector of 2105 cells), not a single cell. And you do not have "a matrix column of 2 vectors", what you have, more precisely, is a column vector of two scalars in each cell of the cell array.

You can use cell2mat() followed by an extraction of each row and transpose with the apostrophe operator:

for row = 1 : 2105
  ca{row} = randi(99, 2, 1);  Create random data.
end
whos ca
% Now we have our cell array and can begin.
m = cell2mat(ca) % Convert from cell array to a single double array, 2 rows-by-2105 columns.
% Get the first values as a column vector.
firstValues = m(1,:)';  % Make sure you transpose the first row to get a column vector.
% Get the second values as a column vector.
secondValues = m(2,:)';  % Make sure you transpose the second row to get a column vector

This will get you the column vectors you think you need/want.

Best Answer

Related Solutions

MATLAB: Fill Cell-Array Columns with vectors

MATLAB: Select values in a cell 2105×1 cell or 1×2105 cell

Related Question