Skip to main content
Code Review

Questions tagged [stackexchange]

Ask Question

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

170 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
131 views

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 ...
CrSb0001's user avatar
  • 619
6 votes
1 answer
931 views

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
  • 619
2 votes
1 answer
74 views

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
  • 645
2 votes
1 answer
119 views

I recently built my first web scraper in Python and decided to use Stack Overflow (SO) and Stack Exchange (SE) as test websites. Code ...
DialFrost's user avatar
  • 133
3 votes
1 answer
126 views

I view users by city using this SQL query: ...
Rawand Ahmed Shaswar's user avatar
  • 193
3 votes
0 answers
49 views

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
  • 623
7 votes
2 answers
885 views

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
  • 389
2 votes
1 answer
297 views

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
76 views

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
  • 285
10 votes
2 answers
564 views

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
  • 44.6k
1 vote
1 answer
167 views

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
80 views

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
  • 151
21 votes
4 answers
2k views

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
  • 67.2k
3 votes
2 answers
194 views

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 ...
Rawand Ahmed Shaswar's user avatar
  • 193
6 votes
1 answer
122 views

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
  • 44.6k
8 votes
1 answer
120 views

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.7k
4 votes
1 answer
81 views

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
  • 181
3 votes
1 answer
132 views

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,113
4 votes
1 answer
100 views

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
  • 812
7 votes
1 answer
450 views

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
  • 545
3 votes
1 answer
123 views

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.6k
5 votes
1 answer
89 views

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
188 views

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
497 views

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
  • 466
6 votes
2 answers
158 views

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
87 views

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.5k
3 votes
0 answers
678 views

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
  • 31
7 votes
1 answer
1k views

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
  • 171
5 votes
1 answer
78 views

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
322 views

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
  • 43
9 votes
1 answer
164 views

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.6k
11 votes
1 answer
150 views

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.6k
15 votes
1 answer
1k views

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.6k
3 votes
1 answer
119 views

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.8k
3 votes
1 answer
164 views

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 ...
Gao's user avatar
  • 1,230
1 vote
1 answer
120 views

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
  • 1,230
5 votes
2 answers
137 views

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
  • 184
4 votes
1 answer
156 views

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
  • 44.6k
2 votes
2 answers
112 views

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
98 views

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
  • 1,278
7 votes
1 answer
485 views

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
  • 463
15 votes
2 answers
840 views

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
  • 293
10 votes
2 answers
440 views

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
  • 75.6k
17 votes
1 answer
3k views

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
  • 44.6k
5 votes
1 answer
119 views

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
566 views

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
  • 9,316
10 votes
2 answers
268 views

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.5k
9 votes
1 answer
480 views

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.5k
7 votes
2 answers
126 views

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
  • 261
7 votes
1 answer
100 views

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.8k

1
2 3 4