[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