Generating sequences from data

1 次查看（过去 30 天）
Mahendran Subramanian
评论： Mahendran Subramanian 2019-9-26
Hi All,
I have a data set (x1, x2, x3, x4, x5, x6, x7, .... xn) from which I want to generate sequences like
x1, x2, x3, x4, x5
x2, x3, x4, x5, x6
x3, x4, x5, x6, x7
x4, x5, x6, x7, x8
..................... xn
Thank you

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2019-9-26
xy = [5 14
6 16
1 16
6 11
4 16
1 16
2 13];
n = 5;
[m,k] = size(xy);
out = xy(reshape(hankel(1:n,n:m),1,n,[]) + m*(0:k-1)')
  5 个评论
显示 3更早的评论
Andrei Bobrov
Andrei Bobrov 2019-9-26
XY = readtable('XY.xlsx');
xy = XY{:,:};
n = 5;
[m,k] = size(xy);
out = xy(reshape(hankel(1:n,n:m),1,n,[]) + m*(0:k-1)');

请先登录，再进行评论。

更多回答（2 个）

John D'Errico
John D'Errico 2019-9-25
So, given a vector x, of length n, you want to create the array with rows that are the sub-sequences of length 5? The result will be a (n-4) x 5 array.
A trivial solution would just concatenate columns to create the array. However, that would not be easily fixed if you then wnted to create sub-sequences of length 6 or 4.
So far better is to create an index array, then use that to index into the vector.
n = length(x);
m = 5;
ind = (1:n-m+1)' + (0:m-1);
A = x(ind);
This works for any length vector, and any size of sub-sequences.
It does use a feature of MATLAB that was introduced in R2016b, to create the index array ind. Earlier releases might use this instead:
ind = bsxfun(@plus,(1:n-m+1)',0:m-1);
  4 个评论
显示 2更早的评论
Mahendran Subramanian
Mahendran Subramanian 2019-9-26
I have already done that. I need the data as separate sequences for running through various analyses. And I am looking into it.
Stephen23
Stephen23 2019-9-26
"I need the data as separate sequences for running through various analyses."
Then you can easily use an ND array or a cell array, exactly as John D'Errico wrote.

请先登录，再进行评论。

Dwarka Sahu
Dwarka Sahu 2019-9-25
for i=1:5
sprintf('%g, %g, %g, %g, %g',i, i+1, i+2, i+3, i+4)
end
  3 个评论
显示 1更早的评论
Dwarka Sahu
Dwarka Sahu 2019-9-26
For the first sequence of (nx2)
for i=1:5
sprintf('x%g, y%g', i, i)
end
For the next set of sequence of (2x5)
for i=1:5
sprintf('x%g, x%g, x%g, x%g, x%g', i, i+1,i+2,i+3,i+4)
sprintf('y%g, y%g, y%g, y%g, y%g', i, i+1,i+2,i+3,i+4)
end
Mahendran Subramanian
Mahendran Subramanian 2019-9-26
RelativeX = 2500 x 1 double
RelativeY = 2500 x 1 double
or
XY = 2500 x 2 double
Thank you for the answer, however, Iam getting the following
>> for i=1:5
sprintf('RelativeX%g, RelativeY%g', i, i)
end
for i=1:5
sprintf('RelativeX%g, RelativeX%g, RelativeX%g, RelativeX%g, RelativeX%g', i, i+1,i+2,i+3,i+4)
sprintf('RelativeY%g, RelativeY%g, RelativeY%g, RelativeY%g, RelativeY%g', i, i+1,i+2,i+3,i+4)
end
ans =
'RelativeX1, RelativeY1'
ans =
'RelativeX2, RelativeY2'
ans =
'RelativeX3, RelativeY3'
ans =
'RelativeX4, RelativeY4'
ans =
'RelativeX5, RelativeY5'
ans =
'RelativeX1, RelativeX2, RelativeX3, RelativeX4, RelativeX5'
ans =
'RelativeY1, RelativeY2, RelativeY3, RelativeY4, RelativeY5'
ans =
'RelativeX2, RelativeX3, RelativeX4, RelativeX5, RelativeX6'
ans =
'RelativeY2, RelativeY3, RelativeY4, RelativeY5, RelativeY6'
ans =
'RelativeX3, RelativeX4, RelativeX5, RelativeX6, RelativeX7'
ans =
'RelativeY3, RelativeY4, RelativeY5, RelativeY6, RelativeY7'
ans =
'RelativeX4, RelativeX5, RelativeX6, RelativeX7, RelativeX8'
ans =
'RelativeY4, RelativeY5, RelativeY6, RelativeY7, RelativeY8'
ans =
'RelativeX5, RelativeX6, RelativeX7, RelativeX8, RelativeX9'
ans =
'RelativeY5, RelativeY6, RelativeY7, RelativeY8, RelativeY9'

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 User-Defined Functions 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by