transform column of inequality data??

Question

Daniel Hines 2020-2-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/507943-transform-column-of-inequality-data

回答： Prabhan Purwar 2020-3-5

data_example.xlsx

Hello, I have a column of inequality data (see attached) that I am trying to transform into 3 new columns but I don't know the right syntax/formula. The first column containing the number values for all of the less than inequality data, the second column containing all of the data points that were reported as a number, and the third column containing all of the number values for the data points that were reported as greater than. I was thinking it would be some combination of using logicals and filter operators but I have been unsuccessful. What is the appropriate code to do this? Thank you for any help you can give me

Example:

Dan

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

darova 2020-2-27

在 MATLAB Online 中打开

Can you show yuor attempts? What about something like that

out3 = data > 32;

请先登录，再进行评论。

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

Answer 1

Prabhan Purwar 2020-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/507943-transform-column-of-inequality-data#answer_418639

在 MATLAB Online 中打开

Hi,

Kindly try using the following code:

clc
close all
clear
var=readcell('data_example (3)');  %Load data
tbl{1,1}=var{1,2};
tbl{1,2}=var{1,3};
tbl{1,3}=var{1,4};
for i=2:13
a=var{i,1};
tfg=strcmp(a(1),'>');           %String compare
tfs=strcmp(a(1),'<');
if(tfg==1) tbl{i,3}=a(2:end);
end
if(tfs==1) tbl{i,1}=a(2:end);
end
if (tfs==0 && tfg==0 ) tbl{i,2}=a(1:end);
end
tfs=0;tfg=0;
end