Find value within a range in lookup table

Posted by francis on Stack Overflow See other posts from Stack Overflow or by francis
Published on 2010-05-24T18:05:38Z Indexed on 2010/05/24 18:21 UTC
Read the original article Hit count: 214

Filed under:
|
|
|

I have the simplest problem to implement, but so far I have not been able to get my head around a solution in Python.

I have built a table that looks similar to this one:

501 - ASIA
1262 - EUROPE
3389 - LATAM
5409 - US

I will test a certain value to see if it falls within these ranges, 389 -> ASIA, 1300 -> LATAM, 5400 -> US. A value greater than 5409 should not return a lookup value.

I normally have a one to one match, and would implement a dictionary for the lookup.

But in this case I have to consider these ranges, and I am not seeing my way out of the problem.

Maybe without providing the whole solution, could you provide some comments that would help me look in the right direction?

It is very similar to a vlookup in a spreadsheet.

I would describe my Python knowledge as somewhere in between basic to intermediate.

Many thanks in advance.

© Stack Overflow or respective owner

Related posts about python

Related posts about table