Filtering Data

Question

0 个投票

Hello,

I am trying to compute an average and variance of a large data set (~330000 rows x 3 different columns), but I'd like to take the average and var. of every 240 entries. I think you'd call this a moving average/variance, but I'm not sure.

Can you please provide hints as to accomplish this? I'm thinking either a for-loop or using the 'filter' function, but am not sure how to approach this problem...

Thanks in advance,

Nic

2 个评论
显示无隐藏无

ndb 2011-4-27

Also,

I already have a column that records the minute each measurement is made, there being 4 measurements taken each second (4 * 60 = 240 measurements a minute). So I'm thinking that I might be able to construct a loop that looks to see if the minute column has changed (say, from minute 0 to minute 1) and if so, average/take variance of the values stored in some temporary variable...

Am I on the right track?

Andrew Newell 2011-4-27

By "entries" do you mean rows or total number of variables?

请先登录，再进行评论。

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

Follow Question

Answer 1

Jarrod Rivituso 2011-4-27

在 MATLAB Online 中打开

0 个投票

Here's a filter function example for ya...

Doc reference: http://www.mathworks.com/help/techdoc/ref/filter.html

Example code for simple moving average:

data = rand(4000,3);
window = ones(240,1)/240;
filtered_data = filter(window,1,data);

Hope this helps!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jarrod Rivituso 2011-4-27

After reading your additional comment, here's a fancy bit of code that you might find useful:

%create random data

data = rand(100,4);

%emulate 4th column a bit

data(1:10,4) = 1;

data(11:20,4) = 2;

%extract all rows where 4th column is equal to 1

extractedData = data(data(:,4) == 1,:)

%find variance of extracted data

var(extractedData)

请先登录，再进行评论。

Filtering Data

2 个评论
显示无隐藏无

采纳的回答

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

更多回答（0 个）

类别

标签

Community Treasure Hunt

Filtering Data

2 个评论 显示 无 隐藏 无

采纳的回答

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

更多回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

2 个评论
显示无隐藏无

1 个评论
显示 -1更早的评论隐藏 -1更早的评论