how to view changed matrix

1 次查看（过去 30 天）

显示更早的评论

Chandini Govind 2019-10-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/483429-how-to-view-changed-matrix

评论： Deepak Kumar 2019-10-9

在 MATLAB Online 中打开

hi,

i have attached a code below

clc
clear
[~,~,A]=xlsread('duplicateset1.xls');
%A(isnan(A))=-1;
cellfun(@isnan,A,'UniformOutput',false)%to remove NaN from array
[m,n]=size(A);
B=A;
%change Y/N to 0/1
for i=1:n
    if isequal(A{i},'Y')||isequal(A{i},'M')
        B(:,i)=1;
    elseif isequal(A{i},'N')||isequal(A{i},'F')
        B(:,i)=0;
    elseif isequal(A{i},'U')||isequal(A{i},'H')
        B(:,i)=2;
    elseif isequal(A{i},'C')||isequal(A{i},'D')||isequal(A{i},'L')
        B(:,i)=-1;
    end
 end
B(1:10,3)

i want the B matix to be of 1's and 0's instead of yes and no, but what i get is the intial matrix. the other chararcter represent male/female/high/low etc

6 个评论
显示 4更早的评论隐藏 4更早的评论

Chandini Govind 2019-10-6

decisionattri.xlsx

ok,i have uploaded the input file

Deepak Kumar 2019-10-9

I'm assuming that you are trying to read decisionattri.xlsx file.

You are not capturing the values returned by cellfun in a variable (e.g. z=cellfun(@isnan,A,'UniformOutput',false)). So, the values returned by cellfun is lost and A remains unaffected and retains it's original values. That is why you are getting the original values of A. Moreover, please go through the documentation of isnan command (https://www.mathworks.com/help/matlab/ref/isnan.html ) to understand it's usage.

请先登录，再进行评论。

请先登录，再回答此问题。