Questions tagged [stackexchange]
Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.
170 questions
2
votes
1
answer
116
views
Determining the least dangerous tags with over 1K answers to answer
So I thought I'd take another shot at making a SEDE query after being somewhat inactive after a while.
Essentially what this does is that it takes the tags that have at least 1000 answers for that tag ...
- 619
6
votes
1
answer
925
views
Show how close a user is to being unsung
So this morning, I decided to create a SEDE query that answers the age-old question "How close am I to being Unsung?" because I recently polished up my first SEDE query and I realized that I ...
- 619
2
votes
1
answer
73
views
SEDE query to count questions, views and unanswered for a set of tags
This query selects the number of SO questions, the number of views and the number of unanswered questions for each tag (the list of the tags is the user input). It works fine when it works, but it ...
- 645
2
votes
1
answer
115
views
Web-scraping bountied questions from Stack Exchange sites
I recently built my first web scraper in Python and decided to use Stack Overflow (SO) and Stack Exchange (SE) as test websites.
Code
...
- 133
3
votes
1
answer
125
views
SE Data Explorer: Users by City
I view users by city using this SQL query:
...
3
votes
0
answers
47
views
SEDE query calculating user reputation averages
I've created the following SEDE query which calculates the reputation averages of users on a particular site. It also optionally excludes "new" users (users with rep of 1 or 101 so note 100% ...
- 623
7
votes
2
answers
882
views
Finding solutions on GitHub and Stack Overflow
The first part of the code opens Chrome and navigates to GitHub. If I don't find my solution, I open a new tab with ctrlt. Then my code goes to Stack Overflow and searches there for solutions.
...
- 389
2
votes
1
answer
291
views
How to make this query better (e.g. avoid repeating subquery in a query)?
Stack Exchange provides access to query their MS SQL databases. They have a table Posts where each post is either a question or an answer (see the schema on right ...
- 121
5
votes
1
answer
70
views
Listing my StackEchange communities user id
Extending this answer solution, I've wrote the following bash script to get the html of my StackExchange accounts page and parse it to a YAML file. The objective ...
- 285
10
votes
2
answers
557
views
Stack Exchange review queue notifications
A couple of days ago a user in chat asked us to spend more time in the queues. Kick starting my desire to get notifications for new items in the queues.
Reviewing the queues has been something I've ...
- 44.6k
1
vote
1
answer
153
views
Get average post score of TOP 10 tags on StackOverflow using Stack Exchange Data Explorer
I want to use the Stack exchange data explorer in order to display some basic information about the top tags.
The query should print the number of questions and answers, the average number of answers ...
- 129
5
votes
1
answer
74
views
State the word count for a given Stack Exchange user
Sometimes I like to use word count to describe someone's contributions to Stack Exchange, so I wrote a query to state the word count for a given Stack Exchange user using SEDE. click to run it online
<...
- 151
21
votes
4
answers
2k
views
CodeReview question markdown downloader
This is an update to my earlier question From Q to compiler in less than 30 seconds.
As with that version, this Python script automatically downloads the markdown from any question on Code Review and ...
- 67.2k
3
votes
2
answers
193
views
Get a notification when questions get posted
I like to help people on StackOverflow, matter of fact nowadays it depends on how quick you are when answering question.
With that being said, I can't always keep a tab and an eye to refresh the ...
6
votes
1
answer
120
views
Stack Exchange graph data - helper modules
Building on previous reviews
Whilst not an iterative review I have tried to follow the advice provided to some of my older questions:
KISS, in some of my previous questions I've over complicated the ...
- 44.6k