Output with specific critiria in data ?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Ivan Mich
el 7 de Feb. de 2021
Comentada: Walter Roberson
el 8 de Jul. de 2021
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 comentarios
Walter Roberson
el 20 de Feb. de 2021
selected = [num2cell(d1(mask,:)), tex(mask,:)];
writecell(selected, 'OutputFile.xlsx');
Respuesta aceptada
Walter Roberson
el 21 de Feb. de 2021
%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 comentarios
Walter Roberson
el 8 de Jul. de 2021
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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Variables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!