Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [stackexchange]

Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.

3
votes
0answers
23 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 (...
7
votes
1answer
148 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 ...
2
votes
1answer
76 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 ...
6
votes
2answers
91 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 ...
5
votes
1answer
49 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 ...
3
votes
0answers
97 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 ...
7
votes
1answer
79 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 ...
4
votes
1answer
48 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 @...
4
votes
1answer
113 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 ...
5
votes
0answers
51 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. ...
11
votes
1answer
84 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 ...
13
votes
1answer
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 ...
3
votes
1answer
74 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 ...
2
votes
1answer
76 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 flawed, and ...
1
vote
1answer
56 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. ...
5
votes
2answers
68 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. ...
4
votes
1answer
118 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 ...
2
votes
2answers
70 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? ...
2
votes
1answer
63 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 ...
6
votes
1answer
404 views

PANDAS DataFrame operations to analyze top Server Fault tags

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 ...
14
votes
2answers
457 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. ...
10
votes
2answers
386 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 ...
19
votes
1answer
2k 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 ...
4
votes
1answer
56 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, ...
11
votes
4answers
509 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 ...
10
votes
2answers
225 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 ...
8
votes
1answer
154 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 ...
6
votes
2answers
88 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 ...
7
votes
1answer
55 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....
7
votes
2answers
49 views

Retrieve high views per day questions with few answers

I've been messing around with the SE Data Explorer and I've come up with a query that basically returns information about questions that have a high number of views per day, that have few or no ...
3
votes
0answers
28 views

Data Explorer query that makes bar graphs

I wrote a query for SEDE that I think is pretty cool. It uses the currently available graphing capabilities (scatter plots) to create a bar graph. I have used it as the subject for a self-answer on ...
3
votes
0answers
30 views

Userscript to add Prettify extensions on SE

I wrote a userscript (to be run with Greasemonkey/Tampermonkey on Stack Exchange sites) to include a Prettify extension and enable syntax highlighting for a language which isn't supported by default. ...
10
votes
1answer
205 views

Accessing the Stack Exchange API

Part of a project I'm getting started on requires access to the Stack Exchange API for certain data, as a result I built a .NET implementation to interact with it. The implementation is pretty simple,...
9
votes
1answer
116 views

Top 10 editors partitioned by year

I wanted to get some stats on who has done the most edits on Code Review, so I wrote the following query on SE Data Explorer. All improvement suggestions are welcome. Note that I used a cursor to ...
5
votes
2answers
162 views

Adding links to tags on StackExchange sites

This Greasemonkey script adds links to tags on StackExchange sites which allow for activating, deactivating and ignoring favorite and related tags by using UI components. Since JavaScript is not my ...
13
votes
3answers
101 views

From Q to compiler in less than 30 seconds

As an adjunct to From new Q to compiler in 30 seconds, I've created a Python script to automatically download the markdown from any question on Code Review and save it to a local file using Unix-style ...
8
votes
1answer
120 views

Smoke the SmokeDetector

In Tavern on the Meta, our spam detector is a bot named SmokeDetector. While you can ignore the bot, you can't ignore specific replies to Smokey without ignoring users, so I wrote a UserScript to ...
15
votes
2answers
589 views

Stack Exchange Chat Caret Pathfinder

In The Nineteenth Byte, we have an excessive amount of carets (carrots, if you will) that direct one's attention to another message. For example: Amidst the confusion, I made a userscript that ...
23
votes
3answers
569 views

Stack Exchange User Activity Score

About This is a SEDE query which will calculate your activity and participation on a site. It's geared for Programming Puzzles & Code Golf where questions are values more, but the values can be ...
24
votes
3answers
681 views

Calculate questions per day on CodeGolf.SE

I wrote a short script in Python 3 that connects to the Stack Exchange API, gets all questions on Programming Puzzles & Code Golf over the past two weeks, and determines the average number of ...
7
votes
1answer
255 views

Stack Exchange API Python library

I wrote a package a few years ago to make my interactions with the Stack Exchange API more straightforward. I've maintained it over the years and used it in several scripts I've written that interact ...
69
votes
6answers
6k views

You hate h̶a̶t̶s̶ reputation? Click here to get rid of it

Soo... I recently read a meta-post about the inherent problems of reputation. It listed some things like: Confirmation bias. Demotivating for low-rep users. Hubris and elitism of high-rep users over ...
3
votes
2answers
60 views

What are the top voted comments on closed questions, and who made the comments?

Following this linked question and the feedback it generated, I put together a new query which utilizes a JOIN. ...
3
votes
1answer
66 views

What percentage of down votes are users responsible for?

I put together this simple query to calculate the percentage of downvotes each user is responsible for and displaying them in order of downvote percentage. It's generating the desired results, but I ...
7
votes
1answer
36 views

SEDE Query to Find… Weird Questio​n/Protect Combinations

I was interested in finding some of the weirdest question/protection combinations, basically out of curiosity. I heuristically defined this as: Low view counts Not a moderator/SE employee From users ...
5
votes
2answers
74 views

Top Python badged users from NYC

I forked this StackExchange Data Explorer (SEDE) query from another one, and made it a bit more complex. I'm looking for feedback on my style, as well as answers to other questions (see below). ...
2
votes
0answers
47 views

UserScript that tracks Views Since Last Visit

I try keep an eye on any questions or answers that I have posted here within the StackExchange network and I like to prioritize my updates and improvements based on ones that get frequent visits. I ...
10
votes
2answers
73 views

Badge Oneboxer for Chat.SE

This script makes it possible for badges to onebox in Chat. The install requires Tamper/GreaseMonkey. Click here to install, and it's on GitHub and StackApps! ...
10
votes
1answer
140 views

Chat.SE in Terminal

This is a script that accesses the SE impromptu APIs to receive the fkey, a variable need for connection to chatrooms, and uses it to build a websockets connection ...
4
votes
2answers
89 views

UserScript that summarizes Stack Exchange flag counts

I am working on a UserScript that displays total flag counts and other information on the Flag Summary page. Example: Everything is working correctly but this bit of code seems rather repetitive ...