You're a great data miner @tranthidung.
I keep following you and reading your messages.
Thank you.
Topic: Percentages of recent earned per total merits of artists in top-50-merited users (Read 237 times)
December 14, 2019, 06:10:15 AM
December 06, 2019, 02:28:36 AM
ABSTRACT:
* It means 50% of those 28 artists have have their recently earned merits account for 25.6% to 60.5% of their total merits, includes airdrop merits if they got airdrop merits.
Data sources:
How many of them listed in the last artists for the Art contest Vote?
The answer is 28 /50 (~ 56%). That is an impressive figure.
List of matched cases from the Art contest vote (data took from [2] and [3])
Sorting them out descendingly by rpt_merit:
- rpt_merit = recentmerit / tmerit *100
Details of 28 artists in the top 50 merited users, recently.
- 28/50 (~ 56%) of the top 50 recently merited-users come from the top 53 artists in [1]
- The minimum and maximum percentages of rpt_merit are 5.2% (LoyceV) and 100% (rare_designer).
- The median and interquartile range * of the percentage (for rpt_merit) is 49, and 25.6% to 60.5%, respectively (see the last code block for details)
* It means 50% of those 28 artists have have their recently earned merits account for 25.6% to 60.5% of their total merits, includes airdrop merits if they got airdrop merits.
Data sources:
- 10th anniversary art contest badge voting
- https://bitcointalk.org/index.php?action=merit;stats=topusers
- Top-100 merited-artists in the 10th anniversary art contest
Code:
+---------------------------------------------------+
| rank_recentmerit recentmerit username |
|---------------------------------------------------|
1. | 1 738 theymos |
2. | 2 501 dannybrown |
3. | 3 369 Kalemder |
4. | 4 318 1Dq |
5. | 5 292 Corrosive |
|---------------------------------------------------|
6. | 6 291 webtricks |
7. | 7 277 LoyceV |
8. | 8 272 taufik123 |
9. | 9 260 gmaxwell |
10. | 10 251 likehiro |
|---------------------------------------------------|
11. | 11 238 geophphreigh |
12. | 12 227 Ratimov |
13. | 13 224 fillippone |
14. | 14 221 otto_diesel |
15. | 15 209 KTChampions |
|---------------------------------------------------|
16. | 16 207 ZipReg |
17. | 17 204 mikeywith |
18. | 18 203 zasad@ |
19. | 19 196 DireWolfM14 |
20. | 20 193 wolwoo |
|---------------------------------------------------|
21. | 21 183 terizla |
22. | 22 183 Rikafip |
23. | 23 182 micgoossens |
24. | 24 180 tyKiwanuka |
25. | 25 179 tranthidung |
|---------------------------------------------------|
26. | 26 177 Basorexia |
27. | 27 171 RapTarX |
28. | 28 170 Vispilio |
29. | 29 169 noorman0 |
30. | 30 168 Veleor |
|---------------------------------------------------|
31. | 31 168 nc50lc |
32. | 32 167 Yatsan |
33. | 33 166 1miau |
34. | 34 157 rare_designer |
35. | 35 155 cryptoaddictchie |
|---------------------------------------------------|
36. | 36 152 sashapan |
37. | 37 150 ADAMA_NOW |
38. | 38 148 Twentyonepaylots |
39. | 39 147 sirazimuth |
40. | 40 145 ecnalubma |
|---------------------------------------------------|
41. | 41 144 madnessteat |
42. | 42 144 Last of the V8s |
43. | 43 144 DdmrDdmr |
44. | 44 142 Michail1 |
45. | 45 140 DroomieChikito |
|---------------------------------------------------|
46. | 46 139 cabalism13 |
47. | 47 138 summonerrk |
48. | 48 138 squatz1 |
49. | 49 136 bct_ail |
50. | 50 134 ibminer |
+---------------------------------------------------+
How many of them listed in the last artists for the Art contest Vote?
The answer is 28 /50 (~ 56%). That is an impressive figure.
Code:
Result # of obs.
-----------------------------------------
not matched 47
from master 22 (_merge==1)
from using 25 (_merge==2)
matched 28 (_merge==3)
-----------------------------------------
List of matched cases from the Art contest vote (data took from [2] and [3])
Code:
+------------------------------------------------------------------------+
| rank_recentmerit username recentmerit tmerit rpt_merit |
|------------------------------------------------------------------------|
1. | 2 dannybrown 501 871 57.5 |
2. | 3 Kalemder 369 1151 32.1 |
3. | 4 1Dq 318 561 56.7 |
4. | 5 Corrosive 292 876 33.3 |
5. | 6 webtricks 291 607 47.9 |
|------------------------------------------------------------------------|
6. | 7 LoyceV 277 5297 5.2 |
7. | 8 taufik123 272 530 51.3 |
8. | 10 likehiro 251 501 50.1 |
9. | 11 geophphreigh 238 283 84.1 |
10. | 14 otto_diesel 221 639 34.6 |
|------------------------------------------------------------------------|
11. | 16 ZipReg 207 398 52 |
12. | 19 DireWolfM14 196 1034 19 |
13. | 21 terizla 183 263 69.6 |
14. | 22 Rikafip 183 420 43.6 |
15. | 26 Basorexia 177 279 63.4 |
|------------------------------------------------------------------------|
16. | 29 noorman0 169 233 72.5 |
17. | 32 Yatsan 167 910 18.4 |
18. | 34 rare_designer 157 157 100 |
19. | 35 cryptoaddictchie 155 292 53.1 |
20. | 36 sashapan 152 155 98.1 |
|------------------------------------------------------------------------|
21. | 37 ADAMA_NOW 150 174 86.2 |
22. | 38 Twentyonepaylots 148 258 57.4 |
23. | 39 sirazimuth 147 1439 10.2 |
24. | 40 ecnalubma 145 400 36.3 |
25. | 44 Michail1 142 1151 12.3 |
|------------------------------------------------------------------------|
26. | 46 cabalism13 139 726 19.1 |
27. | 47 summonerrk 138 431 32 |
28. | 50 ibminer 134 1531 8.8 |
+------------------------------------------------------------------------+
Sorting them out descendingly by rpt_merit:
- rpt_merit = recentmerit / tmerit *100
Code:
+------------------------------------------------------------------------+
| rank_recentmerit username recentmerit tmerit rpt_merit |
|------------------------------------------------------------------------|
1. | 34 rare_designer 157 157 100 |
2. | 36 sashapan 152 155 98.1 |
3. | 37 ADAMA_NOW 150 174 86.2 |
4. | 11 geophphreigh 238 283 84.1 |
5. | 29 noorman0 169 233 72.5 |
|------------------------------------------------------------------------|
6. | 21 terizla 183 263 69.6 |
7. | 26 Basorexia 177 279 63.4 |
8. | 2 dannybrown 501 871 57.5 |
9. | 38 Twentyonepaylots 148 258 57.4 |
10. | 4 1Dq 318 561 56.7 |
|------------------------------------------------------------------------|
11. | 35 cryptoaddictchie 155 292 53.1 |
12. | 16 ZipReg 207 398 52 |
13. | 8 taufik123 272 530 51.3 |
14. | 10 likehiro 251 501 50.1 |
15. | 6 webtricks 291 607 47.9 |
|------------------------------------------------------------------------|
16. | 22 Rikafip 183 420 43.6 |
17. | 40 ecnalubma 145 400 36.3 |
18. | 14 otto_diesel 221 639 34.6 |
19. | 5 Corrosive 292 876 33.3 |
20. | 3 Kalemder 369 1151 32.1 |
|------------------------------------------------------------------------|
21. | 47 summonerrk 138 431 32 |
22. | 46 cabalism13 139 726 19.1 |
23. | 19 DireWolfM14 196 1034 19 |
24. | 32 Yatsan 167 910 18.4 |
25. | 44 Michail1 142 1151 12.3 |
|------------------------------------------------------------------------|
26. | 39 sirazimuth 147 1439 10.2 |
27. | 50 ibminer 134 1531 8.8 |
28. | 7 LoyceV 277 5297 5.2 |
+------------------------------------------------------------------------+
Details of 28 artists in the top 50 merited users, recently.
Code:
variable | N mean sd p50 p25 p75 min max
-------------+--------------------------------------------------------------------------------
rpt_merit | 28.0 46.6 26.7 49.0 25.6 60.5 5.2 100.0
----------------------------------------------------------------------------------------------
Jump to: