[Numpy-discussion] conditional array indexing

Michaell Taylor michaell.taylor at reis.com
Tue Jan 29 08:46:02 CST 2002


Thanks for your quick reply.  This looks vaguely S-Plus-like, with which I am 
familar.  I wasn't too clear in my question however, I would actually like a 
vector returned which would contain the values of c for the minimun value of 
b, within each category of a.  Something like:

for i in range(1:5000):    # range of values of a
	d = c[Numeric.argmin(Numeric.where(a==i, b, sys.maxint))]

Seems like I could hack a fix using such a vector, but I would guess that 
speed would be an issue.

Essentially the functionality implied by
GROUP BY in sql
egen in stata
lapply() in S-Plus.


Paul F. Dubois wrote:
> import Numeric, sys
> a = Numeric.array([1,2,1,2,4,3,1,2,3,2,3,2])
> b = Numeric.array([4,3,5,2,4,5,3,6,3,2,5,6])
> c = Numeric.arange(len(b))
>
> print c[Numeric.argmin(Numeric.where(a==1, b, sys.maxint))]
>
>
> -----Original Message-----
> From: numpy-discussion-admin at lists.sourceforge.net
> [mailto:numpy-discussion-admin at lists.sourceforge.net] On Behalf Of
> Michaell Taylor
> Sent: Monday, January 28, 2002 12:59 PM
> To: numpy-discussion at lists.sourceforge.net
> Subject: [Numpy-discussion] conditional array indexing
>
>
>
> Very new user to Numpy, so excuse the question.  It relates to a
> fundamental
> issue which I have having trouble getting a grip on.
>
> Specifically, say I have the following:
>
> a = ([1,2,1,2,4,3,1,2,3,2,3,2])
> b = ([4,3,5,2,4,5,3,6,3,2,5,6])
> c = random variable of length=len(b)
>
> I would like to get the value of C associated with the lowest value of b
>
> within groupings of a.  That is, there are three incidents of "1" in the
> a
> array.  The lowest value of b associated with the value 1 in the a index
> is
> "3".  This occurs in index value 6 on the a and b arrays.  Now, I would
> like
> to then know the value of c[6].
>
> Obviously the real problem is far more complex with len(a)==5000.
> Any ideas?
>
> Thanks in advance.
>
> Michaell
>
> _______________________________________________
> Numpy-discussion mailing list Numpy-discussion at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/numpy-discussion

-- 
=========================================
Michaell Taylor, PhD
Senior Economist, Reis, New York, USA




More information about the Numpy-discussion mailing list