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

Reduce a large XY array to a much smaller xy array where the x data is diluted to a much smaller vector and y values are the mean of the ones inbetween

8 次查看（过去 30 天）
Saeid
Saeid 2022-12-27
评论： Voss 2022-12-28
I need to dilute a very large XY array where e.g. length(X)=10000 and I want to reduce the length of this array to a much smaller number. It is of course possible to reshape the array but this requires eleiminating all the elements inbetween. I need the y elements that make up the new y array to be an average of the elements that have been eliminated.
This means:
OldArray=XY=[X0 X1 X2 X3 X4 X5 X6 X7 X8 ... Xn; Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 ... Yn];
NewArray=xy=[x1 x2 x3 ... xm; y1 y2 y3 ... ym]; m is a fraction of n
where
x1=X0; x2=X5; x3=X10; x4=15 ...
but
y1=mean(y0:y4); y2=mean(y5:y9); y3=mean(y10:y14); ...

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

采纳的回答

Voss
Voss 2022-12-27
Ran in:
I'll assume that "Y1 Y2 ... Yn" should be "Y0 Y1 ... Yn" and that "y1=mean(y0:y4); y2=mean(y5:y9); y3=mean(y10:y14); ..." should be "y1=mean(Y0:Y4); y2=mean(Y5:Y9); y3=mean(Y10:Y14); ...".
n = 30;
m = 5;
% OldArray
XY = randi(10,2,n)
XY = 2×30
4 5 7 10 2 9 8 8 5 7 2 10 4 5 8 6 6 2 5 4 4 3 8 2 2 2 1 6 7 8 9 5 1 5 5 1 7 4 3 7 3 7 2 2 9 3 7 4 4 2 10 7 8 1 4 4 9 9 9 1
% NewArray
xy = [XY(1,1:m:end); mean(reshape(XY(2,:),m,[]),1)]
xy = 2×6
4.0000 9.0000 2.0000 6.0000 4.0000 2.0000 5.0000 4.4000 4.6000 4.0000 6.0000 6.4000

更多回答（1 个）

Sulaymon Eshkabilov
Sulaymon Eshkabilov 2022-12-27
Ran in:
Eg. taking a matrix of 2-by-30:
A1 = [1:30; 4*(1:30)]
A1 = 2×30
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 4 8 12 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 84 88 92 96 100 104 108 112 116 120
x = A1(1, 1:5:end)
x = 1×6
1 6 11 16 21 26
y = mean(reshape(A1(2,1:end),6,5),2)
y = 6×1
52 56 60 64 68 72
B1 = [x;y.']
B1 = 2×6
1 6 11 16 21 26 52 56 60 64 68 72
  3 个评论
显示 1更早的评论
Voss
Voss 2022-12-28
Ran in:
@Sulaymon Eshkabilov: I interpret "y1=mean(y0:y4);", etc., to mean that the 1st element of the 2nd row of the desired result should be the mean of the first 5 elements of the 2nd row of the input matrix, and so on similarly for the subsequent elements of the 2nd row of the result (mean of elements 6 through 10 of 2nd row of input matrix, then elements 11 through 15, and so on).
Using your example input matrix, the mean of the first 5 elements of the 2nd row (4, 8, 12, 16, 20) is 12, not 52, which is the mean of (4, 28, 52, 76, 100):
A1 = [1:30; 4*(1:30)]
A1 = 2×30
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 4 8 12 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 84 88 92 96 100 104 108 112 116 120
your_method = mean(reshape(A1(2,:),6,5),2).'
your_method = 1×6
52 56 60 64 68 72
my_method = mean(reshape(A1(2,:),5,[]),1)
my_method = 1×6
12 32 52 72 92 112
Do you interpret "y1=mean(y0:y4);" to mean that the 1st element of the 2nd row should be the mean of [y0 y6 y12 y18 y24], i.e., elements 1, 7, 13, 19, and 25 of the 2nd row of the input matrix?
mean(A1(2,1:6:end))
ans = 52
mean(A1(2,2:6:end)) % etc.
ans = 56

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by