3 ms·
The link is updated to reflect the following After SeanDav's question and minimaxir's comment, I summed up reposts' scores before computing the mean and the me
by anton_tarasenko 10y ago
The link is updated to reflect the following
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_5__17u_IOM4WPpbmnZDbxUI/edit?usp=sharing https://docs.google.com/spreadsheets/d/1tTDDG2xg7OVKdUy4WCZ_...
HN news sources by median score: https://docs.google.com/spreadsheets/d/1P20sKg-fI6msZVZtJFe0UHozX94AUINsiG_-1mbpaoo/edit?usp=sharing https://docs.google.com/spreadsheets/d/1P20sKg-fI6msZVZtJFe0...
HN news sources by number of submissions: https://docs.google.com/spreadsheets/d/1mmfbNWaX0Nr1P65VmwZpm4WiceK7pepknSob4ti0M7s/edit?usp=sharing https://docs.google.com/spreadsheets/d/1mmfbNWaX0Nr1P65VmwZp...
SQL code: https://github.com/antontarasenko/smq/blob/master/hackernews/top-domains-median.sql https://github.com/antontarasenko/smq/blob/master/hackernews...
How-to: https://github.com/antontarasenko/smq https://github.com/antontarasenko/smq
- pfarnsworth 10y agoYou 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.
- anton_tarasenko 10y agoThis is how it looks then: https://docs.google.com/spreadsheets/d/1hRpEmkV26VQSN2q_X9_BXoNP7MHvuyjCrJJLWt6NExA/edit?usp=sharing https://docs.google.com/spreadsheets/d/1hRpEmkV26VQSN2q_X9_B...