<…>
We really have to be careful using data to retrieve useful close to truthful information. What you have done is divide personal total merit by number of posts, and that is conceptually wrong on two account:
- The merit column represents the profiles total merit, including airdropped merit (not just earned merit).
- Posts accounts for all the posting history (not narrowed down to Merit era or more recent).
everyone who registered before the merit system got the airdropped merit, so i
thought comparing those who got the airdropped merit to one another is not wrong since they all had the same base record based on their activities/post by then. so eventually that should takes out the airdropped merit out of calculation, at least mathematically speaking.but this will be unfair to those who did not witness the airdrop, so you are right, the data we have now is far from accurate to be treated the way i treated it, seems like the vast majority of the best merit ratio members are only at their rank simply because they got the airdrop merit and never really posted after or before that, which brings their post count close to nothing allowing them to be on the top list. maybe the airdropped merits should have been given in a better form. take a look at this guy for insanse >
https://bitcointalksearch.org/user/lucky009-957841 . got 100 merit airdropped with only 12 posts.
but you have a valid point in this, for this to be a more accurate representation of post quality , we need to count only the earned merits. in which case a few unknown members have some very good ratio.
I will be looking at your analysis along side with LoyceV's , thanks for the input.
This thread lists the anomalies who did something weird, not the ones who actually earned that much Merit for real posts. Even worse: it includes the airdropped Merit, which wasn't earned at all.
If you get me a list of userIDs, I can list them in the format as below.
ya i have no clue why i ended up posting the abnormal and weird accounts, but honestly that's the db has, most of the top 100 members i got after taking the merit to post ratio into count were some crazy shit and merit abused, but mathematically speaking, there is nothing wrong with the list
, most other top merited people had their airdropped merits too, so that alone is not the main cause for this terrible report, the main reason is that most of those people stopped posting after they got the the pre merit,which made their ratio far too good to be true.
the query was nothing fancy really, just a simple straight forward
select username , (merit/posts) from table order by (meriy/posts) desc limit 20
i would like to see you run the data on those, as for now i have no clue how to get the earned merits only as it's not on piggy's db, are you using some script to pull the data or someone has another db for it?
anyway I will try to give you a list of userIds that have earned the merit with good ratio but for now all i have in hand is the merit count, i will be ignoring fixed numbers such 100,250,500,1000 which i believe those represent the airdroped merit. but that still will require some manual work.
cheers.
it is not impossible, it is not even hard, you get merits you post on boards you are good at, and you can help others. by doing so , you will get merits without even trying. it's true that the merit system is not perfect, but to a very good extent it does represent one's posts's quality. so just focus on what you good at.