Hi monks,

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
.
.
.

[download]

The other dataset are the specific coordinates of the important markers, and has a column of specific coordinates: 

12435
13455
13532
16135

[download]

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.

In reply to Sliding window intervals and average values for specific coordinates by Renyulb28

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.