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
129
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
929
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
119
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
126
views
SE Data Explorer: Users by City
I view users by city using this SQL query:
...
3
votes
0
answers
49
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
884
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
297
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
76
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
564
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.5k
1
vote
1
answer
165
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
78
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
194
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
121
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.5k
8
votes
1
answer
116
views
Zombie killers ranking
Code Review has a Zombie Problem and, in comparison to The Walking Dead TV Show, our survival doesn't depend on killing them all day every day.
As a potential solution, I though it would be ...
- 12.7k
4
votes
1
answer
81
views
A tiny util to converts an SO URL to revised version
I am trying to write a util that converts an SO URL to revised version, for example, given this url:
'https://stackoverflow.com/q/57449318/10731613'
this util ...
- 181
3
votes
1
answer
131
views
Determine fragment identifier from HTML page in Swift
For an iOS app which helps me rolling back vandalism on Stack Exchange, I have a piece of Swift code which downloads a revision page (example) and tries to find the 'spacer' fragment just above a ...
- 1,113
4
votes
1
answer
99
views
Get list of new questions from Stack Overflow
I would like to write a little pet project using Clojure to study it, something like Stack Overflow client.
Here is a my first code to get list of new questions from site. I am in the very beginning ...
- 812
7
votes
1
answer
450
views
Scraper to grab a Stack Overflow profile name
I've created a script in Python to log into stackoverflow.com using credentials and fetch the profilename once logged in. I've tried to do it using class. I created the methods within that class in ...
- 545
3
votes
1
answer
123
views
Easy to use code preparation script for CodeReview questions
We all face questions that forget to include their code. Sometimes all of it, sometimes only parts, that make the rest of the question unfortunately incomplete and therefore off-topic.
What if it was ...
- 19.7k
5
votes
1
answer
89
views
SEDE query to calculate net migrations quarterly from ELU to ELL
Over on EL&U Meta, someone raised the question of how many net migrations there are to/from our sister site, ELL.
The following SEDE query calculates the net migrations by quarter (...
- 152
8
votes
1
answer
187
views
Python tool to assemble CodeReview posts from source files
I hate having to format questions around here. Adding four spaces to each source file and the correct name at the top of each source file becomes a headache when I have to post longer questions.
This ...
- 882
2
votes
1
answer
495
views
Tampermonkey script to beautify related tags in Stack Exchange
I've got the following code which is ran inside tampermonkey (It's a userscript), but there is a variable that is being declared, used, then overwritten by the next line. I'm looking for a way to ...
- 466
6
votes
2
answers
156
views
Find how much reputation a user had on a given date
I saw this question on MSE and went ahead and wrote a solution to it:
https://meta.stackexchange.com/questions/313561/determining-users-reputation-as-of-particular-date
This calculates the ...
- 330
6
votes
1
answer
87
views
Condensing a Table
Among the mod-tools there is a few that are intended to just help get a bird's eye perspective on what happens on the site. These tools generally consist of tables. Tables over tables.
Stuff that ...
- 25.5k
3
votes
0
answers
678
views
Scraping StackOverflow's questions with Node.js
I'm new to node and web scraping in general but with some research I've written this working code.
My goal is to get all questions from X Stack Overflow's pages sorted by most rated and save that ...
- 31
7
votes
1
answer
1k
views
Importing XML dump of Stack Overflow questions and answers into SQLite3
I have a 60gb+ XML file and, as you can see, I am using a Python script to extract the data and execute 'INSERT' statements to update my database.
Being that the file is so large, will I run into ...
- 171
5
votes
1
answer
78
views
Stack Overflow Tag Usage
I am trying to efficiently use the SEDE tool to get a list of tags a user has answered questions on, and their stats on each Tag.
My code works for my account in 3185 ms, but if I try to run it on @...
- 515
4
votes
1
answer
322
views
iOS Swift 3 app that requests data from the Stack Exchange API
This is my first Swift app, so I want to improve everything that I can about my code and know what I can do better. The app requests 10 developers from StackExchange API and displays them in a table ...
9
votes
1
answer
164
views
The seasoned Zombie sniper: a query to find unanswered questions with specific tags
The query (on SEDE)
This query builds upon the previous and includes the suggestions by rofl as well as the now mentioned activity index.
...
- 19.7k
11
votes
1
answer
149
views
The sniper: a Zombie searcher for specific tags
Sometimes, it's not enough to know what the easy prey is. You also need to know whether you will be able to hunt it down. What good is an almost turned haskell zombie if you cannot read the functional ...
- 19.7k
15
votes
1
answer
1k
views
A wounded Zombie finder, or: how to find the almost dead undead?
The Zombies are on their way to eat our statistics. Fortunately, we have a way to get rid of them: our votes. However, we need to find them first. The /unanswered section is too large and contains ...
- 19.7k
3
votes
1
answer
119
views
Beating the queue
Inspired by this question on CodeReview, and because I'm never able to beat the queue.
I'm just too slow I guess.. :(
I made a little python utility that reads the queue's information every 30 ...
- 11.8k
3
votes
1
answer
164
views
SE main site tag ratings based on Wilson score confidence interval
In "How Not To Sort By Average Rating", Evan Miller explained in simple terms and demonstrated with compelling examples that the usual naïve methods of calculating the average rating are ...
- 1,230
1
vote
1
answer
118
views
Posts that probably need editing
I wrote this Data Explorer query (reproduced below) some time ago that helped identify posts containing potential spelling/punctuation errors and earned me a Copy Editor badge on Anime.SE.
...
- 1,230
5
votes
2
answers
135
views
Bookmarklet that helps Stack Exchange users farm reputation
I made a bookmarklet called RepAdvisor (more info at this link) that rates Stack Overflow questions based on how easy it is to gain reputation by answering them.
...
- 184
4
votes
1
answer
156
views
Onebox hider for Stack Exchange chat
I sometimes don't like to look at images in chat. When they're just a URL then I'm fine, as then I have the choice to look at the image or not, and blends in with the other text. Therefore, I decided ...
- 44.5k
2
votes
2
answers
110
views
Fetching the total amount of SE reputation accumulated
Since I am new to R, I have pulled this code together in kind of a rag-tag way, but I am wondering, is there something similar to list comprehensions (in Python) I can use in R to make this simpler? ...
- 421
3
votes
1
answer
97
views
IGB Stack Flair – A dynamic flair for Stack Exchange sites
I created the Stackapp IGB Stack Flair a while ago and I think it's a good time for a revision now. Is there anything that can be done better, shorter, more elegant, more performant, etc.?
I thought ...
- 1,278
7
votes
1
answer
484
views
PANDAS DataFrame operations to analyze top Server Fault tags [closed]
I am working on learning how to do frequency analysis of Server Fault question tags to see if there is any useful data that I can glean from them. I'm storing the raw data in Bitbucket for global ...
- 463
15
votes
2
answers
839
views
Badger - The tumbleweed detector
I have written a small program to query the Stack Exchange API, specifically for badges. The main idea of the program is to return the new list of Tumbleweed posts on Stack Overflow, every 10 minutes. ...
- 293
10
votes
2
answers
440
views
Who are these lurkers?
Last night in The 2nd Monitor there was a discussion about postless users - I wanted to see how many there are, whether they're one-timers that showed up once, registered and never came back, and ...
- 75.6k
17
votes
1
answer
3k
views
Where are my downvotes?
I've been thinking my posts aren't that great, and so I've been wanting to improve them.
One sure fire way to do this is to look at all of my downvoted posts.
Not knowing if Stack Exchange allows you ...
- 44.5k
5
votes
1
answer
118
views
SmokeDetector report notifier
This script is a userscript designed for giving a notification when the bot SmokeDetector posts a message in the Charcoal HQ or any other room were he is active.
The script has 3 modes of operating, ...
- 1,357
11
votes
4
answers
564
views
Simple CodeReview Questions Notifications for OSX
Some days ago, I figured out that I'd like to get a notification every time a new question is asked here. So, I've made a really simple Python script, which uses ...
- 9,316
10
votes
2
answers
268
views
Showing links to Contributor Breakdown on Stackoverflow Docs
So Stackoverflow Documentation has added "Contributor Breakdown". For any given topic (and example) people can display who contributed in which way.
That page is only available if you know the link ...
- 25.5k
9
votes
1
answer
480
views
Load and parse Stack Exchange data dump XML into DB table
I have put together a stored procedure to load and parse the Stack Exchange Data Dump into a relational database (akin to Stack Exchange Data Explorer). Each site has 8 XML files like these:
The ...
- 20.5k
7
votes
2
answers
126
views
Add timeline link to questions and answers on Stack Exchange
The following script is meant to be a user script, but it should work on the console. It takes the id of the question and adds the corresponding /posts/id/timeline ...
- 261
7
votes
1
answer
99
views
Who likes that post?
Following on from my last question, I've been continuing to look at what information is available from the SE Data Explorer, I thought it would be interesting to know who else had favorited a question....
- 11.8k