0

Did someone make an attempt at mining comments on the data dump?

I like comments very much, even though they are "second class citizens". I think they add a lot of spice to the trilogy sites.

I would like to know if someone has used the data dumps to produce interesting data regarding comments such as:

  • The most commented questions
  • The most commented answers
  • The most voted comment
  • The most prolific commenter
  • The user whose posts are most commented
  • Tags with highest relative number of comments
Improve this question

2 Answers 2

Reset to default
4

Using the Stack Exchange Data Explorer:

You can carry on from there.

Improve this answer
3
  • 1
    I'd done all the others before, but +1 for the last (4th) link. Hope you don't mind I updated your link there for one with line breaks and better column names (so you get links to user profiles). Also, Users by Comments Per Post: data.stackexchange.com/stackoverflow/query/104086/… Commented Nov 2, 2009 at 19:22
  • Thanks for that, I was wondering why sometimes things created links and sometimes they didn't. Commented Nov 2, 2009 at 20:26
  • Also: Users by Comments Per Post for users with at least 10 posts: data.stackexchange.com/stackoverflow/query/104087/… (hurray for correctly using a HAVING clause on the first try :) Commented Mar 20, 2013 at 1:33
2

Stu Thompson has posted Comment Analysis from the Latest Data Dump (from the Sept data dump). It looks at the Number of Comments vs Average Score by User.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.