Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^3: calculate average in sliding windows

by marfabe (Initiate)
on May 23, 2012 at 14:43 UTC ( [id://972048]=note: print w/replies, xml ) Need Help??


in reply to Re^2: calculate average in sliding windows
in thread calculate average in sliding windows

Thanks Eliya
Here's the simplified sample set

position value 1 1 10 3 30 1 40 2 60 2

And here the output for window size of 30

1-30 1.666666667 31-60 2

Replies are listed 'Best First'.
Re^4: calculate average in sliding windows
by Eliya (Vicar) on May 23, 2012 at 15:05 UTC

    Ok, thanks.  So maybe like this?

    #!/usr/bin/perl -lw use strict; use constant WINDOW => 30; my $sum = 0; my $n = 0; my $p = WINDOW; while (<DATA>) { my ($pos, $val) = split; if (eof) { # corner case $sum += $val; $n++; } if ($pos > $p or eof) { print $sum / $n if $n > 0; $sum = 0; $n = 0; $p += WINDOW while $pos > $p; } $sum += $val; $n++; } __DATA__ 1 1 10 3 30 1 40 2 60 2

    Output:

    1.66666666666667 2

    (Upd: fixed handling of corner case)

      Yes!! It works perfectly! Thank you!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://972048]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others studying the Monastery: (6)
As of 2024-09-13 05:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The PerlMonks site front end has:





    Results (17 votes). Check out past polls.

    Notices?
    erzuuli‥ 🛈The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.