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

Pierre GM pgmdevlist@gmail....
Mon May 11 17:56:00 CDT 2009

On May 11, 2009, at 6:36 PM, Skipper Seabold wrote:

> On Mon, May 11, 2009 at 6:18 PM, Wei Su <taste_of_r@yahoo.com> wrote:
>> 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
> Does merge_arrays in numpy.lib.recfunctions do what you want?

Probably not. merge_arrays is close to concatenate, and will raise an  
exception if 2 fields have the same name (in the flattened version).  
Testing R's merge(), join_by looks like the corresponding function.

More information about the Numpy-discussion mailing list