How can I rearrange this matrix into new one?

Question

HyoJae Lee 2023-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900300-how-can-i-rearrange-this-matrix-into-new-one

评论： HyoJae Lee 2023-1-25

data=[50 67.5;
67.9;
75.4
75.9;
12.3;
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

fix the time
expand the value (starting value to end value every 0.1)

Finally, I want to make this kind of data,

data=[50 67.5;
67.6;
67.7;
67.8;
67.9;
75.4;
75.5;
75.6;
75.7;
75.8;
75.9;
12.3;
12.4;
12.5;
12.6;
12.7;
12.8;
12.9];

How can I make like this using loop?

Best,

HyoJae.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2023-1-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1900300-how-can-i-rearrange-this-matrix-into-new-one#answer_1155905

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

Askic V 2023-1-25

在 MATLAB Online 中打开

This is another approach:

data=[50 67.5;
    50 67.9;
    60 75.4
    60 75.9;
    70 12.3;
    70 12.9];
step = 0.1;
time_col = unique(data(:,1));
data_new = [];
for i = 1:numel(time_col)
    ind_i = find(data(:,1)==time_col(i));
    sec_column = data(ind_i(1),2):step:data(ind_i(end),2); 
    first_column = time_col(i)*ones(size(sec_column));
    data_new = [data_new; [first_column', sec_column']];
end
data_new
data_new = 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