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

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: DdmrDdmr on July 26, 2020, 10:13:15 AM

Just in case you prefer using a more recent dataset, I’ve uploaded the file with all TXs as of last Friday. I’ve not overwritten my prior file just in case you prefer to use that dataset.

The newly uploaded files are located here:

CSV version (77Mb):
https://drive.google.com/file/d/1kOuW7gO-Om2X8zvwJhSrEet5eNjlvSRu/view?usp=sharing

Rar version (9Mb):
https://drive.google.com/file/d/1UY7YON7y-DzUGYIWh1V3jOt-P7l7kmS8/view?usp=sharing

Hello DdmrDdmr.

Can you share with me your last updated data from merit dashboard again?
I am using it in my merit table (https://www.bitcoindata.science/supertable.html) and in some other projects as well.

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Just added Super Merit table and Turkish merit race.

To do:

-More local boards animations per request. Portuguese is the obvious next one Wink

-More tables and different graphic visualizations with the new DdmrDdmr data. As now I can get data per board/topic I have wider possibilities

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Made some updates:

- Added DdmrDdmr data. Now i can make animations and graphics per board. I am open to requests
- Made Wall Observer board animation
- Added Avatars to all animations.

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

How can I do this for the local Turkish section?

Hello Tom Bombadil. Yes, I can do that animation now. I will do as soon as I can.
TUrkish and any other request board (I can do any local)

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

Just in case you prefer using a more recent dataset, I’ve uploaded the file with all TXs as of last Friday. I’ve not overwritten my prior file just in case you prefer to use that dataset.

The newly uploaded files are located here:

CSV version (77Mb):
https://drive.google.com/file/d/1kOuW7gO-Om2X8zvwJhSrEet5eNjlvSRu/view?usp=sharing

Rar version (9Mb):
https://drive.google.com/file/d/1UY7YON7y-DzUGYIWh1V3jOt-P7l7kmS8/view?usp=sharing

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: DdmrDdmr on June 20, 2020, 10:01:26 AM

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

<…> 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 Roll Eyes

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.

bitmover

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

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

legendary

Activity: 2352

Merit: 6089

bitcoindata.science

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

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.

DdmrDdmr

legendary

Activity: 2338

Merit: 10802

There are lies, damned lies and statistics. MTwain

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

<…> 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 Roll Eyes

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

boissonnea

newbie

Activity: 20

Merit: 5

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?

Tom Bombadil

sr. member

Activity: 364

Merit: 304

Quote from: LoyceV on June 20, 2020, 03:41:20 AM

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Tom Bombadil on June 20, 2020, 03:06:54 AM

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

sr. member

Activity: 364

Merit: 304

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 Roll Eyes

TryNinja

legendary

Activity: 2758

Merit: 6830

Quote from: Vod on June 19, 2020, 04:45:34 PM

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.

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: notblox1 on June 19, 2020, 09:15:35 AM

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

notblox1

legendary

Activity: 2086

Merit: 1282

Logo Designer ⛨ BSFL Division1

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

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: LoyceV on June 19, 2020, 05:24:30 AM

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.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Vod on June 19, 2020, 04:46:51 AM

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.

Upgrade00

legendary

Activity: 2254

Merit: 2406

Playgram - The Telegram Casino

Quote from: Vod on June 19, 2020, 04:46:51 AM

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.

Vod

legendary

Activity: 3668

Merit: 3010

Licking my boob since 1970

Quote from: LoyceV on June 19, 2020, 04:31:04 AM

Quote from: snipie on June 18, 2020, 04:13:52 PM

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 Tongue

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: snipie on June 18, 2020, 04:13:52 PM

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 Tongue

Topic: [UPDATED] bitcoin/bitcointalk.org Stats Animation - all in one thread - page 2. (Read 1376 times)