MATLAB Answers

how to reshape the data ?

2 views (last 30 days)
pruth
pruth on 16 May 2018
Commented: Ameer Hamza on 16 May 2018
hi, I have created a mat file(attached). the first row contains headers which I don't need except a date
MRR 180417000005 UTC+0530 AVE 10 STP 200 ASL 450 SMP 125e3 SVS 6.0.0.8 DVS 6.10 DSN 0510076780 CC 2898660 MDQ 100 TYP PRO
here 180417000005 is the YYMMDDHHMMSS. the second row has height-H data and the third row has corresponding rain rate- RR to the height.after that next time scan and continue...
'H 200 400 600 800 .... 5000 5200 5400 5600 5800 6000 6200'
'RR 0.00 0.00 0.00 0.00 ...... 0.00 0.00 0.00 0.00 0.00 0.00 0.00'
I want to create another mat file, which will have the first column of date and time(in Matlab format), the second column will have rain rate at height 200, the third column will have rain rate at height 400. and so on.
  2 Comments
pruth
pruth on 16 May 2018
hi thank you for the reply. if the data is missing we can put NaN.

Sign in to comment.

Accepted Answer

Ameer Hamza
Ameer Hamza on 16 May 2018
The following will return the data in numeric form and store it in a table. Most rows of your table contain 31 column, whereas some rows contain less than 31, in that case, I have padded those rows with NaN at the end
t = char(data(1:3:end));
t = datetime(t(:, 5:16), 'InputFormat', 'yyMMddHHmmss');
rf = cellfun(@(x) str2num(x(3:end)), data(3:3:end), 'UniformOutput', 0);
rf = cellfun(@(x) [x nan(1, 31-numel(x))], rf, 'UniformOutput', 0);
rf = num2cell(cell2mat(rf), 1);
final = [table(t) table(rf{:})];
  2 Comments
Ameer Hamza
Ameer Hamza on 16 May 2018
Yes, it is also a MATLAB variable. Just save it in similar way
save('tableFile.mat', 'final')

Sign in to comment.

More Answers (1)

Matt J
Matt J on 16 May 2018
Edited: Matt J on 16 May 2018
This uses MAT2TILES (Download here).
Times=char(data(1:3:end));
Times=string( mat2tiles( Times(:,5:16),[1,2]) );
Times=cell2mat([compose('%s-', Times(:,1:5) ), Times(:,6) ]);
Times=datetime(Times,'InputFormat','yy-MM-dd-HH-mm-ss');
Rainfall=char( data(3:3:end) );
Rainfall=(Rainfall(:,3:end));
result=[char(Times), Rainfall];
  7 Comments
Ameer Hamza
Ameer Hamza on 16 May 2018
Just the lines
Time = char(data(1:3:end));
Time = datetime(Time(:, 5:16), 'InputFormat', 'yyMMddHHmmss');
work fine in R2018a. I am not sure about the previous version.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!