Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I <em>think</em> this is what you want, although it's not that clear:</p> <pre><code>for i in range(0, len(ListB), 2): for x in ListA: if ListB[i] &lt; x &lt; ListB[i+1]: print 'within range' </code></pre> <p>You're right in your intuition that you can <code>i:i+2</code> sort of represents a "range", but not quite like that. That syntax can only be used when slicing a <code>list</code>: <code>ListB[i:i+2]</code> returns a smaller list with just 2 elements, <code>[ListB[i], ListB[i+1]]</code>, just as you expect, but <code>i:i+2</code> on its own is illegal. (If you really want to, you can write <code>slice(i, i+2)</code> to mean what you're aiming at, but it's not all that useful here.)</p> <p>Also, from your description, you want to compare <code>x</code> to the values <code>ListB[i]</code> and <code>ListB[i+1]</code>, not just <code>i</code> and <code>i+1</code> as in your code.</p> <p>If you wanted to use the slice to generate a range, you could do so, but only indirectly, and it would actually be clumsier and worse in most ways:</p> <pre><code>for i in range(0, len(ListB), 2): brange = range(*ListB[i:i+2]) for x in ListA: if x in brange: print 'within range' </code></pre> <p>But this is checking for a half-open range rather than an open range, and it requires creating the list representing the range, and walking over the whole thing, and it will only work for integers. So, it's probably not what you want. Better to just explicitly use <code>ListB[i] &lt; x &lt; ListB[i+1]</code>.</p> <p>You might want to consider whether there's a more readable way to build a list of pairs of elements from <code>ListB</code>. Without yet knowing about <code>itertools</code> and list comprehensions or generator expressions (I assume), you'd probably have to write something pretty verbose and explicit, but it might be useful practice anyway.</p>
    singulars
    1. This table or related slice is empty.
    1. POCheck if a list item integer is a number between every two item integers in another list in Python?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USabarnert
    1. USabarnert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCheck if a list item integer is a number between every two item integers in another list in Python?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COYou said, "You might want to consider whether there's a more readable way to build a list of pairs of elements from ListB." [See the zip() function.](http://docs.python.org/2/library/functions.html#zip)
      singulars
      1. PO
      1. USMike Sherrill 'Cat Recall'
    2. CO@Catcall: I'm trying to get the OP to figure out a way to write this himself, not hand him code that he doesn't understand.
      singulars
      1. PO
      1. USabarnert
    3. CObtw, [`an_int in range` is a O(1) operation in Python 3](http://hg.python.org/cpython/file/b6ced7bd7d96/Objects/rangeobject.c#l360) though for `step == 1` case the explicit comparison might be better
      singulars
      1. PO
      1. USjfs
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload