4 ms·
We gave that some consideration, but the queries weren't all that interesting. The vast majority of those lists (something like 80%) consist of people with only
by chengmi 19y ago
We gave that some consideration, but the queries weren't all that interesting. The vast majority of those lists (something like 80%) consist of people with only one post. To illustrate this, here are the top tens for those queries:
Top Points per Submission
+-------------+------+----+---------+
| username | pts | ct | avg |
+-------------+------+----+---------+
| dwaters | 95 | 1 | 95.0000 |
| keesj | 78 | 1 | 78.0000 |
| brl | 122 | 2 | 61.0000 |
| a-kill-ease | 60 | 1 | 60.0000 |
| zombo | 58 | 1 | 58.0000 |
| markovich | 58 | 1 | 58.0000 |
| fresno | 55 | 1 | 55.0000 |
| jdale27 | 53 | 1 | 53.0000 |
| qwertyy | 48 | 1 | 48.0000 |
| jsomers | 48 | 1 | 48.0000 |
+-------------+------+----+---------+
Top Points per Comment
+------------+------+----+---------+
| username | pts | ct | avg |
+------------+------+----+---------+
| hazchem | 37 | 1 | 37.0000 |
| capablanca | 36 | 1 | 36.0000 |
| jdrake3 | 24 | 1 | 24.0000 |
| juanjose | 24 | 1 | 24.0000 |
| cetaganda | 41 | 2 | 20.5000 |
| cysh | 19 | 1 | 19.0000 |
| chime | 17 | 1 | 17.0000 |
| zamfi | 17 | 1 | 17.0000 |
| kilik | 17 | 1 | 17.0000 |
| loumf | 15 | 1 | 15.0000 |
+------------+------+----+---------+
- tlrobinson 19y agoIt might be interesting to see a scatter plot of number of submissions/comments vs. average points per submission/comment. What would be really cool is if you opened up a simple API or just the raw data so we could go wild with it :)
- deleted 19y ago[deleted]
- nostrademons 19y agoAdd a cutoff of, say, 10 comments or 10 posts...
- chengmi 19y agoDone. I set a minimum of 10 comments or 10 submissions to get on the list: http://searchyc.com/top/points_per_submission http://searchyc.com/top/points_per_submission http://searchyc.com/top/points_per_comment http://searchyc.com/top/points_per_comment
- Xichekolas 19y agoWould be neat to be able to see the pps and ppc values for an individual... I don't make either of those lists, but I'd be interested what my averages are.
- chengmi 19y agoNow when you search for your username on searchyc.com, you can see your stats: http://searchyc.com/Xichekolas http://searchyc.com/Xichekolas
- chengmi 19y agoI'll look into that when I have some time. +-------------+------+-----+--------+ | Xichekolas | pts | ct | avg | +-------------+------+-----+--------+ | Submissions | 64 | 7 | 9.1429 | +-------------+------+-----+--------+ | Comments | 497 | 199 | 2.4975 | +-------------+------+-----+--------+
- far33d 19y agoLike baseball statistics, these are only interesting if you have a minimum number of at-bats.
- bayareaguy 19y agoInteresting. Perhaps you could aggregate the numbers by time and compare the relative rates of change in karma and subissions for different time periods?