[Babase] Re: agonism/grooming 'investigation'
lacey.maryott at duke.edu
lacey.maryott at duke.edu
Sun Mar 25 17:37:56 EDT 2007
Karl, wow, thanks so much for the query for this! I will get this all
put in to
bar graphs and show Susan what i found tomorrow!
Cheers
Lacey
Quoting "Karl O. Pinc" <kop at meme.com>:
>
> On 03/25/2007 02:06:04 PM, Susan Alberts wrote:
>> Sorry to be slow getting back to you but i wasn't completely sure I
>> understood your message this morning and didn't have time to think it
>> through.
>>
>> I have copied this reply to the babase mailing, so that the
>> discussion will be in the archive.
>>
>> Responses below.
>>
>>
>>> I wanted to know if you think I should go in and look
>>> at the years where it looks like they WERE pushed to the first to
>>> see how much
>>> so each month, etc...
>>
>>
>> No I don't think this is very important. That is, in years where
>> there is clearly not an even distribution of events across days
>> (where it was usually pushed to 1st of month) we don't need to know
>> much more about those years -- we can't recover the "real" dates
>> anyway (not very easily). So the years where it is clear that most
>> were pushed to the first are not the issue. I think the issue is, do
>> we have a clear sense of which year the date of the entry actually
>> starts meaning the real date. In other words, if we leave the dates
>> as they are for a given year, can we be sure that they really
>> represent the real dates, or were some pushed to the first of the
>> month. To think about this, I think that you should pick the first
>> reasonably "even" year for each of grooming and agonism and then plot
>> the events-by-day on a bar graph so we can see the distribution. You
>> can ignore the years where things were mostly pushed to the first.
>
> select act
> , extract(year from date) as year_part
> , extract(month from date) as month_part
> , sum(case when extract(day from date) = 1 then 1 else 0 end) as
> _1st
> , sum(case when extract(day from date) = 2 then 1 else 0 end) as
> _2nd
> , sum(case when extract(day from date) = 3 then 1 else 0 end) as
> _3rd
> , sum(case when extract(day from date) = 4 then 1 else 0 end) as
> _4th
> , sum(case when extract(day from date) = 5 then 1 else 0 end) as
> _5th
> , sum(case when extract(day from date) = 6 then 1 else 0 end) as
> _6th
> , sum(case when extract(day from date) = 7 then 1 else 0 end) as
> _7th
> , sum(case when extract(day from date) = 8 then 1 else 0 end) as
> _8th
> , sum(case when extract(day from date) = 9 then 1 else 0 end) as
> _9th
> , sum(case when extract(day from date) = 10 then 1 else 0 end) as
> _10th
> , sum(case when extract(day from date) = 11 then 1 else 0 end) as
> _11th
> , sum(case when extract(day from date) = 12 then 1 else 0 end) as
> _12th
> , sum(case when extract(day from date) = 13 then 1 else 0 end) as
> _13th
> , sum(case when extract(day from date) = 14 then 1 else 0 end) as
> _14th
> , sum(case when extract(day from date) = 15 then 1 else 0 end) as
> _15th
> , sum(case when extract(day from date) = 16 then 1 else 0 end) as
> _16th
> , sum(case when extract(day from date) = 17 then 1 else 0 end) as
> _17th
> , sum(case when extract(day from date) = 18 then 1 else 0 end) as
> _18th
> , sum(case when extract(day from date) = 19 then 1 else 0 end) as
> _19th
> , sum(case when extract(day from date) = 20 then 1 else 0 end) as
> _20th
> , sum(case when extract(day from date) = 21 then 1 else 0 end) as
> _21st
> , sum(case when extract(day from date) = 22 then 1 else 0 end) as
> _22nd
> , sum(case when extract(day from date) = 23 then 1 else 0 end) as
> _23rd
> , sum(case when extract(day from date) = 24 then 1 else 0 end) as
> _24th
> , sum(case when extract(day from date) = 25 then 1 else 0 end) as
> _25th
> , sum(case when extract(day from date) = 26 then 1 else 0 end) as
> _26th
> , sum(case when extract(day from date) = 27 then 1 else 0 end) as
> _27th
> , sum(case when extract(day from date) = 28 then 1 else 0 end) as
> _28th
> , sum(case when extract(day from date) = 29 then 1 else 0 end) as
> _29th
> , sum(case when extract(day from date) = 30 then 1 else 0 end) as
> _30th
> , sum(case when extract(day from date) = 31 then 1 else 0 end) as
> _31st
> from interact_data
> group by act, year_part, month_part
> order by act, year_part, month_part;
>
>
> 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