Questions tagged [stackexchange]

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

Filter by
Sorted by
Tagged with
6 votes
1 answer
894 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 ...
CrSb0001's user avatar
  • 257
2 votes
0 answers
50 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 ...
Yulia V's user avatar
  • 635
1 vote
0 answers
66 views

Web-scraping bountied questions from Stack Exchange sites

I recently built my first web scraper in python, and decided to use SO and SE as test websites. Code ...
DialFrost's user avatar
  • 123
3 votes
1 answer
98 views

SE Data Explorer: Users by City

I view users by city using this SQL query: ...
excitedmicrobe's user avatar
3 votes
0 answers
35 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% ...
TheLethalCoder's user avatar
7 votes
2 answers
846 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. ...
bliboy's user avatar
  • 369
2 votes
1 answer
251 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 ...
Tim's user avatar
  • 121
5 votes
1 answer
48 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 ...
artu-hnrq's user avatar
  • 295
10 votes
2 answers
509 views

Stack Exchange rev​iew 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 ...
Peilonrayz's user avatar
  • 43.3k
1 vote
1 answer
114 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 ...
dan1st's user avatar
  • 129
5 votes
1 answer
54 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 <...
andrewngdl's user avatar
20 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 ...
Edward's user avatar
  • 66.4k
3 votes
2 answers
161 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 ...
excitedmicrobe's user avatar
6 votes
1 answer
83 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 ...
Peilonrayz's user avatar
  • 43.3k
7 votes
1 answer
84 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 ...
IEatBagels's user avatar
  • 12.4k
4 votes
1 answer
62 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 ...
JJJohn's user avatar
  • 199
3 votes
1 answer
108 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 ...
Glorfindel's user avatar
  • 1,089
3 votes
1 answer
82 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 ...
ceth's user avatar
  • 792
7 votes
1 answer
424 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 ...
MITHU's user avatar
  • 535
3 votes
1 answer
101 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 ...
Zeta's user avatar
  • 19.3k
5 votes
1 answer
71 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 (...
Dan Bron's user avatar
  • 152
8 votes
1 answer
172 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 ...
Gnik's user avatar
  • 882
2 votes
1 answer
446 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 ...
GrumpyCrouton's user avatar
6 votes
2 answers
115 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 ...
Magisch's user avatar
  • 330
6 votes
1 answer
66 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 ...
Vogel612's user avatar
  • 25.2k
3 votes
0 answers
659 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 ...
Régis B.'s user avatar
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 ...
Aaron Brandhagen's user avatar
5 votes
1 answer
59 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 @...
jrtapsell's user avatar
  • 515
4 votes
1 answer
281 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 ...
Eduard Valentin's user avatar
9 votes
1 answer
131 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. ...
Zeta's user avatar
  • 19.3k
11 votes
1 answer
111 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 ...
Zeta's user avatar
  • 19.3k
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 ...
Zeta's user avatar
  • 19.3k
3 votes
1 answer
89 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 ...
Ludisposed's user avatar
  • 11.5k
2 votes
1 answer
114 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 ...
Gao's user avatar
  • 935
1 vote
1 answer
71 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. ...
Gao's user avatar
  • 935
5 votes
2 answers
89 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. ...
clickbait's user avatar
  • 266
4 votes
1 answer
138 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 ...
Peilonrayz's user avatar
  • 43.3k
2 votes
2 answers
77 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? ...
Neil's user avatar
  • 421
3 votes
1 answer
76 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 ...
Gerold Broser's user avatar
7 votes
1 answer
463 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 ...
Sienna's user avatar
  • 453
15 votes
2 answers
784 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. ...
Bhargav Rao's user avatar
10 votes
2 answers
403 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 ...
Mathieu Guindon's user avatar
17 votes
1 answer
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 ...
Peilonrayz's user avatar
  • 43.3k
5 votes
1 answer
87 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, ...
Ferrybig's user avatar
  • 1,357
11 votes
4 answers
538 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 ...
Grajdeanu Alex's user avatar
10 votes
2 answers
245 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 ...
Vogel612's user avatar
  • 25.2k
9 votes
1 answer
444 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 ...
Phrancis's user avatar
  • 20.4k
7 votes
2 answers
106 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 ...
Braiam's user avatar
  • 223
7 votes
1 answer
62 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....
forsvarir's user avatar
  • 11.6k
7 votes
2 answers
56 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 ...
forsvarir's user avatar
  • 11.6k