Lookup values from one table to another based on a value

[Bruno Desthuilliers]

(e-mail address removed) a écrit :
(snip)

If I flipped the Table being looked up not to repeat, would that make
things easier to look up a value in?

Don't repeat informations.

 

[koutoo]

If I wanted to accomplish looking up values from one table based on a
value from another table or file, how would I go about doing this in
Python? Would I build a dictionary or an array?

exp:

Table1:

Site = 103
Lane = 2
Dir = ? # Get this from Table2

Table2:

Site, Lane, Direction,
103, 1, 1
103, 2, 1
103, 3, 5
103, 4, 5

Normally in Access I would just use a Dlookup and be done with it, or
use a Recordset in VB. Thanks guys.

Kou

 

[Bruno Desthuilliers]

(e-mail address removed) a écrit :

If I wanted to accomplish looking up values from one table based on a
value from another table or file, how would I go about doing this in
Python? Would I build a dictionary or an array?

exp:

Table1:

Site = 103
Lane = 2
Dir = ? # Get this from Table2

Table2:

Site, Lane, Direction,
103, 1, 1
103, 2, 1
103, 3, 5
103, 4, 5

Normally in Access I would just use a Dlookup and be done with it, or
use a Recordset in VB. Thanks guys.

What about using a database ? Like SQLite ?

Else, the canonical data structure for quick lookups is of course the dict.

 

[koutoo]

(e-mail address removed) a écrit :







What about using a database ? Like SQLite ?

Else, the canonical data structure for quick lookups is of course the dict.- Hide quoted text -

- Show quoted text -

Ah, yes, that would appear to be a better means to retrieve data. I
visited the site, which version should I download? Thanks.

Kou

 

[Bruno Desthuilliers]

(e-mail address removed) a écrit :

Ah, yes, that would appear to be a better means to retrieve data. I
visited the site, which version should I download? Thanks.

The latest, unless you have reasons to choose an old one !-)

 

[koutoo]

(e-mail address removed) a écrit :



The latest, unless you have reasons to choose an old one !-)

If I flipped the Table being looked up not to repeat, would that make
things easier to look up a value in?

Exp:

Table1

Site = 103
Lane = 1
Direction = ?
FHWA Lane = ?

Table2

Site, Lane 1, Direction 1, FHWA Lane 1,
103, 1, 1, 1