transform column of inequality data??
2 ビュー (過去 30 日間)
古いコメントを表示
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/273999/image.png)
Dan
1 件のコメント
回答 (1 件)
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/275206/image.jpeg)
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Downloads についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!