[GenABEL-dev] presentation at UseR!-2013
L.C. Karssen
lennart at karssen.org
Sat Jul 6 18:10:48 CEST 2013
Hi Yurii,
Please find attached the output of the MySQL statement. I added another
column in which the week numbers are separated from the year by a dash,
that makes it easier to read in e.g. R:
posts <- read.table("tmp/posts_per_week_converted.out", header=TRUE,
sep=" ", row.names=NULL)
colnames(posts) <- c("date", "num_posts")
# Convert year-week to year-month-day
posts$weekdate <- as.Date(paste(posts$date, 1), format="%Y-%U %u")
head(posts)
date num_posts weekdate
1 2011-01 1 2011-01-03
2 2011-04 15 2011-01-24
3 2011-05 7 2011-01-31
4 2011-06 24 2011-02-07
5 2011-07 10 2011-02-14
6 2011-08 7 2011-02-21
This should help making a bar plot of "weekdate" vs. "num_posts".
By the way, the SQL script is in the ~/scripts/ directory on the SSH
server of our hoster. You can execute it like this:
mysql -u USERNAME --password=PASSWORD -h HOSTNAME <
get_weekly_posts.sql > posts_per_week.out
The user name, password and host name can be found in the backup scripts
in that same directory.
Best,
Lennart.
On 05-07-13 14:04, Yurii Aulchenko wrote:
>
>
> On Fri, Jul 5, 2013 at 12:30 PM, L.C. Karssen <lennart at karssen.org
> <mailto:lennart at karssen.org>> wrote:
>
> Hi Yurii,
>
> On 07/05/2013 11:04 AM, Yurii Aulchenko wrote:
> > Dear All,
> >
> > I am now drafting my presentation for UseR!-2013 (
> > http://www.edii.uclm.es/~useR-2013/). My presentation about "The
> GenABEL
> > suite for genome-wide association analyses" is scheduled for Wed
> July 10
> > morning. I will send it to the list for the discussion as soon as
> I have a
> > draft (most likely by Saturday eve).
> >
> > I thought it may be a good idea to present the evolution of the
> GenABEL in
> > number, so the idea is to get the numbers by years/quartes of the year
> > (say, #posts in 2009=x1, 2010=x2...) and present them graphically.
> For some
> > of growth metrics I can get the dynamics by years easily, but for
> some I
> > have no idea and hope you could help me (may be also by providing the
> > numbers directly).
> >
> > Here a small list of metrics I thought of:
> >
> > #packages: very easy to count :)
> > #posts on GenABEL-devel: possible to count
> > #posts on forum: no idea how to do that for defined time periods
>
> I guess you need to run a query on the database to get those. Our hoster
> has a phpmyadmin interface yuo can use for that (or you could probably
> use the SSH account and run the MySQL client from the command line).
> Probably a query along this line:
>
> SELECT yearweek(date(from_unixtime(post_time))) AS week, COUNT(*) AS
> num_posts FROM phpbb_posts GROUP BY
> yearweek(date(from_unixtime(post_time)))
>
>
> arrgh... probably I can figure this out if I had enough time, but gonna
> to invest into presentation now. If you/someone could give a hand, would
> be great :)
>
>
>
>
> > #number of lines of code in our SVN repo: no idea
>
> Probably SLOCcount will help: http://www.dwheeler.com/sloccount/
>
>
> This is a nice one! Two problems: it does not count/recognize R; did not
> see how to use it to see the dynamics (what was there in repo 2 years
> ago?..)
>
> But I like that even without the R code counts (which is 148,000 lines),
> for ~65,000 lines of mostly C/C++ I get the message indicating that
> GenABEL is worth few millions of dollars:
>
> Development Effort Estimate, Person-Years (Person-Months) = 15.44 (185.24)
> (Basic COCOMO model, Person-Months = 2.4 * (KSLOC**1.05))
> Schedule Estimate, Years (Months) = 1.05 (12.61)
> (Basic COCOMO model, Months = 2.5 * (person-months**0.38))
> Total Estimated Cost to Develop = $ 2,085,323
> (average salary = $56,286/year, overhead = 2.40).
>
> So I think I should use these figures in my presentation :)
>
> > #citations (GenA, ProbA...): easy to count thanks to Google Scholar
> > #mentions on the Web: ???
> >
> > Any other nice and easily computed metrics?
> >
> > I will appreciate your help and suggestions, and sorry for late
> notice.
> >
>
>
> Good luck,
>
> Lennart.
>
> > best,
> > Yurii
> >
> >
> >
> > _______________________________________________
> > genabel-devel mailing list
> > genabel-devel at lists.r-forge.r-project.org
> <mailto:genabel-devel at lists.r-forge.r-project.org>
> >
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/genabel-devel
> >
>
>
> --
> -----------------------------------------------------------------
> L.C. Karssen
> Utrecht
> The Netherlands
>
> lennart at karssen.org <mailto:lennart at karssen.org>
> http://blog.karssen.org
>
> Stuur mij aub geen Word of Powerpoint bestanden!
> Zie http://www.gnu.org/philosophy/no-word-attachments.nl.html
> ------------------------------------------------------------------
>
>
> _______________________________________________
> genabel-devel mailing list
> genabel-devel at lists.r-forge.r-project.org
> <mailto:genabel-devel at lists.r-forge.r-project.org>
> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/genabel-devel
>
>
>
>
> --
> -----------------------------------------------------
> Yurii S. Aulchenko
>
> [ LinkedIn <http://nl.linkedin.com/in/yuriiaulchenko> ] [ Twitter
> <http://twitter.com/YuriiAulchenko> ] [ Blog
> <http://yurii-aulchenko.blogspot.nl/> ]
--
-----------------------------------------------------------------
L.C. Karssen
Utrecht
The Netherlands
lennart at karssen.org
http://blog.karssen.org
Stuur mij aub geen Word of Powerpoint bestanden!
Zie http://www.gnu.org/philosophy/no-word-attachments.nl.html
------------------------------------------------------------------
-------------- next part --------------
week num_posts
2011-01 1
2011-04 15
2011-05 7
2011-06 24
2011-07 10
2011-08 7
2011-09 17
2011-10 27
2011-11 11
2011-12 11
2011-13 19
2011-14 4
2011-15 12
2011-16 20
2011-17 6
2011-18 6
2011-19 6
2011-20 12
2011-21 9
2011-22 13
2011-23 4
2011-24 40
2011-25 19
2011-26 6
2011-27 26
2011-28 5
2011-29 3
2011-30 2
2011-31 2
2011-32 4
2011-33 11
2011-34 17
2011-35 1
2011-36 5
2011-37 2
2011-38 3
2011-39 16
2011-40 15
2011-41 4
2011-42 7
2011-43 18
2011-44 3
2011-45 4
2011-46 6
2011-47 5
2011-48 7
2011-49 6
2011-50 3
2011-51 9
2011-52 2
2012-01 1
2012-02 2
2012-03 1
2012-04 4
2012-05 6
2012-06 9
2012-07 12
2012-08 26
2012-09 1
2012-10 2
2012-11 6
2012-12 5
2012-13 4
2012-14 2
2012-15 2
2012-16 5
2012-17 4
2012-18 1
2012-19 3
2012-20 2
2012-22 9
2012-23 8
2012-24 9
2012-25 14
2012-26 6
2012-27 6
2012-28 16
2012-29 5
2012-30 2
2012-32 6
2012-33 1
2012-34 10
2012-35 2
2012-36 1
2012-37 9
2012-38 20
2012-39 8
2012-40 8
2012-41 1
2012-42 9
2012-43 9
2012-44 5
2012-45 1
2012-46 1
2012-47 12
2012-48 2
2012-49 16
2012-50 4
2012-51 7
2012-53 4
2013-01 31
2013-02 9
2013-03 7
2013-04 19
2013-05 5
2013-06 8
2013-07 20
2013-08 7
2013-09 15
2013-10 12
2013-11 2
2013-12 6
2013-13 17
2013-14 18
2013-15 9
2013-16 2
2013-17 10
2013-18 12
2013-19 18
2013-20 7
2013-21 3
2013-22 2
2013-23 2
2013-24 9
2013-25 7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 230 bytes
Desc: OpenPGP digital signature
URL: <http://lists.r-forge.r-project.org/pipermail/genabel-devel/attachments/20130706/e9b57d1b/attachment.sig>
More information about the genabel-devel
mailing list