Renyulb28 has asked for the wisdom of the Perl Monks concerning the following question:
I would like to know where to start in going about solving this issue. I currently have a dataset with a column of start coordinates and a column of stop coordinates, and a column of quantitative values for each interval. The intervals are a sliding window that moves up for each row.So it looks something like this:
12345 12445 0.454 12346 12446 0.326 12347 12447 0.355 . . .
The other dataset are the specific coordinates of the important markers, and has a column of specific coordinates:
12435 13455 13532 16135
I would like to know how I can go about compiling all the intervals from the first dataset that each marker from the second dataset falls in, and averaging all of the quantitative values for those intervals, thus getting an average quantitative value for each marker. Some windows will encompass more that one marker, so all of those markers will receive the same average.
Thank you for any guidance.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Sliding window intervals and average values for specific coordinates
by johngg (Canon) on Jan 12, 2012 at 22:07 UTC | |
|
Re: Sliding window intervals and average values for specific coordinates
by GrandFather (Saint) on Jan 12, 2012 at 22:09 UTC | |
|
Re: Sliding window intervals and average values for specific coordinates
by BrowserUk (Patriarch) on Jan 12, 2012 at 22:15 UTC | |
|
Re: Sliding window intervals and average values for specific coordinates
by locked_user sundialsvc4 (Abbot) on Jan 13, 2012 at 14:11 UTC |