« first day (2991 days earlier)      last day (87 days later) » 

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

Charlotte Bahrfor 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
2
Q: SO Dataset query to retrieve questions, related answers and comments with a specific question tag

Charlotte BahrFor 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...

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

GlorfindelYou'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...

 

« first day (2991 days earlier)      last day (87 days later) »