Analysis - Merited on multiple Subsections and the Correlation Matrix - Updated

[Stedsm]

Hey Ddmr, couldn't stop myself from bumping this.
Thanks for the most interesting data I've been trying to find all over the forum. Everything is now clear and easy to find that which section/subsection is really worth working on to get better number of merits, especially for newbies (not saying that sections other than those are not useful but they probably need proper knowledge and skills as you said, because as an example here, it is mostly tough for a native French speaker to earn a merit in an Indonesian local board if they ever try to do so.) While people roam here and there trying to post shit and increase their post count thereby trying to increase their merits with it, they should put in some effort to be really eligible for those merits. Some user here said that you really work hard for your merits and earn them, everyone should take a morale from this post and put in a lot of efforts and make us give that damn merit to them. I have a question here that I'm all confused about, where did you get all the data that you used in order to create these tabs with such a well-determined explanation? I mean from where did you get those numbers of users and their merits based on which you made all your calculations?

[1715517519]

1715517519

[1715517519]

1715517519

[1715517519]

1715517519

[1715517519]

1715517519

[1715517519]

1715517519

[DdmrDdmr]

<…>

Thanks there. Yes, the key to it all is to put some constant effort into it all. Most unmerited lower ranks simply do not make an effort, and therefore will remain hopelessly meritless. Where you post, with what content, style, section/subsection and so on are secondary to willing to spend some time thinking things through. Their loss …

The core of it all is the merit file which is officially released by the forum every Friday by the forum, and that contains data relative to all the sMerit TXs that have taken place over the last 120 days (https://bitcointalk.org/merit.txt.xz). Since the data within is limited to 120 days, I (and some other forum members) have my own cumulative database, keeping track of all sMerit TXs since day one.
The file is insufficient on its own to perform this analysis, so in addition, I scrape the site to download merited profiles and some information related to the merited messages. That all adds up to a bit of weekly time, but it allows me to have a decent enough base to perform this kind of analysis and update the Merit Dashboard  and  User Merit Network weekly.

[fillippone]

Bumping this very old thread from the depths.
Is it time for an update?
Or is it possible to add as a new tab on The Merit Dashboard?

[tranthidung]

Bumping this very old thread from the depths.
Is it time for an update?
Or is it possible to add as a new tab on The Merit Dashboard?

It is for your local board (Italian). See

[DdmrDdmr]

<...>

If your still interested I can take a look into it over the xmas holidays. I've located all the stuff I used at the time, so that's part of the path covered. It would be better if I do it on another thread, and I would like to see it broken down by rank too.

Note: I’m not sure (yet) about putting it on the Dashboard. Perhaps after the analysis, since an analysis should try to provide some comments with insights, which a bunch of numbers often lack if just presented.

[fillippone]

I am still interested.
It’s ok to post it on a new thread with some comment, instead of a tab in the merit dashboard.
I proposed this alternative as I thought it would have been easier for your!

[DdmrDdmr]

<...>

Good, me too! (I want to see the changes in distrubutions and so on). I've got, in theory, a couple of weeks of holidays now, so I should be able to squeeze some linear time to do it amidst a bunch of hefty social opulent food & turrones coated family reunions.

The Dashboard is ideal to update information easily, and is great for information that does not require too much explanation (Tableau does allow for collaborative commenting, but that’s on the paid version). It’s also really nice for slicing and dicing information. The Correlation Matrix is likely pretty static from week to week, and may be better as a one-shot task every now and then. The OP did include some lists though which may be interesting to consider placing on the Dashboard. I’ll give it a thought after creating the analysis. Thanks for the suggestion though.

[DdmrDdmr]

I’ve updated this OP, which was elaborated in August 2018,.recalculating all the data, and additionally included the merit matrix by rank. All with data is now as of 20/12/2019.

In order to allow comparison between then and now, I’ve archieved the old version of the OP here: http://archive.ph/R2owd

Note: I've finally gone with updating the OP, rather than creating a new one.

[philipma1957]

I’ve updated this OP, which was elaborated in August 2018,.recalculating all the data, and additionally included the merit matrix by rank. All with data is now as of 20/12/2019.

In order to allow comparison between then and now, I’ve archieved the old version of the OP here: http://archive.ph/R2owd

Note: I've finally gone with updating the OP, rather than creating a new one.

hmm i missed this back in august.

i wondered if my number rose to 13 from

whatever number it was when you did it in august.

I know I post like mad.

I know I have finally earned 1000 merits. first 1000 was air dropped.

I really did not think I would be in 13 subsections.

I thought I would be 9 or 10 tops. Nice read. Thanks.

[DdmrDdmr]

<...>

Back in August 2018, you were merited on 6 different subsections (I went through the Google Sheet I created back then:
https://docs.google.com/spreadsheets/d/1EzhU2vE5oRxPaVi8-2Cw7wb4CzoG5H1TY26uNcD8Cas/edit#gid=588590585).
Now, as you say, the spectre has more than doubled, reaching 13 subsections in total. Not bad right? …

If you want to check it out every now and then, one option is to see it here (updated weekly):
https://public.tableau.com/shared/GYDTZ3T36?:display_count=y&:origin=viz_share_link.
The bottom left of the screen displays the Received Subsections mentioned in the OP, but it allows us to see a bunch of other interesting stuff too (awarded merits to 16 different subsections – excluding Deleted – and so on).

[akhjob]

Things that standout:

a)   158 (27 last time) people have been merited on 10 or more subsections. That is a very difficult achievement, which implies a good knowledge in multiple areas as well as communication skills. This feat is in the hands of the following:

Code:

user_id   Name                          nSubSections
1235090   akhjob                       10

The list with the actual subsections where the above have been merited can be found here:
https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing (second tab).
Each person has his own mix of subsections that contribute to his total received sMerit with different weight. I’ve included the column PMerit (percentage of Merit) to show this.I've now extended this information (on the Google Sheet) to all merited profiles, not just those listed here.

I'm very much happy and surprised to see my name on the list. So, I checked my stats in your spreadsheet and saw that I got merited in the following subsections - Altcoin Discussion (9), Announcements (Altcoins) (2), Bitcoin Discussion (2), Bitcoin Development & Technical Discussion (3), Economics (36), Marketplace (27), Trading Discussion (1), Indian (26), Beginners & Help (5) & Meta (94)

As you can see, most of my merits came from Meta, Economics(WO), Marketplace and Local(India) Boards that's only 4 subsections. Earning 1 or 2 merit in each section is considered as a easy task for most in the list. So I would suggest that you exclude subsections were the earned merits are less than 10 so that we could get a list of users who are truly excelling in all subsections. PS: Just my thoughts  

[DdmrDdmr]

<…>

When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing

[fillippone]

<…>

When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing

Getting 10+ merits on as many boards as possible is definitely my new year’s resolution for 2020.

[Philipma1957cellphone]

<…>

When I created the OP, I thought it was not easy to be merited outside one’s, let’s call it, comfort zone (or subsection). As such, I went for a boolean approach, to list whether people that were merited on multiple boards, which was also the basis for the Merit Matrix later on.

Nevertheless, a 10 merit minimum per merited board is indeed interesting, and the numbers shrink in accordance to the difficulty of the task. For comparison reasons, I’ve therefore added a tab called “Number of Merited Subsections per User (+10 Merits)” on the OP Google Sheet link, which displays the list with the above criteria (count of subsections where the profile obtained at least 10 merits).

As you mentioned, your profile goes from being merited on 10 subsections to 4 (mine goes from 12 to 5, and the top case, @suchmoon goes from 20 to 14). Still pretty good for many of the listed cases …

https://docs.google.com/spreadsheets/d/1CFMvMD4lDMnnkxWl9p02k0ZoJW044eRY4EGEqkYd-8I/edit?usp=sharing

   well I was thinking it does help to speak multiple languages .if you are fluent in three languages getting merits In two local boards should be easy. Then of course english as your third language makes for a lot of subsections to post.

[DdmrDdmr]

Getting 10+ merits on as many boards as possible is definitely my new year’s resolution for 2020.

Star Trek just came to my mind here, exploring new frontiers …

<…>
well I was thinking it does help to speak multiple languages .if you are fluent in three languages getting merits In two local boards should be easy. Then of course english as your third language makes for a lot of subsections to post.

True, although in the OP I’ve treated all local boards as one, meaning that they are only accounted for once.

I recall looking at some point at which forum members had been merited on multiple local boards (not going into language that have a thread rather than a board). Looking at this specific element now, it turns out that:

Code:

user_id   Name                     Rank                nSections banned
1267993   Leteravian               Full Member         9         
459836    LoyceV                   Legendary           5         
507936    DarkStar_                Legendary           4         
1606609   Furgon Chino             Member              4         
1067333   micgoossens              Legendary           4         
1038373   narghat                  Jr. Member          4         
389306    bitrefill                Jr. Member          3         
1852120   fillippone               Hero Member         3         
1210969   JSRAW                    Hero Member         3         
1018610   luna2017                 Member              3         Banned
522205    mr.relax                 Hero Member         3         
263246    pazor_true               Legendary           3         
217199    sbogovac                 Legendary           3         
1311641   tvplus006                Hero Member         3         
1891055   vladimirhf               Member              3         
131333    wwzsocki                 Legendary           3         
2143453   1miau                    Hero Member         2         
877396    AdolfinWolf              Legendary           2         
2162672   aga0685                  Member              2         
1975036   AirdropsMob              Jr. Member          2         
86549     alexrossi                Legendary           2         
1107844   amishmanish              Sr. Member          2         
1215537   Arrrvin                  Member              2         
1580039   asche                    Hero Member         2         
2101964   aseemhamza               Jr. Member          2         
954325    BARADED                  Full Member         2         
1224889   Becassine                Full Member         2         
257004    big_daddy                Sr. Member          2         
2221461   Bitzlato                 Jr. Member          2         
1976275   blokklanc                Jr. Member          2         
353488    Boinkit                  Full Member         2         
1445331   bozicso                  Member              2         
964086    CharlieCox               Member              2         
1061308   chem96                   Full Member         2         
353680    chronicsky               Legendary           2         
482277    cloakteam                Sr. Member          2         
154563    Cloudbet                 Legendary           2         
1324004   coinliker                Member              2         
463354    coupable                 Sr. Member          2         
1760060   cryptobaro               Full Member         2         
2323298   cryptofarid10            Member              2         
27470     cygan                    Legendary           2         
85033     d5000                    Legendary           2         
1223580   DanielRR1997             Member              2         
509189    dannybrown               Hero Member         2         
901661    Darker45                 Hero Member         2         
1325560   Denlv                    Member              2         
2049993   DoriangrayTW             Member              2         
2615217   DragonDance              Member              2         
2373346   DTalk                    Member              2         
1168192   dushanya                 Member              2         
1759251   Dzeronimo                Full Member         2         
2312909   epidemia                 Full Member         2         
1888186   Eric01120                Member              2         
314792    examplens                Legendary           2         
1208052   frankbitcoin             Sr. Member          2         
75953     goddog                   Member              2         
1076069   guelmi92                 Full Member         2         
1053119   Halab                    Staff               2         
1827294   Husna QA                 Hero Member         2         
2204241   ICOEthics                Sr. Member          2         
885730    ihnattm                  Sr. Member          2         
1167826   JohnSilver               Sr. Member          2         
319562    JohnUser                 Hero Member         2         
2313339   Jrashid                  Member              2         
1856852   katanic97                Member              2         
1732244   Keeshan                  Member              2         Banned
1082600   kenzawak                 Hero Member         2         
1288254   Komodor                  Newbie              2         
1806798   kusanagi01               Jr. Member          2         
805820    Lafu                     Legendary           2         
7779      layer1gfx                Legendary           2         
1091302   libert19                 Full Member         2         
2344286   Little Mouse             Full Member         2         
176461    Lydian                   Hero Member         2         
2456348   mahmuterdem              Jr. Member          2         
23092     malevolent               Staff               2         
1867778   mamad.sky                Member              2         
787736    marlboroza               Legendary           2         
1067296   marv1n                   Full Member         2         
1162086   maxweel                  Member              2         
1973597   mbsyahia                 Member              2         Banned
962182    mela65                   Sr. Member          2         
98639     Melnik                   Legendary           2         
103262    mike0182                 Full Member         2         
1135313   moneva                   Member              2         
502133    nara1892                 Hero Member         2         
2445907   nicunicu                 Jr. Member          2         Banned
64400     nikkus                   Legendary           2         
221114    Noolz39                  Hero Member         2         
1115212   nuna                     Member              2         
1268845   Oygen                    Member              2         
18312     phantastisch             Legendary           2         
112493    Pmalek                   Legendary           2         
985133    rebel92                  Sr. Member          2         Banned
512663    Redones                  Sr. Member          2         
904446    RuslanFork               Sr. Member          2         
2647304   Ryutaro                  Member              2         
975910    Saint-loup               Hero Member         2         
1232646   salavat111               Member              2         Banned
1735080   SergiuDemerji            Member              2         
2426786   ShadowPresidentOfUkraine Jr. Member          2         
1215351   Slavyanskiy              Member              2         Banned
2151185   slocker                  Full Member         2         Banned
2067609   spatialiste              Member              2         
2033265   SuperTA                  Sr. Member          2         
679341    TheFuzzStone             Legendary           2         
35        theymos                  Administrator       2         
863921    timotron                 Sr. Member          2         
916376    Ukraine2020              Sr. Member          2         Banned
1321484   unihamburg               Member              2         Banned
64734     vitruvio                 Sr. Member          2         Banned
903830    vlad2323                 Sr. Member          2         
2088368   Vs225655                 Member              2         
125677    Waldschrat2              Full Member         2         
1925737   wwhity                   Member              2         
897509    xtraelv                  Hero Member         2         
1069571   yazher                   Sr. Member          2         
909172    yla1974                  Sr. Member          2         Banned
140827    yogg                     Legendary           2         
1194518   Yuliya2404               Member              2         Banned
1109190   zickle                   Full Member         2         
1920279   zimochka                 Member              2         Banned

Note: Not all post are necessarily written in the local language.

[DdmrDdmr]

<…> Or is it possible to add as a new tab on The Merit Dashboard?

Over a year and three months later, I managed to get this analysis onto the Merit Dashboard (not precisely RAD)…
 
I actually really just wanted to see one specific correlation figure, and rather than update the thread again (or simply keep it to myself), I added the data as a Tab on the Merit Dashboard (which should be updated every week alongside the other tabs):
https://public.tableau.com/views/BitcointalkMeritDashboard/CorrelationMatrix?:language=es&:display_count=y&publish=yes&:origin=viz_share_link

I added a couple of filters to the tab:
- Rank: Delimits the information per rank, allowing to see how the correlation number change per rank (similar to the last manual update I did on the Merit Dashboard).

- Total Merits: To exclude or delimit the data to users with a certain amount of Merits.

- Name: To search for a given profile, although the Correlation Matrix barely makes sense for a single profile, unless we focus on the number of merited subsections per user (excluding Deleted).

The Correlation Matrix is expressed now both in absolute terms (number of profiles) and relative terms (% of profiles in subsection x (rows) are also merited on subsection y (columns)).

The concepts are the same as those described in the OP.

[fillippone]

<…> Or is it possible to add as a new tab on The Merit Dashboard?

Over a year and three months later, I managed to get this analysis onto the Merit Dashboard (not precisely RAD)…

Well, I guess that months were very useful to me, as opening the tab I saw my name on the top.

I guess that much of this has been due to my focus on various local boards thanks to threads that were written following this:

Help me translate my best posts in your Local Board

I ventured in quite diverse local boards!

Ah, shame on me, I almost forgot I got merit on the alt-coins board. But that is my little known dirty secret.

[Lucius]

I have to admit that I somehow missed this topic at the time it was posted, but I can totally agree with everyone else that this is a very interesting analysis, and I’m sure quite a bit of effort has been put into it all. I was also surprised when I saw I got merits in as many as 13 subsections, but also that the number of members who got them in more than 10 is quite modest considering the number of active forum members.

Keep up the good work and more interesting analyzes👨‍💻