[UPDATED] bitcoin/bitcointalk.org Stats Animation - all in one thread

[bitmover]

[WARNING] Some Data is not up to date.

This post is a compilation to my other Race animations regarding bitcointalk and bitcoin stats.
I will keep this thread updated as my work progresses.

|

ANN thread link

|

Animation link

|

|

Earned and Sent Merit Race Animation

|

Link

|

|

DT network visualization chart

|

Link

|

|

DT1 Strength/Weakness Race!

|

Link

|

|

Wall Observer Merit Stats

|

Link

|

|

Wall Observer Merit Network

|

Link

|

|

Turkish Board Merit Stats

|

Link

|

|

German Board Merit Stats

|

Link

|

|

Russian Board Merit Stats

|

Link

|

|

Portuguese Board Merit Stats

|

Link

|

|

Italian Board Merit Stats

|

Link

|

|

Spanish Board Merit Stats

|

Link

|

|

Miners Centralization Race

|

Link

|

|

Exchanges Volume Race

|

Link

|

|

|

|

Other Projects

|

|

Super Merit Table

|

Link

|

How are those animations done?

Some people asked me about those animations. I use @LoyceV's data and this nice website called Flourish Studio to make the animation.
99% of the work is to organize the data. I do that with Python, especially Pandas library.


Suggestion and animations request
I am open to suggestions and animations per request. For a group of users, for example. As I said, 99% of the work was to organize the data, and now it is organized.

I plan to make more animations about bitcoin and blockchain data, I am just having more trouble organizing that data. But I plan to release one soon.


Last updates:
Added WO and Exchange Volume animations.
Added avatar to some animations.

[OcTradism]

I think you can post one photo for all types of race to make your topic visually. For the other races, you can list them in a table.

The link to DT1 strength race in OP is not correct. It is 2881001, not 2870679.

|

ANN thread link

|

Animation link

|

|

Earned Merit Race Animation - See if you ever got to top20 merited.

|

Link

|

|

Merit Senders Race animation

|

Link

|

|

DT1 strength race!

|

Link

|

[Nellayar]

Nice innovation OP.
I saw those three animation race from sender of merits, received merit and DT1 strength. And those are cool. Do you have plan to add some more stats? I suggest to make also some race stats about trust (positive/negative), posts which are the most numerous posts and activity of the forum and most numerous thread makers.

I am currently studying about python programming and it's really hard to learn about codes specially if there is no resources.

[snipie]

I think it is better to see (also) the race in merit per member. I mean there might be memberX spending 1-2 merits each time to 1000 members that is behind memberY who spent 5-10 merits to 100 members for example. I find the first guys more interesting to see
BTW nice OP

[LoyceV]

I think it is better to see (also) the race in merit per member. I mean there might be memberX spending 1-2 merits each time to 1000 members that is behind memberY who spent 5-10 merits to 100 members for example.

I like the idea, an animation for the number times a user received a Merit transaction would make me #1

[Vod]

I think it is better to see (also) the race in merit per member. I mean there might be memberX spending 1-2 merits each time to 1000 members that is behind memberY who spent 5-10 merits to 100 members for example.

I like the idea, an animation for the number times a user received a Merit transaction would make me #1

I like the idea as well.  Any graph that involves merit sources should have those lines "glow" so we can separate them from the non-sources easily.   Once I stopped being a source, the quality of my posts seemed to drop ten fold.  :/

[Upgrade00]

Any graph that involves merit sources should have those lines "glow" so we can separate them from the non-sources easily.

This would not be possible as not all sources have publicly admitted that they are.
Another idea would be a graph of merit against activity, to show how quickly one earned merits based on their activity score it could also be used to check how long one stayed at a particular rank. I would imagine satoshi would have a straight line (merit growth)
I don't know if this could be made into a group data or per-user.

[LoyceV]

Once I stopped being a source, the quality of my posts seemed to drop ten fold.  :/

Are you saying there's some "backscratching" going on? Returning the favor when someone gets Merited, thus leading to more "backscratching" for Merit sources, because they Merit more users? I think it happens a bit, I've seen Merit transactions shortly after sending Merit. But it could also be first Merit transaction brought the Merit sender to the receiver's attention, and if he reads more of his posts, the posts might deserve it.

[Vod]

Are you saying there's some "backscratching" going on? Returning the favor when someone gets Merited, thus leading to more "backscratching" for Merit sources, because they Merit more users?

I don't think it's intentional abuse.  If someone receives merit they were not expecting, it may be easier for them to find your post merit worthy.  It's human nature to like and help those that helped you.  In my experience, if you recognize talent with a merit, they will support you, even subconsciously, and it makes them feel good (dopamine hit) to return the favor. 

[notblox1]

Interesting stats animations.
I would like to see animated comparison of bitcointalk topics with most activity and their progress in time.
Not sure it is possible or easy to do this.

[Vod]

I would like to see animated comparison of bitcointalk topics with most activity and their progress in time.

Not sure how you would calculate activity on a topic or post.  :/

[TryNinja]

Not sure how you would calculate activity on a topic or post.  :/

Maybe he meant activity as the number of posts in a thread rather than the actual "activity points". It would be interesting to see the Wall Observer thread making his way to the top 1. But someone would need to scrape those posts and make a list available with the time of each post.

[Tom Bombadil]

How can I do this for the local Turkish section?

There is data in the @DdmrDdmr application. But I can't copy the data from there. I wish it was possible to copy the tables @DdmrDdmr 

[LoyceV]

How can I do this for the local Turkish section?

Get all topicIDs on the Turkish board, then get all Merit transactions for those topics.
It means scraping about 1000 pages, so you should wait at least 1 second between requests.

[Tom Bombadil]

How can I do this for the local Turkish section?

Get all topicIDs on the Turkish board, then get all Merit transactions for those topics.
It means scraping about 1000 pages, so you should wait at least 1 second between requests.

Wow! It looks crazy. It seems to last for days. Thousands of topics have been opened since 2018.
Thank you anyway, @LoyceV

[boissonnea]

Are the lists above based on participation times or data?some accounts are inactive so its hard to count them

Do you need to update it periodically, or does it update automatically?
There are lists of people who have become legendary since the merit system was established. Can you prepare an illustration that explains the competition between them and how quickly they reach these ranks?

[DdmrDdmr]

<…> There is data in the @DdmrDdmr application. But I can't copy the data from there. I wish it was possible to copy the tables @DdmrDdmr 

You can use the following file: https://drive.google.com/file/d/1rOvFPbd9T6q5qrtLtAD1gy4fBMcUrg3Z/view?usp=sharing
It contains all the historical TXs, including the board description (section/subsection) It occupies some 75 MBs. You’ll have to load them to a DB or whatever repository you are going to use, and filter by subsection = Turkish (last column).

The data is as of last Friday 19/06/2020. How you create a the race itself is up to you (python, Tableau, etc.).

[bitmover]

How can I do this for the local Turkish section?

I can create a race for selected users in Turkish section. just give me a list of all the users you want, and I can make their race. However, merits earned outside the Turkish board would still be counted. But you can select user who post most of their time in the Turkish board.

[bitmover]

Small updated:

I added Exchanges Volume Race. You can see the direct link to the animation here[/td][td]|[/td][/tr][/table].

This is a very poor data and hard to find. But, anyway, I made the animation. I was able to get data since 2010. Sadly, missing binance and  a few others.

[bitmover]

<…> There is data in the @DdmrDdmr application. But I can't copy the data from there. I wish it was possible to copy the tables @DdmrDdmr 

You can use the following file: https://drive.google.com/file/d/1rOvFPbd9T6q5qrtLtAD1gy4fBMcUrg3Z/view?usp=sharing
It contains all the historical TXs, including the board description (section/subsection) It occupies some 75 MBs. You’ll have to load them to a DB or whatever repository you are going to use, and filter by subsection = Turkish (last column).

The data is as of last Friday 19/06/2020. How you create a the race itself is up to you (python, Tableau, etc.).

It took me a while, but I downloaded it today. Very good and organized data... I will do something with it in a few days . I will start with wall observer and then I will make other graphics for local boards.
Thank you.