[Numpy-discussion] query to array
kwgoodman at gmail.com
Wed Jan 31 18:19:14 EST 2007
On 1/31/07, Tom Denniston <tom.denniston at alum.dartmouth.org> wrote:
> i would do something like the following. I don't have your odbc
> library so I mocked it up with a fake iterator called "it". This
> example would be for a two column result where the first is an int and
> the second a string. Note it creates a recarray which you can have
> match you database column names if you want to generalize the
> function. All you need to provide is the dtype equivalent to your
> query result layout.
> In : import numpy
> In : it = iter([(1,'String1'), (2, 'String2')])
> In : dtype = numpy.dtype([('intvalue', int), ('stringcolumn', '|S20')])
> In : numpy.fromiter(it, dtype)
> array([(1, 'String1'), (2, 'String2')],
> dtype=[('intvalue', '<i4'), ('stringcolumn', '|S20')])
All this fromiter and recarray is confusing to me. But I'd like to learn.
How would I hook all this up to a query?
More information about the NumPy-Discussion