Topic: Super Merit Table - Where did you spend/received all of your merits (Read 620 times)

bump
table was just updated.

Filipino translation - https://bitcointalksearch.org/topic/super-merit-table-kung-saan-inilaan-ang-mga-binigay-at-nakuhang-merito-5268984

Cool, I'm happy enough to have it at the disposal as it is  I don't know how to do that stuff either so I can't help, but hopefully someone will come along with knowledge, time, will and help you out.

Thanks for doing the manual update.

The table is manually updated, and I am updating it twice a month for now. I ask DdmrDdmr for the file with his scraped data.


I am not able to do it.

I tried to use bootstrap + datatable.net to create the table, so I would have more customization options. However, I do not know how to efficiently parse the data, and my HTML file had 30mb and consumed a lot of processing power.

Flourish is very efficient in parsing the data, so I will keep the table in this format and move on to other projects. At least for now. Maybe in the future as I learn more about JS and SQL...


It now shows 130 merits for you and 47 sent

I would just like to add that it is not updating correctly or at all.Other option could be that it does not include certain boards too. It says I received 67 merit for a while now and I am at 128 already as you can see.

Not a rant btw., just pointing it out so you can add stuff if you plan to improve it.

Added Croatian translation: 

https://bitcointalk.org/index.php?topic=5268699.new#new

Wow another statistics has been presented. I had so much love you guys for making so many statistics in this forum. It somehow could be use in the future for references. As we can see the statistics do not lie and we can interpret whether were the point we need to improve or the part that are already working and done better. Even in research as I have remember during college days, the statistics plays important role in the study. I just needed how to learn this as it is one of my hated part where I really do not like the Math subject.

Anyway, I wanted also to test this out to see where did i spend/receive my merits in this forum. Thanks for this idea surely I can manage now to see the details of the merits being spent and received.

UPDATE:

I moved the merit table to my personal domain. The new link is now:
https://bitcoindata.science/supertable.html

I will soon remove flourish and generate a new table using only Javascript/Bootstrap. I hope I will have time to do it next week. Still struggling with JS to read CSV files....

I will translate it to Croatian too in next few days as that covers almost all users from Balkans as they visit our board regularly. This tool is so useful it's a shame if people don't know about it.

Turkish translate: https://bitcointalksearch.org/topic/m.54980271

Thank you all for the suggestions.

Most of those customizations will only be able if I host my table in my domain, moving away from flourish.

I am studying about using namecheao to create a website for this kind of data. I am studying a lot of python so i think i will do a lot of work

I already figured out a searchable table using bootstrap, that will work much better than this one.

@bitmover this is amazing work and I bookmarked it in my browser.
With few improvements that previous members proposed it can be even better.

My suggestion would be to allow members to filter and hide some fields and to resize the table if possible.

Thank you.

Trading discussing is basically Reputation board.

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.

Definitely a good idea.

Edit:
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.

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

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).

You are genius. Done!

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.

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!  

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.

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