SEDE - Stack Exchange Data Explorer

« first day (2991 days earlier) ← previous day next day → last day (695 days later) »

5:26 AM

Q: Stack Overflow Dataset (question/answers/comments) for Text Mining with specific tag

for a small part of my master thesis I need to retrieve from SEDE a dataset that contains all questions as well as the related multiple answers and comments with the tag "text-mining" in order to perform some basic text mining. As my created queries won´t work and SEDE is sometimes just not execu...

I don't think this is the right site for this question. In any case, rather more straightforward approach seems to be simply downloading the data dump which is available on arxiv.org. — Martin Sleziak 11 hours ago

@MartinSleziak I think you meant archive.org? — The Amplitwist 11 hours ago

@TheAmplitwist Yes, certainly I did. Quite an embarrassing mistake - I know both sites well enough not to mix them up. (To the OP - question like this would probably be more suitable on Meta Stack Exchange or on Meta StackOverflow. But it would be good to clarify a bit more what you're actually looking for. Perhaps the question would at least tangentially fit here, if you were examining MO rather than SO.) — Martin Sleziak 10 hours ago

It is to be expected that if you run things like this, they query will time out if there are many entries. And possibly you might run into the fact that you can get only limited number of results from SEDE. One thing which could make your queries faster is using the table PostTags. You could use coalesce to get both questions and answers. An example: questions, Answers, ... — Martin Sleziak 20 mins ago

... both questions and answers and comments on both questions and answers. — Martin Sleziak 19 mins ago

Q: SO Dataset query to retrieve questions, related answers and comments with a specific question tag

For a small part of my master thesis I need to retrieve a dataset from SEDE that contains all questions as well as the related multiple answers (and if possible also comments) with the tag "text-mining" in order to put questions and related answers (and likely also the comments) in a corpus. My c...

support stack-overflow tags data-explorer

A: SO Dataset query to retrieve questions, related answers and comments with a specific question tag

You're right, tags (and title and number of views) are only stored for questions, not answers. That means that for answers, you need to JOIN the Posts table with itself, like this query. Because the size of the Stack Overflow database is quite large, it might be helpful to introduce more joins to...