Super Merit Table - Where did you spend/received all of your merits

[bitmover]

I used DdmrDdmr data once again and created this cool table.

Here you can see where any user spent or received all of his merits, by boards.

Just use the search box to find your username. Then scroll around all of boards and see how many merits you have sent/received in each board.




https://bitcoindata.science/supertable.html

I find that table pretty useful. It might take a while to load, just be patient (all merit database will be loaded)


Translations:

• Portuguese - Super Tabela de Méritos by bitmover
• Polish - Super Merit Table - Gdzie otrzymano i rozdzielono Merits by cygan
• Deutsch - Super Merit Table - Wo erhaltene und verteilete Merits gemacht wurden by Lafu
• Russian - Cyпep Taблицa Mepитa by Ratimov
• Turkish -    Merit Tablonuz / Merit Kazandığınız ve Harcadığınız Bölümler by TomBombadil
• Croatian - Super Merit Table - Gdje ste potrosili/dobili sav svoj merit by bitmover by -CryptoViking-
  
  • Filipino - Super Merit Table - Kung saan inilaan ang mga binigay at nakuhang merito by Peanutswar

[cabalism13]

fancy 🥰
A table Version of LoyceV's Stats 😁
https://bitcointalk.org/index.php?topic=5108209.0

Edit:

I tried using it, though I only have one suggestion:
Only View where it has been Sent/Received, automatically hide Boards with 0 value.

[Lafu]

Nice Job and work buddy , awesome and realy great to watch and for sure simple to use !
Will get it to the German Board translated if you dont mind .
Guess there are a few that will love to use it and stick around with it .

[Yogee]

Please add column for total sent and received.

[bitmover]

Only View where it has been Sent/Received, automatically hide Boards with 0 value.

That would be amazing and I tried, but this flourish website doesn't allow.

I would have to host something myself to do so... maybe in the future

Please add column for total sent and received.

This I can do. I will do in a few minutes

Edit: Done!

[SFR10]

Excellent tool/table for viewing our Merit data but I would like to suggest separating each sub-board from its parent board ^{[have each one of them in a different column]}.
^{- Or a drop-down of some sort [if it's possible].}

[LoyceV]

A table Version of LoyceV's Stats 😁

Very nice indeed! Mine was just a very quick job, where I just sorted the board URLs from the forum and posted that. This looks much better, please keep it updated!
There is one flaw though: all child boards are included under the main sub board. "Trading Discussion" for instance doesn't really cover it when most of the Merit transactions on that board happened in "Reputation".

Only View where it has been Sent/Received, automatically hide Boards with 0 value.

Just Merit someone on all boards
I'm only missing Chinese, Greek, Hebrew, Japanese, Korean and Skandinavisk.

[cryptoaddictchie]

Tried it.


Very helpful and excellent merit data summary. I remember requesting to LoyceV few days ago on this thread https://bitcointalk.org/index.php?topic=5108209.0 and now this come out. (Maybe your client on that thread will decrease LoyceV  )

Only View where it has been Sent/Received, automatically hide Boards with 0 value.

That would be amazing and I tried, but this flourish website doesn't allow.

I would have to host something myself to do so... maybe in the future

Were looking forward to this mate where none merited board should not be displayed. Too sad that website doesnt allow to remove it. I could possibly screenshot all if werent for those 0 vacant sent/received. Anyway this is really a great tool. 10/10!

[bitmover]

A table Version of LoyceV's Stats 😁

Very nice indeed! Mine was just a very quick job, where I just sorted the board URLs from the forum and posted that. This looks much better, please keep it updated!

Thanks, I will try to keep it updated.

There is one flaw though: all child boards are included under the main sub board. "Trading Discussion" for instance doesn't really cover it when most of the Merit transactions on that board happened in "Reputation".

That's a limitation of DdmrDdmr data. I can't do much, as I don't know how he was able to link each topic ID to its current section/subsection. Maybe he scraped? Painful job lol
I will stick to this limitation. I was able to generate WO observer data, as just finding one topic is pretty easy.

[McniColl]

Really everyone would love to see the Super Merit table, a very neatly arranged table.  Thank you so much for showing such a table. You can update this table to make it look easier and more beautiful.

I want to ask you a question. If you search by typing my name on the Superman Merit table nothing shows.  If you did that, it would be better if the names of those who did not get merit or donate could be seen on the table.

Not show my name: https://imgur.com/4nB5Thv

Thank you @bitmover

[bitmover]

Really everyone would love to see the Super Merit table, a very neatly arranged table.  Thank you so much for showing such a table. You can update this table to make it look easier and more beautiful.

I want to ask you a question. If you search by typing my name on the Superman Merit table nothing shows.  If you did that, it would be better if the names of those who did not get merit or donate could be seen on the table.

Not show my name: https://imgur.com/4nB5Thv

Thank you @bitmover

Hello Mcnicoll.

I excluded members who never earned any merit from the database, as all their data is zero anyway...

[tranthidung]

It looks like now you are more proficient to do such things. Congratulations for your achievement, bitmover!

By the way, if it is possible (on that platform and at your current skills), please add a column for percentages statistics. You can add a new column or simply integrate percentages in () blocks after the frequency statistics.

It is easier to imagine distributions based on percentages rather than frequencies.

I can do percentage statistics, but I am not sure if I understood your suggestion correctly.

Something like this?

That's it!

[bitmover]

It looks like now you are more proficient to do such things. Congratulations for your achievement, bitmover!

By the way, if it is possible (on that platform and at your current skills), please add a column for percentages statistics. You can add a new column or simply integrate percentages in () blocks after the frequency statistics.

It is easier to imagine distributions based on percentages rather than frequencies.

Thank you for your suggestion.

I can do percentage statistics, but I am not sure if I understood your suggestion correctly.

Something like this?

I just invented that % for our discussion, didn't calculate it.



Edit: The problem is that I already have 43 columns. This idea would double it... certainly it is interesting, but it might decrease user experience.
I think I will not be able to use the same column. I will try to figure out something

[-CryptoViking-]

Thank you for this tool, it is lightning fast and to be honest quite useful. I'm gonna go happily check my stats now and see where I'm frequenting the most, to be honest I probably haven't explored 30% of the forum yet.

[tranthidung]

Edit: The problem is that I already have 43 columns. This idea would double it... certainly it is interesting, but it might decrease user experience.
I think I will not be able to use the same column. I will try to figure out something

Why not consider to move the username on the first row.

Then, the second and third rows will be:

• Received (frequency)
• Received (%)

The fourth and fifth rows will be:

• Sent (frequency)
• Sent (%)

Cheers!  

[McniColl]

Really everyone would love to see the Super Merit table, a very neatly arranged table.  Thank you so much for showing such a table. You can update this table to make it look easier and more beautiful.

I want to ask you a question. If you search by typing my name on the Superman Merit table nothing shows.  If you did that, it would be better if the names of those who did not get merit or donate could be seen on the table.

Not show my name: https://imgur.com/4nB5Thv

Thank you @bitmover

Hello Mcnicoll.

I excluded members who never earned any merit from the database, as all their data is zero anyway...

I really like your invention.  I want more simple and beautiful inventions you will give us more gifts.

I wish you a long life.  And thank you so much for explaining it to me in such a beautiful way.

[bitmover]

Edit: The problem is that I already have 43 columns. This idea would double it... certainly it is interesting, but it might decrease user experience.
I think I will not be able to use the same column. I will try to figure out something

Why not consider to move the username on the first row.

Then, the second and third rows will be:

• Received (frequency)
• Received (%)

The fourth and fifth rows will be:

• Sent (frequency)
• Sent (%)

Cheers!  

You are genius. Done!

[DdmrDdmr]

<…> That's a limitation of DdmrDdmr data. I can't do much, as I don't know how he was able to link each topic ID to its current section/subsection. Maybe he scraped? <…>

I can add more path depth levels to the data I provided. What I do is obtain for each post the complete path that figures at the top of the page (i.e. "Bitcoin Forum > Other > Meta > Super Merit Table - Where did you spend/received all of your merits"), and then parse each item as a different level ("Bitcoin Forum" is Level 1, "Other" is level 2 and so on). 6 Levels covers everything, so it would be a question of adding levels 4, 5 and 6 (which could be blank). For example, there are 10543 TXs with level_4 = "Reputation (Moderator: Cyrus)".

Notes:
1) I cleanse levels 1,2 and 3, but not all the remaining other levels.

By that I mean that historical data may contain a reference to a certain moderator, that is not the current moderator, and I may not want the moderator to show at all. When cleansing, I delete the moderator information, and make sure I have homogeneous values.

In the above example, Reputation contains "Reputation (Moderator: Cyrus)" as it’s unique value on level 4, so filtering by this value should retrieve all Reputation TXs, but other childboards of interest may have more than one entry (i.e. moderator changes at some point, so historical data has one description, and recent records another).

2) If you want to give it a go, I can add the remaining levels 4,5 and 6 to the file. It will make it much larger though, and a bit more complex to manage due to the above.

3) I actually tried to give you the data along with this post, but cannot complete the procedure right now (I’d have to give it a go later on, when I get hands on my proper environment).


Edit:
- level 4 is rather more cleansed than I thought for local boards, since I use it on the Merit Dashboard.
- Files with the added fields:
    https://drive.google.com/file/d/1cdne4UO8vs25eoPHGjIAUxIefU_pPJOc/view?usp=sharing (rar - 15 Mb).
    https://drive.google.com/file/d/1txraHpX-ctAEr7Tb-GGx2I0aBAsEeF4D/view?usp=sharing (nor rar - 259 Mb).

[cygan]

bitmover, you created a very useful tool which is also very successful - respect!
i translated it into polish and published it there

[The Sceptical Chymist]

Very cool little table you created there, OP.  I'm not really all that interested in merit statistics (mine or anyone else's), but it was interesting to look at which sections I'd gotten most of mine in and where I've given them out the most.  Meta topped the list for both, just as I would have guessed but I was surprised to see Trading Discussion was a section where I'd earned and given out a lot of merits--I guess I don't frequent that section much anymore, or it could be that some threads got moved there.

Excellent tool/table for viewing our Merit data but I would like to suggest separating each sub-board from its parent board ^{[have each one of them in a different column]}.
^{- Or a drop-down of some sort [if it's possible].}

Definitely a good idea.

Edit:

Trading discussing is basically Reputation board.

Lol, I just realized that when I went there a minute ago and saw that Reputation and Scam Accusations are child boards of Trading Discussion.  I forgot about that.