I need some help to formatting a data file in matlab.

I need help formatting a data file in matlab. It is for my college research. The file has the pattern below.

[ No ] [ Temp ] 
1     1      01:00:00
1  20.00  
2  20.00  
3  20.00  
4  20.00  
5  20.00  
1     1      02:00:00
1  20.00  
2  20.00  
3  20.00  
4  20.00  
5  20.00 
....

I would like to know how to store the data this way:

Time        No1     No2     No3 ...
00:00:00    20.00   20.00   20.00 (here is the temp in each "no")
01:00:00    20.00   20.00   20.00 (the temp is changing by the time, but it is just an example)
02:00:00    20.00   20.00   20.00

If someone knows how to do this, please help me. My contact is [e-mail] Thank you

[Walter Roberson]

Is the number of entries after each time line always the same?

[Bruno Souza]

No, after some time it's changes like 19.8, 19.5,18.5...

[Walter Roberson]

I do not mean the value of he entries.

You have

1     1      01:00:00
1  20.00  
2  20.00  
3  20.00  
4  20.00  
5  20.00  
1     1      02:00:00

which has a line with a time, and then exactly 5 entries without a time, and then back to a line with a time. The next section shows exactly 5 entries after the line with the time as well. Is that 5 constant? Will there ever be cases like,

1     1      01:00:00
1  20.00  
2  20.00  
3  20.00  
4  20.00  
5  20.00  
6  20.00

for example?

If the number after the line with the time is not always 5 lines, then is it the consistent within any one file?

[Bruno Souza]

Sorry, is always 5! 5 is the number of "NÓ" (in Portuguese means "dot") and the data show the temperature in each dot by hour

Answer 1

[Walter Roberson]

fid = fopen('YourFileName.txt', 'rt');
fgetl(fid);   %ignore the header
counter = 0;
while true
  timeline = fgetl(fid);
  if ~ischar(timeline); break; end    %reached end of file
  hms = sscanf(timeline, '%*d%*d%d:%d:%d');
  counter = counter + 1;
  Time(counter) = duration(hms(1), hms(2), hms(3));
  No(counter, :) = cell2mat( textscan(fid, '%*f%f', 5) );
end
fclose(fid);

Then,

T = array2timetable(No, 'RowTimes', Time, 'VariableNames', {'No1', 'No2', 'No3', 'No4', 'No5'});

or

T = cell2table( [num2cell(Time), num2cell(No)], 'VariableNames', {'Time', 'No1', 'No2', 'No3', 'No4', 'No5'});

[Bruno Souza]

Thanks you Walter! It is help a lot!

Just one question, the variable T was as in attachment 1. Is it possible to store the other values so that it stays as an attachment 2? I have a total of 31 days, so It's 31 x 24 hours.

[Walter Roberson]

It should have stored all of the hours. However, you have not indicated any way to distinguish between the days in the input, and your output appears to show one row per hour with 5 columns per hour, so it is not clear what you would like the 31 x 24 to consist of ?

[Bruno Souza]

Did you see the attachment 2? I'll put the data in annex too. So, in this data I will have the temperature of the 5 points in day 1, in hour 1, hour2, ... until the hour 24. Than the score will restart, so it will be day 2, hour 1, hour 2, ... until day 31.

[Walter Roberson]

Each hour is 1 x 5. 24 hours in one day would be 24 x 5. 31 days would have to be one of:

24 x (31*5)
(24*31) x 5
31 x 24 x 5
24 x 31 x 5
24 x 5 x 31

which of those are you expecting?

[Bruno Souza]

Walter,

Sorry for my explanation, my English is not very good.

I just need the variable to contain the information this way:

    [ No ]  
          1  2  3  4  5
01:00:00      20.0  20.0  20.0  20.0  20.0
02:00:00      20.0  20.0  20.0  20.0  20.0
03:00:00      20.0  20.0  20.0  20.0  20.0
....          ...  ...  ....

[Walter Roberson]

Where should the 01:00:00 for the next day go?

[Bruno Souza]

after the 24:00:00 of first day

[Walter Roberson]

Here is a corrected version of the code:

fid = fopen('data.txt', 'rt');
fgetl(fid);   %ignore the header
counter = 0;
while true
  timeline = fgetl(fid);
  if ~ischar(timeline); break; end    %reached end of file
  hms = sscanf(timeline, '%*d%*d%d:%d:%d');
  counter = counter + 1;
  Time(counter) = duration(hms(1), hms(2), hms(3));
  No(counter, :) = cell2mat( textscan(fid, '%*f%f', 5) );
  fgetl(fid);    %end of 5th line of group -- textscan stops reading mid line
  fgetl(fid);    %blank line after group
end
fclose(fid);

T = cell2table( [num2cell(Time(:)), num2cell(No)], 'VariableNames', {'Time', 'No1', 'No2', 'No3', 'No4', 'No5'});

[Bruno Souza]

yes! thank you!!!

[Bruno Souza]

If I need to put this table T in a file, How can I do this? (I had to edit and plus more colums, so now It has No1.. until No21. I'll need to join this table with another data later. One file (FileA) is a matrix [744x2] from number one until number 744, and I'll put It in the first colum like "Hora". The other file (FileB) is the Clima, It is a matrix [744x2] too, but are random values. It will be like that:

Hora      No1  No2 No3 ... No21  Clima      
1         ...  ... ...           20.05 
2         ...                    25.04
3         ...                    ...
..        ...                    ...
744       ...                    21.09