Questions tagged [stackexchange]
Questions about Stack Exchange APIs, Stack Exchange Data Explorer (SEDE), or any hacks to work with Stack Exchange sites.
167
questions
1
vote
0
answers
53
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
...
- 123
3
votes
1
answer
95
views
3
votes
0
answers
32
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% ...
- 613
7
votes
2
answers
815
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.
...
- 369
2
votes
1
answer
228
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
47
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 ...
- 295
10
votes
2
answers
487
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 ...
- 42.4k
1
vote
1
answer
112
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
2
votes
1
answer
38
views
stat the word count for a given stackexchange user
Sometimes I would like use word count to describe someone's contribution, so, I wrote a query to stat the word count for a given stackexchange user, based on SEDE. click to run it online
...
- 121
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 ...
- 65k
3
votes
2
answers
158
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 ...
- 193
6
votes
1
answer
79
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 ...
- 42.4k
7
votes
1
answer
83
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.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 ...
- 199
3
votes
1
answer
105
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,089
3
votes
1
answer
77
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 ...
- 792
7
votes
1
answer
414
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
99
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.2k
5
votes
1
answer
70
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
171
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
399
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
113
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
63
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.2k
3
votes
0
answers
642
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
4
votes
1
answer
56
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 @...
- 505
4
votes
1
answer
276
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
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.
...
- 19.2k
11
votes
1
answer
109
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.2k
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.2k
3
votes
1
answer
87
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.5k
2
votes
1
answer
111
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 ...
- 935
1
vote
1
answer
67
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.
...
- 935
5
votes
2
answers
87
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.
...
- 266
4
votes
1
answer
137
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 ...
- 42.4k
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? ...
- 421
3
votes
1
answer
75
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,258
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 ...
- 453
15
votes
2
answers
775
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
401
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 ...
- 74.9k
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 ...
- 42.4k
4
votes
1
answer
81
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,347
11
votes
4
answers
535
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,146
11
votes
2
answers
242
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.2k
8
votes
1
answer
414
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.3k
7
votes
2
answers
105
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 ...
- 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....
- 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 ...
- 11.6k
6
votes
1
answer
62
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 ...
- 648
2
votes
0
answers
46
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.
...
- 911