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

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