Not signed in (Sign In)

Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.

Feature requests: For your statistical amusement: questions/comments/votes per day.

Bottom of Page

1 to 23 of 23

  1.  
  1.  

    Questions per day

    Questions

    All posts, per day

    Posts

    Votes per day

    Votes

    Comments per day

    Comments

    New users per day

    New users

  2.  

    Neat! Thanks Scott!

    Any technical reason why comments don't show as strong initial peak in October as the other graphs do?

    • CommentAuthorMariano
    • CommentTimeMar 20th 2010
     

    Could you adorn the graphs with trend lines? /me is lazy...

    • CommentAuthorHarry Gindi
    • CommentTimeMar 20th 2010 edited
     

    Oh, could you add a graph for questions closed per day? I want to see if it really spiked during finals.

  5.  

    Thanks, Scott! Interesting.

  6.  

    I think it's easier to see what's happening if you plot the cumulative values (i.e. "total number of X up to a given day").

    @fgdorais: comments don't show the strong initial peak because you need 50 reputation to comment on other peoples' posts. Votes also has a subdued peak because you need to get a small amount of reputation (15) before you can vote.

  7.  

    Here's the data for questions closed per day

    Cumulative closed questions

  8.  

    More bad posts being made, or more bad posts being caught do you think?

  9.  
    Fewer bad posts being made (not caught). The slope is decreasing.
    • CommentAuthorHarry Gindi
    • CommentTimeMar 20th 2010 edited
     

    @Steve: That's per day according to Scott.

    Edit: Ah, I see, he was mistaken. That's most certainly not per day.

  11.  

    I presumed everyone would correctly infer that although I'd extracted "questions closed per day" I'd graphed the partial sums, per Anton's suggestion...

  12.  

    @Scott: I saw the shape of that graph and didn't even bother to look at the axes.

    • CommentAuthorBen Webster
    • CommentTimeMar 21st 2010 edited
     

    So wait, you deliberately confused us? Is the closed per day graph too bumpy? a running average would be nice to see, since while I can tell that things deflect downward, it's hard to say by how much. Maybe you could put up the data on many eyes, or as a google doc?

  14.  
    It would also be easier to judge the answer to fpqc's question (did closures spike during finals) looking at the actual per-day graph. But it looks like probably not.
  15.  

    By the way, Scott is getting these stats out of the public dump, and you can easily harvest this (and other) data yourself. For example, to get the number of questions closed on each day, you could simply run the command

    grep -o 'ClosedDate="[^"]*"' posts.xml | sed -e 's/ClosedDate="//' -e 's/T.*$//' | sort | uniq -c

    This finds questions which have a "ClosedDate" property, extracts the date, and then sorts and counts the number of times each date appears. You can then paste the result into a spreadsheet and have fun. You have to do slightly more to get the days where no questions were closed. Here's a graph of number of questions closed each day, along with a running average:
    graph

    (This only counts questions that were closed but not deleted. We don't include deleted posts in the public dump.)

    • CommentAuthorMariano
    • CommentTimeMar 21st 2010 edited
     

    Wow. The bodies of posts are stored in attributes! Wow.

  17.  

    Yup, the bodies of posts are stored in attributes. That's not how it is in the actual dump of the database, but that's the way the SO public dump is done, and I thought it was worthwhile to copy their format pretty exactly since I assumed they'd thought it out carefully.

  18.  
    I've apparently decided that the easiest way to see the graph I'm interested in is to write a program in the language MO Moderator (and I seem to be right).
  19.  

    <sigh> ... try to teach a man to fish, and he'll say, "Haha, you're a fishing rod!"

  20.  
    +1 for bible knowledge. I never read the bible much, but I think what you wrote there is correct.

    ;)
  21.  
  22.  
    More seriously, thanks for the help with the grep command, which will save me time if I think of some other graph I want to see.
  23.  

    Incidentally, how many of us would have believed before this project that it would average as low as 2 closed questions a day? Not I.

1 to 23 of 23

  1.  
Back to Discussions Top of Page