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

[Pierre GM]

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 at 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.