MATLAB: How to resize different matrices

helpMATLABmatrixmatrix manipulationmatrix of the same sizematrix reshapingmatrix sizenoobreshaping

Hello everyone!

I need help with this, I have my matrix (Number1 of size 103×18) and another text matrix (Text1 of size 152×18). Now these are files that I'm reading in matlab from excel and taking specific information that is in specifc locations.

Now, my problem is that when I'm trying to move forward I face matrices of size (104×18) for the Number values and (153×18) or even (144×18) for my text. There is either an extra empty row that I'd want to remove or add because I want my Number matrices to be of the size 103×18 and the text ones 152×18. So that the data would be in the same location for them all.

I have no idea how to fix this, I tried ismember, I tried to somehow find the index of the extra or missing row but I cant seem to move forward. I don't know how to approach it.

Your help would be truly appreciated.

Thank you in advance!!

Best Answer

The numbers and the strings will have different upper left locations in your variables. For example, if you have string row headers all along row 1, and file names going down column 1, and starting from B2 across and down you have all numbers, then you do

[numbers, strings, raw] = xlsread(filename);

strings will be taken starting from A1 across and down, while numbers will be taken from B2 across and down. So strings{1,1} will be cell A1 from the workbook, while numbers(1,1) will be from cell B2 of the workbook. Thus they don't align as you've seen.

The way to "fix" that and make sure if you put in a cell location it will be taken from the same location as in the workbook is to use the raw variable - the third output argument of xlsread.

Related Solutions

MATLAB: Reading excel files with texts in matlab

if true
[X,T,c] = xlsread ('file_name');
end

Try this.

MATLAB: How Find last row in excel

If you're comfortable with using ActiveX, here is function:

%-----------------------------------------------------------------------------
% Returns the next empty cell in column after row 1.  Basically it puts the active cell in row 1
% and types control-(down arrow) to put you in the last row.  Then it add 1 to get to the next available row.
function nextRow = GoToNextRowInColumn(Excel, column)
  try
    % Make a reference to the very last cell in this column.
    cellReference = sprintf('%s1048576', column);
    Excel.Range(cellReference).Select;
    currentCell = Excel.Selection;
    bottomCell = currentCell.End(3); % Control-up arrow.  We should be in row 1 now.
    % Well we're kind of in that row but not really until we select it.
    bottomRow = bottomCell.Row;
    cellReference = sprintf('%s%d', column, bottomRow);
    Excel.Range(cellReference).Select;
    bottomCell = Excel.Selection;
    bottomRow = bottomCell.Row;  % This should be 1
    % If this cell is empty, then it's the next row.
    % If this cell has something in it, then the next row is one row below it.
    cellContents = Excel.ActiveCell.Value;  % Get cell contents - the value (number of string that's in it).
    % If the cell is empty, cellContents will be a NaN.
    if isnan(cellContents)
  % Row 1 is empty.  Next row should be 1.
  nextRow = bottomRow;  % Don't add 1 since it was empty (the top row already).
    else
  % Row 1 is not empty.  Next row should be row 2.
  nextRow = bottomRow + 1;  % Will add 1 to get row 1 as the next row.
    end
  catch ME
    errorMessage = sprintf('Error in function GoToNextRowInColumn.\n\nError Message:\n%s', ME.message);
    fprintf('%s\n', errorMessage);
    WarnUser(errorMessage);
  end
  return; % from LeftAlignSheet
end % of GoToNextRowInColumn

Best Answer

Related Solutions

MATLAB: Reading excel files with texts in matlab

MATLAB: How Find last row in excel

Related Question