How can I rearrange this matrix into new one?

1 view (last 30 days)
HyoJae Lee on 25 Jan 2023
Commented: HyoJae Lee on 25 Jan 2023
data=[50 67.5;
50 67.9;
60 75.4
60 75.9;
70 12.3;
70 12.9];
Hello, this is a data what I want to rearrage into new one.
First column of the data is time, and second is value.
This matrix is sepearated every two rows, first is starting value and second is end value.
I want to rearrage into
1. fix the time
2. expand the value (starting value to end value every 0.1)
Finally, I want to make this kind of data,
data=[50 67.5;
50 67.6;
50 67.7;
50 67.8;
50 67.9;
60 75.4;
60 75.5;
60 75.6;
60 75.7;
60 75.8;
60 75.9;
70 12.3;
70 12.4;
70 12.5;
70 12.6;
70 12.7;
70 12.8;
70 12.9];
How can I make like this using loop?
Best,
HyoJae.

Dyuman Joshi on 25 Jan 2023
Assuming data is homogenous (In pairs throught-out), and end value is greater than or equal to first value.
data=[50 67.5;
50 67.9;
60 75.4
60 75.9;
70 12.3;
70 12.9];
row=size(data,1)/2;
%using cell array to store generated arrays
out=cell(row,1);
for i=1:row
y=(data(2*i-1,2):0.1:data(2*i,2))';
out{i}=[repelem(data(2*i-1,1),numel(y),1) y];
end
cell2mat(out)
ans = 18×2
50.0000 67.5000 50.0000 67.6000 50.0000 67.7000 50.0000 67.8000 50.0000 67.9000 60.0000 75.4000 60.0000 75.5000 60.0000 75.6000 60.0000 75.7000 60.0000 75.8000
2 CommentsShow 1 older commentHide 1 older comment
HyoJae Lee on 25 Jan 2023
This is actually what I want.
Appreciated!