Re:Websites That Feed Hacker News: Top Sources of Submission...
by pfarnsworth on Thursday April 14, 2016 @03:40PM
(#11499734)
You should do number of submissions where min_score > X (maybe 5 or so). This will help filter out the spam submissions that no one ever sees.
Re:Websites That Feed Hacker News: Top Sources of Submission...
by anton_tarasenko on Thursday April 14, 2016 @03:51PM
(#11499814)
This is how it looks then: https://docs.google.com/spreadsheets/d/1hRpEmkV26VQSN2q_X9_B...
After SeanDav's question and minimaxir's comment, I summed up reposts' scores before computing the mean and the median:
HN news sources by mean score: https://docs.google.com/spreadsheets/d/1tTDDG2xg7OVKdUy4WCZ_...
HN news sources by median score: https://docs.google.com/spreadsheets/d/1P20sKg-fI6msZVZtJFe0...
HN news sources by number of submissions: https://docs.google.com/spreadsheets/d/1mmfbNWaX0Nr1P65VmwZp...
SQL code: https://github.com/antontarasenko/smq/blob/master/hackernews...
How-to: https://github.com/antontarasenko/smq