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

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.