Reading and grouping data from file

1 visualización (últimos 30 días)
ZK
ZK el 30 de En. de 2013
Hi I have to read a data from the file. Readings from several hours, are saved in in this format:
TIME 00:00
A B C
0.25 90.000 774
0.48 116.554 2851
0.50 148.259 3094
0.60 175.225 4455
1.30 201.503 20916
1.40 205.942 24257
1.70 217.980 35767
1.80 221.841 40099
2.80 265.374 97030
2.95 278.601 107704
TIME 05:30
A B C
0.25 40.000 774
0.30 72.111 1114
0.70 145.267 6064
2.00 275.841 49505
3.10 292.110 118936
3.17 293.396 124368
TIME 12:00
A B C
0.25 40.000 774
0.30 92.111 1114
0.40 97.351 1980
0.50 110.000 3094
0.48 125.014 2851
0.50 137.337 3094
0.60 153.750 4455
I would like to read every part of data for every hour separately, and in the future group for every hour parameters A,B and C. I was trying in few ways but with no good effects
Thank You very much for Your time.
  3 comentarios
ZK
ZK el 30 de En. de 2013
Output can be quite unrestricted, as easier to propose a solution.
But as I think It will be good as cells.
The final output for me, that I can use in other calcutions is with the easiest access to parameters A B C in every TIME.
So maybe example of output for Time 05:30:
0530 =
{0.25} { 40.000} { 774}
{0.30} { 72.111} { 1114}
{0.70} {145.267} { 6064}
{2.00} {275.841} { 49505}
{3.10} {292.110} {118936}
{3.17} {293.396} {124368}
per isakson
per isakson el 30 de En. de 2013
Editada: per isakson el 30 de En. de 2013
There are two reasons to put each block of numerical values in a double array and each array in a cell of a cell array
  • saves on memory (a lot)
  • makes faster code possible
result( block_number ) = ...
{[0.25 40.000 774
0.30 92.111 1114
0.40 97.351 1980
0.50 110.000 3094
0.48 125.014 2851
0.50 137.337 3094
0.60 153.750 4455]}

Iniciar sesión para comentar.

Respuesta aceptada

per isakson
per isakson el 30 de En. de 2013
Editada: per isakson el 31 de En. de 2013
Hint:
  • read the file and find the row numbers of "TIME": ixt
  • read the file a second time one block at a time controlled by ixt
  • the second time the file is in the file cache and reading is fast
function M = Answer( )
fid = fopen( 'cssm.txt', 'r' );
cac = textscan( fid, '%s', 'Delimiter', '\n' );
sts = fclose( fid );
ixt = find( strncmp( 'TIME', cac{1}, 4 ) );
end
  1 comentario
ZK
ZK el 31 de En. de 2013
Editada: ZK el 31 de En. de 2013
Thank You very much for Your help. I used Your hints + I wrote one loop with deleting first digit from ixt, and reading next data. Best regards. ZK

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Low-Level File I/O en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by