Bitcoin Forum
October 18, 2018, 02:59:37 PM *
News: Make sure you are not using versions of Bitcoin Core other than 0.17.0 [Torrent], 0.16.3, 0.15.2, or 0.14.3. More info.
 
   Home   Help Search Donate Login Register  
Pages: [1] 2 3 4 5 6 7 »  All
  Print  
Author Topic: LoyceV's Merit data analysis (full data since Jan. 24, 2018; not just 120 days)  (Read 3829 times)
LoyceV
Legendary
*
Offline Offline

Activity: 1274
Merit: 2134


Self-made Legendary!


View Profile WWW
March 06, 2018, 10:24:24 PM
Merited by Welsh (10), Foxpup (6), dbshck (5), mprep (3), Vod (2), malevolent (2), BitMaxz (2), rickbig41 (2), BTCforJoe (2), mithrim (2), suchmoon (1), Timelord2067 (1), EcuaMobi (1), LFC_Bitcoin (1), MadZ (1), MissionPhailed (1), criz2fer (1), boranes (1), Coin-1 (1), vlad230 (1), Coins4Days (1), Alone055 (1)
 #1

This thread is work in progress.
Note: I don't want to delete data. Weekly updates are added as new posts at the end of this thread, not to the OP.



Permanent links (updated weekly):
theymos' raw data (format: time    amount    msg    user_from    user_to)
Full list (full data since January 24, 2018; not limited to 120 days).

theymos' data (human readable format, including usernames and post titles)
Full list (big file!)

Usernames to go with theymos' data:
Full list




Theymos made raw Merit data available:
Here you go: https://bitcointalk.org/merit.txt.xz

Similar to trust.txt.xz, it'll be updated weekly. It will show only the last 120 days of data; someone else should archive the old ones if you want them.
I've been playing around a bit with the data, and in this topic I'll post anything worth noting. I would like to update this continuously from Recent merits, but that's for another day.

Usernames
See pastebin for usernames to go with theymos' userIDs.

Total number of users who earned 1 or more Merit: 10382
Click for the full list (format: "Merit username (#userID)")

Total number of users who gave away 1 or more sMerit: 9725
Click for the full list (format: "sMerit username (#userID)")

Occasions where the same user merited the same post twice at the exact same time
26 posts received the same number of Merit from the same user in the same second. This is caused by double clicking the Send button:
Two times 1 Merit from Syndikat to undercomander13 for this post.
Two times 4 Merit from minerbro to Piston_82 for this post.
Two times 1 Merit from newegggo to moonriver for this post.
Two times 4 Merit from aTriz to killyou72 for this post.
Two times 1 Merit from johhnyUA to Gerhald for this post.
Two times 1 Merit from TMAN to Lauda for this post.
Two times 1 Merit from TK14 to John(JohnK.) for this post.
Two times 1 Merit from JCbtc to 1Referee for this post.
Two times 1 Merit from Anna505 to Krjkee for this post.
Two times 1 Merit from Alluro to Smpdytz for this post.
Two times 1 Merit from AlexLvov to svv for this post.
Two times 1 Merit from williamevanl to centralbanksequalsbombs for this post.
Two times 1 Merit from n00bby to Undland for this post.
Two times 1 Merit from soy to Becassine for this post.
Two times 1 Merit from Dvach to AlexZHankok for this post.
Two times 1 Merit from miha74 to klim75 for this post.
Two times 6 Merit from pisston to ckorbba for this post.
Two times 1 Merit from sheamus10 to Asyifiah for this post.
Two times 5 Merit from SmartIphone to vlad230 for this post.
Two times 5 Merit from SmartIphone to hugeblack for this post.
Two times 5 Merit from SmartIphone to 01BTC for this post.
Two times 2 Merit from mellorbo to zzxswqq for this post.
Two times 5 Merit from julian071 to BTCMILLIONAIRE for this post.
Two times 1 Merit from siti25 to vlad230 for this post.
Two times 1 Merit from teddy5145 to marlboroza for this post.
Two times 1 Merit from aTriz to Craige288 for this post.

But, what I really wanted to create, is a list of users who earned (or bought) enough Merits to reach the next rank. This is also an indication of how well the Merit system performs.


TODO

Users who have already ranked up after earning Merits
Starting Rank (Merit), Current Rank (Merit), Current Activity

Users who have enough Merit to rank up once they get enough Activity
Current Rank, Current Merit, Current Activity

Users who received Merit, but not enough to reach the rank that fits their Activity

Total Merit received per Rank

Number of users per Rank who have received at least 1 Merit

1539874777
Hero Member
*
Offline Offline

Posts: 1539874777

View Profile Personal Message (Offline)

Ignore
1539874777
Reply with quote  #2

1539874777
Report to moderator
1539874777
Hero Member
*
Offline Offline

Posts: 1539874777

View Profile Personal Message (Offline)

Ignore
1539874777
Reply with quote  #2

1539874777
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1539874777
Hero Member
*
Offline Offline

Posts: 1539874777

View Profile Personal Message (Offline)

Ignore
1539874777
Reply with quote  #2

1539874777
Report to moderator
LTU_btc
Hero Member
*****
Offline Offline

Activity: 1022
Merit: 560

★YoBit.Net★ 350+ Coins Exchange & Dice


View Profile WWW
March 07, 2018, 12:16:29 AM
 #2

So, only 9725 users sent at least 1 their sMerit. I think ir's too small number and it shows that there are still so many users who aren't aware about Merit system. Bitcointalk has much more active users, if I'm not mistaken ~100k (you need to sign in to your account at least once per month to be considered as active user). Sometimes I'm checking spammy boards like Altcoin discussion, Bounties, Politics & Society and etc, then I open random profiles of Full Members and above, and guess what - mostly of these users haven't sent any single sMerit. Some users complaining that "Merit system aren't generating enough sMerit", "good posts aren't Merited" and etc. But how you can complain when people aren't using their sMerit first of all?
It will be interesting to see more data analysis posted.

Coins4Days
Member
**
Offline Offline

Activity: 280
Merit: 27

bit.ly/Coins4Hash


View Profile WWW
March 07, 2018, 12:22:38 AM
 #3

    Very nice! These statistics are going to be interesting. Seeing your to-do list has filled my head with a few more ideas.

  • Would it be possible to have a crawler take all of this information and cross-reference merits to each day of the week?
  • Total number of merits given out by each rank. Let's see who utilizes merits the most.
  • Total number of merits given out across each board. This will help us see where most posts are getting recognized and show what boards receive the least love (or the most shitposts).

LoyceV
Legendary
*
Offline Offline

Activity: 1274
Merit: 2134


Self-made Legendary!


View Profile WWW
March 07, 2018, 09:43:32 AM
 #4

Would it be possible to have a crawler take all of this information and cross-reference merits to each day of the week?
That's actually very easy to do from theymos' data:

Monday 9430 (10.63%)
Tuesday 10060 (11.34%)
Wednesday 10942 (12.33%)
Thursday 22816 (25.72%)
Friday 14446 (16.28%)
Saturday 11063 (12.47%)
Sunday 9946 (11.21%)
Total: 88703

Thursday seems to be a good day, but the Merit system was introduced on a Thursday. The large amount sent on Thursdays could very well be from the first day (I didn't check this further).

Quote
Total number of merits given out by each rank. Let's see who utilizes merits the most.
This will take a bit longer.

Quote
Total number of merits given out across each board.
Ideally, https://bitcointalk.org/ should just show that on the main page. But I'll add it to my list.

Jet Cash
Legendary
*
Online Online

Activity: 1036
Merit: 1251


I don't merit Spambies


View Profile WWW
March 07, 2018, 09:56:58 AM
Merited by suchmoon (1)
 #5

Thanks for creating this, it's interesting reading, although I haven't looked in depth.

I haven't heard of most of the top awarders - are they active on the  alt coin and bounty boards.

Would it be possible to provide information on awards on specific boards, such as the Beginners and the Frog Pond. Wasn't the merit system designed to encourage quality posting on the information and help boards about Bitcoin.

TheQuin
Hero Member
*****
Offline Offline

Activity: 700
Merit: 672


Freebitco.in Forum Dude https://bit.ly/2I9BVS2


View Profile WWW
March 07, 2018, 10:42:21 AM
 #6

Occasions where the same user merited the same post twice at the exact same time
26 posts received the same number of Merit from the same user in the same second. I assume those "double Merits" were accidental:

That happens if you hit refresh after sending merit. https://bitcointalk.org/index.php?topic=2818350.msg29197764#msg29197764

I've never done it but I did receive 1 + 1 for the same post from someone I assume had found that bug/feature.

LoyceV
Legendary
*
Offline Offline

Activity: 1274
Merit: 2134


Self-made Legendary!


View Profile WWW
March 07, 2018, 12:23:30 PM
 #7

That happens if you hit refresh after sending merit. https://bitcointalk.org/index.php?topic=2818350.msg29197764#msg29197764
I've seen that bug before, but I doubt that happens at the same second. User "bitart" isn't in my list of people who sent Merit twice in one second.

TheQuin
Hero Member
*****
Offline Offline

Activity: 700
Merit: 672


Freebitco.in Forum Dude https://bit.ly/2I9BVS2


View Profile WWW
March 07, 2018, 12:34:59 PM
 #8

That happens if you hit refresh after sending merit. https://bitcointalk.org/index.php?topic=2818350.msg29197764#msg29197764
I've seen that bug before, but I doubt that happens at the same second. User "bitart" isn't in my list of people who sent Merit twice in one second.

It's obviously possible to do it slower than 1 second which would explain bitart's absence from the data. I was just thinking it would be odd if there was another bug that caused the same thing.

Anyway thanks for doing this, the site stats cutting the lists off at 50 is very limiting. I'm also looking forward to the ranking stats. That'll not only find the cheats but also show that people can still rank up if they deserve it.

suchmoon
Legendary
*
Offline Offline

Activity: 1736
Merit: 1789



View Profile
March 07, 2018, 04:52:26 PM
 #9

That happens if you hit refresh after sending merit. https://bitcointalk.org/index.php?topic=2818350.msg29197764#msg29197764
I've seen that bug before, but I doubt that happens at the same second. User "bitart" isn't in my list of people who sent Merit twice in one second.

It's obviously possible to do it slower than 1 second which would explain bitart's absence from the data. I was just thinking it would be odd if there was another bug that caused the same thing.


Double-clicking the button perhaps?

TheQuin
Hero Member
*****
Offline Offline

Activity: 700
Merit: 672


Freebitco.in Forum Dude https://bit.ly/2I9BVS2


View Profile WWW
March 07, 2018, 05:23:23 PM
 #10

That happens if you hit refresh after sending merit. https://bitcointalk.org/index.php?topic=2818350.msg29197764#msg29197764
I've seen that bug before, but I doubt that happens at the same second. User "bitart" isn't in my list of people who sent Merit twice in one second.

It's obviously possible to do it slower than 1 second which would explain bitart's absence from the data. I was just thinking it would be odd if there was another bug that caused the same thing.


Double-clicking the button perhaps?

Ah the fat finger bug, I hadn't thought of that. It could be, now I need to find a post worth two merit to see if I can replicate it.

TMAN
Hero Member
*****
Offline Offline

Activity: 938
Merit: 1169



View Profile
March 07, 2018, 05:52:19 PM
 #11

I've done it a few times I think. If memory serves me right I actually did it with 10 merits. Easily done

.FORTUNE.JACK.
      ▄▄███████▄▄
   ▄████▀▀ ▄ ██████▄
  ████ ▄▄███ ████████
 █████▌▐███▌ ▀▄ ▀█████
███████▄██▀▀▀▀▄████████
█████▀▄▄▄▄█████████████
████▄▄▄▄ █████████████
 ██████▌ ███▀████████
  ███████▄▀▄████████
   ▀█████▀▀███████▀
      ▀▀██████▀▀
         
         █
...FortuneJack.com                                             
...THE BIGGEST BITCOIN GAMBLING SITE
       ▄▄█████████▄▄
    ▄█████████████████▄
  ▄█████████████████████▄
 ▄██
█████████▀███████████▄
██████████▀   ▀██████████
█████████▀       ▀█████████
████████           ████████
████████▄   ▄ ▄   ▄████████
██████████▀   ▀██████████
 ▀██
█████████████████████▀
  ▀██
███████████████████▀
    ▀█████████████████▀
       ▀▀█████████▀▀
#JACKMATE
WIN 1 BTC
▄█████████████████████████▄
███████████████████████████
███████████████████████████
██████████▀█████▀██████████
███████▀░░▀░░░░░▀░░▀███████
██████▌░░░░░░░░░░░░░▐██████
██████░░░░██░░░██░░░░██████
█████▌░░░░▀▀░░░▀▀░░░░▐█████
██████▄░░▄▄▄░░░▄▄▄░░▄██████
████████▄▄███████▄▄████████

███████████████████████████
███████████████████████████
▀█████████████████████████▀


The Avatar:
MadZ
Hero Member
*****
Offline Offline

Activity: 823
Merit: 581


View Profile
March 08, 2018, 03:07:09 AM
 #12

Cool stats! Since you've already managed to sort by day of the week, would it be possible to see how merit distribution has changed over time (more or less being sent out now than at the beginning).
suchmoon
Legendary
*
Offline Offline

Activity: 1736
Merit: 1789



View Profile
March 08, 2018, 03:39:31 AM
Merited by MadZ (1)
 #13

Cool stats! Since you've already managed to sort by day of the week, would it be possible to see how merit distribution has changed over time (more or less being sent out now than at the beginning).


MadZ
Hero Member
*****
Offline Offline

Activity: 823
Merit: 581


View Profile
March 08, 2018, 04:18:21 AM
 #14

snip

Haha that was fast, this is exactly what I was thinking of. I wonder if we'll see a stabilization over time as more source merit comes into the system. Right now it looks as if the initial supply of sMerit is still drying up, more merit was sent in the first week than the entire time month following that week.
tbct_mt2
Full Member
***
Online Online

Activity: 434
Merit: 136



View Profile
March 08, 2018, 04:31:59 PM
 #15

~
I can help you to do statistical analysis for your objectives if I can get datasets. I am not familiar (actually don't know how to get data from the forum). Raw dataset contains very little information. We need more variables to do analysis.  Grin

LoyceMobile
Member
**
Offline Offline

Activity: 132
Merit: 25


View Profile
March 08, 2018, 04:43:40 PM
 #16

~
I can help you to do statistical analysis for your objectives if I can get datasets. I am not familiar (actually don't know how to get data from the forum). Raw dataset contains very little information. We need more variables to do analysis.  Grin
I'm currently too ill to do anything. What more data do you want?

LoyceV on the road (or in bed)
Don't deal with this account (untrusted devices)
tbct_mt2
Full Member
***
Online Online

Activity: 434
Merit: 136



View Profile
March 08, 2018, 04:49:10 PM
 #17

~
I can help you to do statistical analysis for your objectives if I can get datasets. I am not familiar (actually don't know how to get data from the forum). Raw dataset contains very little information. We need more variables to do analysis.  Grin
I'm currently too ill to do anything. What more data do you want?
More variables such as ranks of merit senders/receivers; total number of  rewarded merit points for each board; total number of merits (received/ sent) for each users. It's for new-comers in crypto ecosystem.

LoyceV
Legendary
*
Offline Offline

Activity: 1274
Merit: 2134


Self-made Legendary!


View Profile WWW
March 08, 2018, 08:46:14 PM
 #18

More variables such as ranks of merit senders/receivers
This is a bit tricky, as I can't have real-time Merit data. I'm still trying to figure out the best way to determine how many "free" Merits an account had received.

Quote
total number of  rewarded merit points for each board
For this, I'll have to download all posts and check the board they're on. It's on my list.

Quote
total number of merits (received/ sent) for each users. It's for new-comers in crypto ecosystem.
I already did that:
Total number of users who earned 1 or more Merit: 10382
Click for the full list (format: "Merit username (#userID)")

Total number of users who gave away 1 or more sMerit: 9725
Click for the full list (format: "sMerit username (#userID)")

I'm also curious to see what percentage of Merit is given to the first post of threads, and what percentage to posts inside threads.

tbct_mt2
Full Member
***
Online Online

Activity: 434
Merit: 136



View Profile
March 09, 2018, 08:29:54 AM
 #19

--snip--
Thanks, LoyceV. I don't have skills to do those things (getting data from raw data published by Theymos) because I am not IT technician. I simply have ability to analyze data; if you get more detailed datasets which contains more variables, I can help you. If you interested, I can help you.

suchmoon
Legendary
*
Offline Offline

Activity: 1736
Merit: 1789



View Profile
March 09, 2018, 10:54:17 PM
 #20

I'm also curious to see what percentage of Merit is given to the first post of threads, and what percentage to posts inside threads.

Since I'm digging through the data anyways... - https://pastebin.com/Cf8PDFAg

This is a list of first posts in merited threads. The ones marked with "off limits" are either deleted posts or posts in "privileged" areas (e.g. Ivory Tower) that require to be logged in. Can't vouch for 100% accuracy but I spot checked a few and it looked ok. So if the "msg" field in the merit export matches one of those then it's the first post in the thread.

Based on that:



To be fair, this is heavily skewed due to people meriting theymos' merit announcement thread, satoshi's thread, HODL thread etc.

Pages: [1] 2 3 4 5 6 7 »  All
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!