[Babase] Finding intergroup interactions

Niki Learn nlearn at princeton.edu
Mon Apr 19 12:14:11 EDT 2010


A clarification (sorry, did this a couple weeks ago):

There are 358 total agonism mismatches for 2000 - 2008a (male-male,
male-female, and female-female, regardless of age).  That is 0.12% of the
300k agonisms for that period.  98 of the 358 are adult male to adult male
(this is the 0.89% out of just shy of 11k adult male to adult male
interactions).  It sounds to me from those numbers that this problem is
skewed toward males.  A preliminary look at the list of 358 suggests that
most of the other cases are either male-male where at least one male was not
an adult and male-female interactions.  I am working on a query that will
list how those that are actually female-female.  

I know that some of the adult male to adult male cases I looked at included
multiple interactions for the mismatched male, often including interactions
with females.  I would guess that the same males from the 98 cases for adult
male to adult male account for a large portion of the adult male to female
interactions.  There are also a small number in which the female wins,
including a very small number in which she wins over an adult male - these
may be cases where she defeated a visiting male who was not listed in the
census (but possibly there are demog or other groups notes to explain
these).

On the bright side, it sounds like there are a lot fewer of these mismatches
overall in recent data (0.12%) than in older data, given the 0.76% Karl
found below for all years.

-----Original Message-----
From: babase-bounces at eeblistserv.Princeton.EDU
[mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl O. Pinc
Sent: Monday, April 19, 2010 11:49 AM
To: The Baboon Database Project
Subject: Re: [Babase] Finding intergroup interactions

FYI

I get an overall not-in-the-same-supergroup to
total interaction ratio of 5689 / 744082,
or about 0.76%.

On 04/19/2010 10:31:01 AM, Karl O. Pinc wrote:
> 
> SELECT interact.iid, interact.act, interact.date
>        , actor.sname, supergroup(actorgrp.gid, interact.date) as
> actorsupergroup
>        , actee.sname, supergroup(acteegrp.gid, interact.date) as
> acteesupergroup
>        , 'Warning: Interactions should be between individuals in the 
> same
> supergroup'
>   FROM interact, parts AS actor, parts AS actee
>        , members AS acteembr, members AS actormbr
>        , groups AS acteegrp, groups AS actorgrp
>   WHERE actor.iid = interact.iid
>         AND actor.role = 'R'
>         AND actormbr.date = interact.date
>         AND actormbr.sname = actor.sname
>         AND actorgrp.gid = actormbr.grp
>         AND actee.iid = interact.iid
>         AND actee.role = 'E'
>         AND acteembr.date = interact.date
>         AND acteembr.sname = actee.sname
>         AND acteegrp.gid = acteembr.grp
>         AND supergroup(actorgrp.gid, interact.date)
>             != supergroup(acteegrp.gid, interact.date)
>   ORDER BY interact.date, interact.act, interact.iid, actor.sname,
> actee.sname;




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein


_______________________________________________
Babase mailing list
Babase at www.eco.princeton.edu
http://www.eco.princeton.edu/mailman/listinfo/babase



More information about the Babase mailing list