Lookup values from one table to another based on a value

[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]

ko****@hotmail.com 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]

On Sep 20, 10:34 am, Bruno Desthuilliers <bruno.
[e-mail]:

[e-mail] 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.- 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]

ko****@hotmail.com a écrit :

On Sep 20, 10:34 am, Bruno Desthuilliers <bruno.
[e-mail]:

>[e-mail] a écrit :

(snip)

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

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]

On Sep 20, 11:51 am, Bruno Desthuilliers <bruno.
[e-mail]:

[e-mail] a écrit :

On Sep 20, 10:34 am, Bruno Desthuilliers <bruno.
[e-mail]:

[e-mail] a écrit :

(snip)

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

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 !-)

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

[Bruno Desthuilliers]

ko****@hotmail.com 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.