I need information about how many questions a user asks, how many of them are resolved, and how many of them remain unanswered. Is there any way to get this information from the SO data dump?


I wouldn't use the data dump for this; there are easier ways to retrieve this information rather than having to parse a couple of GBs of XML. Enter the Stack Exchange Data Explorer.

This query provides information you might be looking for; the results are:

enter image description here

You can try asking for more than 100 hits, but it might run out of resources and fail if you do so. Maybe you want to exclude closed questions? If so, or you want to make other changes, feel free to fork the query. If you need some help with SQL and/or the structure of the database, check out the awesome tutorial and the chatroom. Note that SEDE is updated once a week, on Sunday morning.

| improve this answer | |
  • I mean the questions that have an accepted answer as 'resolved' and 'unanswered' questions mean the questions have no answers. So, your query is alright. But I need this summary for all the users of Stack Overflow. – Saikat Mondal Feb 12 '19 at 8:32
  • 1
    I've tried to make that one too, see the update. – Glorfindel Feb 12 '19 at 8:42
  • It's really a great help. – Saikat Mondal Feb 12 '19 at 8:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .