Re: time series data and NumPy

2007-01-26 Thread BBands
On Jan 26, 10:46 am, Robert Kern <[EMAIL PROTECTED]> wrote: > Yes, one can make numpy arrays with "object" as its type. One can even extend > the C-level parts as well. For example, we have an experimental package in the > scipy sandbox for uniform time series that uses mx.DateTime. > > http://www

Re: time series data and NumPy

2007-01-26 Thread BBands
On Jan 26, 10:18 am, Bob Greschke wrote: > You're using the Python-MySQL module mysqldb, right? Actually I using MySQL with pyodbc as the mysqldb Windows binaries for Python 2.5 aren't out yet. :-( > You can select the data from the database and have > MySQL do the conversion with an SQL command

Re: time series data and NumPy

2007-01-26 Thread Robert Kern
Diez B. Roggisch wrote: > I'm pretty sure you're out of luck here - even _if_ NumPy would handle > arbitrary data-types (AFAIK it doesn't, but then I'm not a total expert > there), it certainly won't be able to make its hi-performance functions > work on them. Yes, one can make numpy arrays with

Re: time series data and NumPy

2007-01-26 Thread Bob Greschke
On 2007-01-26 10:54:02 -0700, "BBands" <[EMAIL PROTECTED]> said: > On Jan 26, 9:29 am, "Diez B. Roggisch" <[EMAIL PROTECTED]> wrote: > >> What you could do would be to convert the date-column into a timestamp, >> which is a int/long, and use that. Would that help? > > Actually that might help, a

Re: time series data and NumPy

2007-01-26 Thread BBands
On Jan 26, 9:29 am, "Diez B. Roggisch" <[EMAIL PROTECTED]> wrote: > What you could do would be to convert the date-column into a timestamp, > which is a int/long, and use that. Would that help? Actually that might help, as all I need the date for is to index values. Thanks, I'll give it a spin.

Re: time series data and NumPy

2007-01-26 Thread Diez B. Roggisch
BBands wrote: > Good morning, > > I store time series data in a SQL database. The results of a typical > query using pyodbc look like this. > > DateClose > "2007-01-17" 22.57 > > Where Date is a datetime.date object and Close is a float. > > I'd like to put this data in a NumPy arr

time series data and NumPy

2007-01-26 Thread BBands
Good morning, I store time series data in a SQL database. The results of a typical query using pyodbc look like this. DateClose "2007-01-17" 22.57 Where Date is a datetime.date object and Close is a float. I'd like to put this data in a NumPy array for processing, but am unsure as t