Averaging sequential data if values are the same?

yz
2017 8 10
3 个回答
回答已采纳
更新时间：2017 8 11
6 次查看（30 天）

0 个投票

I want to be able to average the values of an array of n rows and 5 columns, based on the repeated values of a specific column.
I only want to average the values that are next to each other and not all that repeat. Such that:
%Original data:
key_column = [-6 -6 -6 -6 -5 -5 -3 -3 -3 -1 -1 -1 0 0 1 1 2 2 2 3 3 5 5 5 5 6 6 6 6 4 4 4 3 3 3 3 3 3 3 2 2 2 1 1 1 1 0 0 -1 -1 -2 -3 -5 -5 -5 -5 -5 -5 -5 -6 -6 -6];
%Ends up as:
key_column_avg = [-6 -5 -3 -1 -0 1 2 3 5 6 4 3 2 1 0 -1 -2 -3 -5 -6]
I'm running into trouble because the values of the repeated numbers appear at multiple points in the column and I only want the to be averaged if they are "next to each other" on the column. Also, I'm having issues because the number of repeated values isn't the same for each number. Sometimes the value repeats for 10 times, sometimes for 3, sometimes for 7, sometimes for 4.
Is it possible to do this?
Thank you.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

KL
KL 2017-8-10
Averaging means totally different. Do you just want to remove the repeating elements?
Andrei Bobrov
Andrei Bobrov 2017-8-10
"...because the number of repeated values isn't the same for each number..."
Please attach small part your real data as mat - file.
yz
yz 2017-8-10
No, I want to average all columns based on the repeated sequential values of this specific column.
yz
yz 2017-8-10
Attached is a sample of my data set. Column 4 is the column of interest for the averaging, but I wish to apply the averaging to all columns (based on the n number of values on column 4)

请先登录，再进行评论。

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

 采纳的回答

Andrei Bobrov
Andrei Bobrov 2017-8-10

0 个投票

key_column_avg = key_column(diff([0,key_column(:)'],1,2) ~= 0);

4 个评论
显示 2更早的评论 隐藏 2更早的评论

yz
yz 2017-8-10
Thank you!
Do you know how I can apply this averaging to all other columns that don't have repeated values?
What I mean:
key_column = [6 5 5 5 1 0 1 2 2 3 3 5 5 6]
other_column = [10 15 13 11 51 58 0 67 10 2 33 5 76 45]
%ends up being:
key_column_avg = [6 5 1 0 1 2 3 5 6]
other_column_avg = [10 13 51 58 0 38.5 17.5 40.5 45]
yz
yz 2017-8-10
Oops I think I replied on the wrong spot. Here it is again, just in case:
Attached is a sample of my data set. Column 4 is the column of interest for the averaging, but I wish to apply the averaging to all columns (based on the n number of values on column 4)
Thank you
Andrei Bobrov
Andrei Bobrov 2017-8-10
编辑：Andrei Bobrov 2017-8-10
d = data_example;
g = cumsum(diff([0;d(:,4)]) ~= 0);
out = splitapply(@mean,d,g);
or
d = data_example;
g = cumsum(diff([0;d(:,4)]) ~= 0);
[gg,c] = ndgrid(g,1:size(d,2));
out1 = accumarray([gg(:),c(:)],d(:),[],@mean);

请先登录，再进行评论。

更多回答（2 个）

José-Luis
José-Luis 2017-8-10

0 个投票

key_column = [-6 -6 -6 -6 -5 -5 -3 -3 -3 -1 -1 -1 0 0 1 1 2 2 2 3 3 5 5 5 5 6 6 6 6 4 4 4 3 3 3 3 3 3 3 2 2 2 1 1 1 1 0 0 -1 -1 -2 -3 -5 -5 -5 -5 -5 -5 -5 -6 -6 -6];
result = [key_column(diff(key_column) > 0), key_column(end) ]

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by