Re: [Numpy-discussion] List of arrays

2009-05-11 Thread Wei Su
Hi, Francesc:   The codes do not work. Guess you forgot something there.   Thanks.   Wei Su --- On Mon, 5/11/09, Francesc Alted fal...@pytables.org wrote: From: Francesc Alted fal...@pytables.org Subject: Re: [Numpy-discussion] List of arrays To: Discussion of Numerical Python numpy-discussion

[Numpy-discussion] How to merge or SQL join record arrays in Python?

2009-05-11 Thread Wei Su
    Hi, All,   Coming from SAS and R, this is probably the first thing I want to do now that I can convert my data into record arrays. But I could not find any clues after googling for a while. Any hint or suggestions will be great!   Thanks a lot.   Wei Su

Re: [Numpy-discussion] How to merge or SQL join record arrays in Python?

2009-05-11 Thread Wei Su
  Hi, Pierre:   Thanks for the reply. I can now actually turn a big list into a record array. My question is actually how to join related record arrays in Python. This is done in SAS by MERGE and PROC SQL and by merge() in R. But I have no idea how to do it in Python.   Thanks.   Wei Su

[Numpy-discussion] How to download data directly from SQL into NumPy as a record array or structured array.

2009-05-05 Thread Wei Su
  Hi, Everyone:   This is what I need to do everyday. Now I have to first save data as .csv file and the use csv2rec() to read the data as a record array. Anybody can give me some advice on how to directly get the data as record arrays? It will save me tons of time.   Thanks in advance.   Wei

Re: [Numpy-discussion] How to convert a list into a structured array?

2009-05-05 Thread Wei Su
sometimes cannot even download all my data via R due to its memory limit under windows. I thought NumPy might be the solution. But I am not sure. Anybody can let me know whether Python has a memory limit? or can I use virtual memory by calling some Python module?   Thanks in advance.   Wei  Su

[Numpy-discussion] How to convert a list into a structured array?

2009-05-04 Thread Wei Su
into a structured array? using array() will turn it into a text array, afaik. it is even better if anybody can show me some tricks to download the data directly as a structured array.   Thanks a lot for the help.   Wei Su   BTW: I am also interested in Python's ability to handle large data. Any hints