Output with specific critiria in data ?

1 次查看（过去 30 天）
Ivan Mich
Ivan Mich 2021-2-7
评论： Walter Roberson 2021-7-8
I am having a txt file with 4 columns. I would like to get a new file with spesific critiria, depending on the limits of values of 1st and 2nd columns. I would like my first column to have values ranging from a (minimum value) to b (maximum value). Also I would like my 2nd column to gave values ranging from c (minimum value) to d (maximum value). After that I want to get a file that would have all the rows that will have a<1st column values<b & c<2nd column values<d.
I am uploading a file as an example. (For example I would like to include values that:
2<1st column<18
30<2nd column<100)
Could you help me?
Thank you in advance
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2021-2-20
selected = [num2cell(d1(mask,:)), tex(mask,:)];
writecell(selected, 'OutputFile.xlsx');
Ivan Mich
Ivan Mich 2021-2-21
Excuse me but in my output file , only the tex are shown! The data (I mean numbers) are not shown. Specifically NaN is shown.
Could you help me to fix it?

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2021-2-21
%need some numbers to test with
a = 3; b = 20;
c = 5; d = 100;
%okay, do the work
filename1 = 'big.txt'; %arxeio me makroseismika
T = readtable(filename1, 'readvariablenames', false);
n = T{:,4};
m = T{:,5};
%a, b are numbers
mask = a<n & n<b & c<m & m<d;
selected = T(mask,:);
writetable(selected, 'OutputFile.xlsx', 'writevariablenames', false);
  4 个评论
显示 2更早的评论
Ivan Mich
Ivan Mich 2021-7-8
Excuse me, I use the following code and for some reason I get this message
clc
clear
filename2= 'all_.xlsx'
d2=readtable(filename2,'readvariablenames', false);
Number_of_OBS=d2{2:end,27};
maskk = Number_of_OBS>1
selected = d2(maskk,:);
writetable(selected, 'OutputFile1_FROM1.xlsx', 'writevariablenames', false);
Undefined operator '>' for input arguments of type 'cell'.
Could you please help me?
Walter Roberson
Walter Roberson 2021-7-8
That suggests that your 27th column was read in as text rather than as numeric.
You did not happen to mention your release, and you did not post a sample all_.xlsx file for us to test with.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 MATLAB Report Generator 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by