清空筛选条件
清空筛选条件

how to reshape the data ?

1 次查看（过去 30 天）
pruth
pruth 2018-5-16
评论： Ameer Hamza 2018-5-16
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 个评论
Matt J
Matt J 2018-5-16
I don't know if it was intentional, but you have missing data in some of your RR rows. For example,
>> data{20118}
ans =
'RR 6.37 21.18 94.44
pruth
pruth 2018-5-16
hi thank you for the reply. if the data is missing we can put NaN.

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza
Ameer Hamza 2018-5-16
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 个评论
pruth
pruth 2018-5-16
thank you. it works !!!
just for curiosity !!! can we convert this table in mat file??
Ameer Hamza
Ameer Hamza 2018-5-16
Yes, it is also a MATLAB variable. Just save it in similar way
save('tableFile.mat', 'final')

请先登录，再进行评论。

更多回答（1 个）

Matt J
Matt J 2018-5-16
编辑：Matt J 2018-5-16
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 个评论
显示 5更早的评论
Matt J
Matt J 2018-5-16
编辑：Matt J 2018-5-16
You have to put the mfile somewhere MATLAB can see it - in your current folder where you are running code or somewhere in your matlab path.
Ameer Hamza
Ameer Hamza 2018-5-16
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by