MATLAB: I have an excel file row=10,column=3, I want to show a text message if any of the column is zero

guimatlab gui

For example if column 1 is 0 then I want to show 'column one is zero'.

Best Answer

Will a column either contain all zeros or not? In other words is it possible to have some zeros in a column, but not all zeros?

If a column either contains all zeros or none, you can do

 X = ones(10,5);
 X(:,3) = 0;
 idx = find(~any(X,1)); 
 fprintf('Column %2d is zero.\n',idx)

Related Solutions

MATLAB: Replace column

% 2D example:
A = zeros(5)
A(:,3) = 1
% 3D example:
A = zeros(3,3,3)
A(:,2,:) = 1

MATLAB: New column

I think this does what you want:

Price = randi(10,20,1)
buy = [true;diff(Price)>=0];
idx = find(~diff(Price));
buy(idx+1) = buy(idx);
[Price,buy]

I'm using a logical array buy that is true for "buy" and false for "sell". You could use a nominal array (if you have Statistics Toolbox) to assign arbitrary labels (ie "buy" and "sell"), but logical probably does what you want the easiest.

EDIT: if you really want a column of strings (for output purposes), this will do it:

buysell = cellstr(repmat('Sell',size(Price)));
buysell(buy) = {'Buy'}

Best Answer

Related Solutions

MATLAB: Replace column

MATLAB: New column

Related Question