transform column of inequality data??

1 次查看（过去 30 天）
Daniel Hines
Daniel Hines 2020-2-27
回答： Prabhan Purwar 2020-3-5
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 个）

Prabhan Purwar
Prabhan Purwar 2020-3-5
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
Output:

类别

在 Help Center 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息

标签

尚未输入任何标签。

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by