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

[Pierre GM]

On May 11, 2009, at 6:18 PM, Wei Su wrote:
>
> 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.

OK. Try numpy.lib.recfunctions.join_by, and let me know if you have  
any problem. It's a rewritten version of an equivalent function in  
matplotlib (matplotlib.mlab.rec_join), that should work (maybe not,  
there hasn't been enough testing feedback to judge...)