McEs, A Hacker Life: Massaging Board Meeting Minutes Data

Wednesday, October 26, 2005

Massaging Board Meeting Minutes Data

Following up on the discussion about reducing the GNOME Foundation board size from 11 to 7, I used some shell and awk to get some attendance statistics out of the meeting minutes that Daniel has been sending out.

First we need to download all the traffic on the foundation-announce list for the year of 2005 (only):


for year in 2005; do
  for m in `seq -w 12`; do
    month=`date +'%B' -d $year/$m/01`;
    wget -O - http://mail.gnome.org/archives/foundation-announce/$year-$month.txt.gz |
    gunzip > foundation-announce-$year-$m$month.txt;
  done;
done

Now we want to figure out how many meetings each of the board members has attended, missed, or sent a regret. A bit of awk does exactly that:


cat foundation-announce-2005-* |
awk '
  /^(Attendance|Missing|Regrets):?$/ {mode=$0; state=0; next;}
  /^$/    {if (!state) state++;
           if (state>1) mode=0;
           next;}
  /:$/    {mode=0; next;}
  /^=*$/  {next;}
  /^ /    {state=2;
           if (mode) print mode" "$0;}
' |
sed '
  s/ *(.*//;
  s/  */ /g;
  s/David Neary/Dave Neary/g;
' |
sort |
uniq -c |
sort -n -r

And here is the output:


     13 Attendance: Tim Ney
     13 Attendance: Owen Taylor
     12 Attendance: Murray Cumming
     12 Attendance: Federico Mena-Quintero
     12 Attendance: Daniel Veillard
     11 Attendance: Jonathan Blandford
     10 Attendance: Dave Neary
      8 Attendance: Luis Villa
      8 Attendance: Jody Goldberg
      8 Attendance: Christian Schaller
      7 Attendance: Miguel de Icaza
      4 Regrets: Miguel de Icaza
      4 Missing: Christian Schaller
      3 Regrets: Luis Villa
      3 Regrets: Jody Goldberg
      2 Regrets: Jonathan Blandford
      2 Regrets: Dave Neary
      2 Missing: Miguel de Icaza
      2 Missing: Luis Villa
      2 Missing: Jody Goldberg
      1 Regrets: Murray Cumming
      1 Regrets: Federico Mena-Quintero
      1 Regrets: Daniel Veillard
      1 Regrets: Christian Schaller
      1 Missing: Dave Neary

¶ 9:49 AM

Comments: Post a Comment

<< Archive
<< Home

About Me

Twitter Updates