Bitcoin Forum
October 22, 2019, 03:06:42 AM *
News: Latest Bitcoin Core release: 0.18.1 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: [Stats] Local Boards Activity  (Read 255 times)
DTalk
Member
**
Offline Offline

Activity: 108
Merit: 39

www.bitcoinbangladesh.info


View Profile WWW
September 03, 2019, 12:34:06 PM
Merited by LoyceV (2), Daniel91 (1), hugeblack (1), Heisenberg_Hunter (1), DdmrDdmr (1), tranthidung (1), dkbit98 (1), 1miau (1), Coyster (1)
 #1

This is not a deep analysis, I just have made this out of my interest on which local board is much active in bitcointalk and how much posts are being there on average.

Breaking Down the Color-
Yellow= No changes/ 0 average
Red= Negative/ Post deleted
Black= Positive

                 28.08.19     29.08.19     31.08.19     Daily Average
Arabic32314323383236613
Indonesian104179110414871104200052.25
Spanish19905019908519914323.25
Chinese666338665967665400-234.5
Croatian3850438517385398.75
German47646647652147665848
Greek3893538941389421.75
Hebrew2468246824680
France22330322335322345939
India7287872888728780
Italian26309426310526317119.25
Japanese3991539916399180.75
Dutch4723647240472472.75
Korean1580015802158071.75
Pilipinas25488525489325495818.25
Polski2870828711287326
Portuguese13061613065513074231.15
Russia456300445630994563657163.25
Romania440524404144044-2
Skandinavisk8217821982211
Turkish87274887278287308885
Other4332343327433404.25

Top 3 Local Boards
1. Russia- with a daily average of 163.25 posts.
2. Turkish- with a daily average of 85 posts.
3. Indonesia- with a daily average of 52.25 posts.



Daily Average Post



Miscellaneous
1. Presented data from 3 dates, didn't get archived page for 30.08.19
2. First column must be represent language name but in some case, I have used country name.
3. This thread will be more developed in the near future to get a picture of the bitcointalk local board which may help in the process of introducing new local boards.

1571713602
Hero Member
*
Offline Offline

Posts: 1571713602

View Profile Personal Message (Offline)

Ignore
1571713602
Reply with quote  #2

1571713602
Report to moderator
1571713602
Hero Member
*
Offline Offline

Posts: 1571713602

View Profile Personal Message (Offline)

Ignore
1571713602
Reply with quote  #2

1571713602
Report to moderator
1571713602
Hero Member
*
Offline Offline

Posts: 1571713602

View Profile Personal Message (Offline)

Ignore
1571713602
Reply with quote  #2

1571713602
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1571713602
Hero Member
*
Offline Offline

Posts: 1571713602

View Profile Personal Message (Offline)

Ignore
1571713602
Reply with quote  #2

1571713602
Report to moderator
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 644
Merit: 2775

There are lies, damned lies and statistics. MTwain


View Profile WWW
September 03, 2019, 01:27:33 PM
Last edit: September 03, 2019, 02:02:24 PM by DdmrDdmr
Merited by hugeblack (1), DTalk (1)
 #2

A three day window is a wee bit small to draw conclusions really. A broader timerange may seem more fitting. One thing that I’ve pondered lately is the weight of the local altcoin board on each of the Local Boards. More often than not, it is still a heavyweight subsection on each Local Board, and responsible for a large part of the created posts in a given Local Board.

I keep track of the number of net (*) posts created per month on Local Boards, with monthly data for each, broken down by first level of childboards within. For example, the Local Spanish board (see https://public.tableau.com/shared/3X239NMSF?:display_count=yes&:origin=viz_share_link) still has around 44% of posts made in the Altcoin board. Considering a five month period (data that goes back to the end of 2017, but for simplicity, I've filtered the above link to 5 month's worth of data).

(*) Net posts = created – deleted – moved.

Negative values, such as the -234,5 in your data come from posts/threads that are deleted. Every now and then, mods seem to perform a large purge on posts/threads, and the number of posts for a given month decreases instead of increases, sometimes in pretty steep values.

<…> Skandinavisk- Which country does it refer to? Sweden, Norway, and Denmark?
All three I believe.

DTalk
Member
**
Offline Offline

Activity: 108
Merit: 39

www.bitcoinbangladesh.info


View Profile WWW
September 03, 2019, 01:44:56 PM
 #3

I would do a broader range but I have thought to do something else. I will take another 3 days data for 3 more times in the coming weeks, different days from this time. With this combination, I will update this thread to get a conclusion. However, I believe the result will not be much distanced other than Chinese and Romania. Chinese got a significant amounts of post deleted within 28th August to 31st.
The same happened with the Indian board as well. They got 10 posts deleted within these days. Other than these local, the result will be same I believe.

Skandinavisk- Which country does it refer to? Sweden, Norway, and Denmark?

hugeblack
Hero Member
*****
Offline Offline

Activity: 840
Merit: 776


Happy 18,000,000 bitcoins!


View Profile
September 03, 2019, 02:29:46 PM
 #4

Good work, but a narrow range analysis gives wrong results, especially within 3 days.
Also, there are some factors that need to be considered such as Merit analysis, Mod activity, number of active users will determine the data more accurately.
Also, some data, such as ANN & bounty section of Altcoin boards, should be excluded from the ratios.

sncc
Hero Member
*****
Offline Offline

Activity: 537
Merit: 510


View Profile
September 03, 2019, 02:34:17 PM
 #5

Interesting, though the duration is short.  I was wondering what is happening in the Chinese board.  Is the deletion of more than 200 posts happening on a daily basis or only special for this particular range of dates?
LoyceMobile
Full Member
***
Offline Offline

Activity: 491
Merit: 104


theymos: "scammers are often pretty stupid"


View Profile WWW
September 03, 2019, 02:43:38 PM
 #6

Your daily average is wrong: it's 3 days, but you divided the number of posts by 4.

LoyceV on the road (or in bed, couch, ....). Don't deal with this account (there's one exception), I use it on untrusted devices.
<<Lightning Network: Tip me 1 satoshi>>. <<Exchange Bitcoin LN for onchain coins>> <<"When AI roams free, that's LoyceV...on mobile" (by Steamtyme)>>  <<your text here for free? come up with something good>>
Look at me, I'm DT3!
[/size]
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 644
Merit: 2775

There are lies, damned lies and statistics. MTwain


View Profile WWW
September 03, 2019, 02:45:40 PM
Last edit: September 03, 2019, 03:00:23 PM by DdmrDdmr
 #7

Interesting, though the duration is short.  I was wondering what is happening in the Chinese board.  Is the deletion of more than 200 posts happening on a daily basis or only special for this particular range of dates?
There is a pretty big clean-up taking place over on the Chinese Local Board, that has been going for some months (see https://public.tableau.com/shared/63RSPTF3S?:display_count=yes&:origin=viz_share_link). Most Net post count is negative recently, with a large focus on Altcoins and the Main board (this latter could be moving threads to their proper childboards).

<...>
It depends on exactly at what time he got each reading: If all readings are taken at the same time each day, it would be 3. If first reading is early on the 28/08/2019 and last reading late on the 31/08/2019 then it is close to 4. Maybe OP can clarify.

Coyster
Full Member
***
Offline Offline

Activity: 350
Merit: 128


Match365>be a part of 150btc inviting bonus


View Profile
September 03, 2019, 02:46:07 PM
 #8

Skandinavisk- Which country does it refer to? Sweden, Norway, and Denmark?
Skandinavisk(scandinavia)is an area in Northern Europe, and this area covers the lands of Denmark, Sweden and Norway and it could also include Finland and Iceland in a broader/wider region(Nordic countries).

Skandinavisk(scandinavia)can also be referred to as the Scandinavian peninsula
You can read more about it here: https://en.m.wikipedia.org/wiki/Scandinavia

DTalk
Member
**
Offline Offline

Activity: 108
Merit: 39

www.bitcoinbangladesh.info


View Profile WWW
September 03, 2019, 04:54:13 PM
 #9

Good work, but a narrow range analysis gives wrong results, especially within 3 days.
Also, there are some factors that need to be considered such as Merit analysis, Mod activity, number of active users will determine the data more accurately.
Also, some data, such as ANN & bounty section of Altcoin boards, should be excluded from the ratios.
It would not be possible since I'm not a pro scraper. I have little knowledge on data sraping but not enough to scrape what you are asking.

Your daily average is wrong: it's 3 days, but you divided the number of posts by 4.
Have taken 31st August instead of 30th because I didn't get any archived data for 30th.
Sample has been taken from 3 individual dates but data range is 4 days, broken down by Ddmrddmr already.

1miau
Hero Member
*****
Offline Offline

Activity: 518
Merit: 1414


ChipMixer Miau


View Profile WWW
September 04, 2019, 12:27:40 AM
 #10

I'm a little bit surprised about the small number of posts in local boards. I'm active on the German local board and I've the impression that there are much more posts per day.


I would do a broader range but I have thought to do something else. I will take another 3 days data for 3 more times in the coming weeks, different days from this time. With this combination, I will update this thread to get a conclusion.
Looking forward to it. Would it also be possible to make up to 7 days (one week) to get an impression of the difference between Monday-Friday and Saturday + Sunday and add the number of post per day? Like that:

                28.08.19     28.08.19     29.08.19     29.08.19     31.08.19     31.08.19     Daily Average
Arabic32314xx (posts per day)32338xx32366xx13
Indonesian1041791xx10414871xx1042000xx52.25

I know it's very time consuming but the community would appreciate it for sure.  Wink
And I will share it on the German board.  Smiley

tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 744



View Profile
September 04, 2019, 03:56:53 AM
 #11

< ... >
Excellent! Do you have plans to keep your threads update on daily basis?
If yes, I will support by making further analysis with your data you dump daily, will start doing this after your datapoints surpass 20 (20 days).
If you can add a statistics on daily merit circulated in boards, per day, it will be much interesting.
I want to have another topic for my collection, if I can get regularly updated data from your thread.
tranthidung's statistical threads on bitcointalk
 Wink


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
SuperTA
Full Member
***
Offline Offline

Activity: 196
Merit: 228



View Profile
September 07, 2019, 01:55:00 AM
Last edit: September 07, 2019, 02:08:54 AM by SuperTA
 #12

I'm a little bit surprised about the small number of posts in local boards. I'm active on the German local board and I've the impression that there are much more posts per day.


I would do a broader range but I have thought to do something else. I will take another 3 days data for 3 more times in the coming weeks, different days from this time. With this combination, I will update this thread to get a conclusion.
Looking forward to it. Would it also be possible to make up to 7 days (one week) to get an impression of the difference between Monday-Friday and Saturday + Sunday and add the number of post per day? Like that:

                28.08.19     28.08.19     29.08.19     29.08.19     31.08.19     31.08.19     Daily Average
Arabic32314xx (posts per day)32338xx32366xx13
Indonesian1041791xx10414871xx1042000xx52.25

I know it's very time consuming but the community would appreciate it for sure.  Wink
And I will share it on the German board.  Smiley

You are right. The German Local Board has more than 2400 posts in August. That's almost 80 posts per day!
This 3 day statistic can't be accurate. Only 48 posts instead of 80 per day. That's almost double.

I also found some other things which are not so accurate.
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 744



View Profile
September 07, 2019, 02:42:25 AM
 #13

Local boards' merits (daily)
Quote
ABSTRACT
Observed period: 01/07/2019 - 29/08/2019
(1) Median of daily merits over all sub-sections is 2, and interquartile range (IQR) is 0 to 9.
(2) Highest subsection in terms of median of daily merits is Russian , at 52; the second and third highest is Turkish (at 11), and German (at 10). Some other subsections that have significant median of daily merits are Arabic, and Pilipinas (at 9), French (at 8 ), Indonesian (at 7), and Italian (at 6).
(3) Lowest subsection in terms of median of daily merits are Chinese, Dutch, Greek, Japanese, Romanian, Others, at 0.
(4) Minimum and maximum of daily merits (over all subsections) are 0 and 231, that was found in Russian board, while the maximum of daily merits in German board is a little lower at 201.
(5) Over 60 days, the top 5 subsections are Russian (3440, 35.1%), German (1070, 10.9%), Turkish (852, 8.7%), Pilipinas (821, 8.4%), and French (708 , 7.2%). Figures displayed in sum and percent, respectively.
Box plots
Outliers non-displayed

Outliers displayed (in red circles)

Pie chart


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
SuperTA
Full Member
***
Offline Offline

Activity: 196
Merit: 228



View Profile
September 07, 2019, 02:59:22 AM
 #14

Besides German mistake instead of 48 post per day they have 79 posts per day!

There is also Chinese and Indian mistake. It's not 0 posts per day.

In august Chinese Local Board has 224 posts / 31 days = 7.23 posts per day

Indian board has 293 posts / 31 days (aug) = 9.45 posts per day

I will report more accurate statistic for other countries in the future.
tranthidung
Hero Member
*****
Offline Offline

Activity: 602
Merit: 744



View Profile
September 07, 2019, 03:02:57 AM
 #15

Besides German mistake, there is also Chinese and Indian mistake. It's not 0 posts per day.

In august Chinese Local Board has 224 posts / 31 days = 7.23 posts per day

Indian board has 293 posts / 31 days (aug) = 9.45 posts per day
I don't know how DTalk scrapped and get data, but it seems OP did not solve deleted posts, that in turn caused total post counts of the second week equal to first week (results in 0 total new post), or even are lower if new posts made between week 1 and week 2 is lower than total deleted posts (results in negative total new posts)


░░░░░░░▄▄▄▄▄▄
░░░░▄██████████▄
░░░██████████████
░░██████▐▌██████
█████░░░░░░░▀█████
██████▄▄░░▄▄░░██████
████████░░▀▀▄██████
████████░░▄▄▄░░█████
██████▀▀░░▀▀▀░░█████
█████░░░░░░░░█████
░░██████▐▌██████
░░░██████████████
░░░░▀██████████▀
░░░░░░░▀▀▀▀▀▀
░░░
||
|
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 644
Merit: 2775

There are lies, damned lies and statistics. MTwain


View Profile WWW
September 07, 2019, 10:17:09 AM
 #16

<…>
The issue is that daily measures are very sensible to being heavily affected by post/thread deletion, where more posts can be deleted than created on a given day, rendering a negative number of created posts, or lowering the real number of created posts toll.

Even if you take this on a larger scale to try to minimize this effect, it may not always clear the picture. For example, the Chinese local board has a record of 11 net negative number month value of created posts (monthly reading - https://public.tableau.com/shared/63RSPTF3S?:display_count=yes&:origin=viz_share_link). The reason strives in the heavy deletion from the Main default board, the Altcoin board and the 山寨币 board (can’t make out what it means).

The root of it all is that counting the number of posts using the forum stats (current or archieved) will always render the net count (created – deleted – moved), without there being a way to dissociate them on the stats themselves. One would need to try to control that through alternative external methods (data scrapping involved) which seems an overly task to do, and pretty impossible to perform retrospectively.
 

SuperTA
Full Member
***
Offline Offline

Activity: 196
Merit: 228



View Profile
September 07, 2019, 02:57:18 PM
 #17



German (Deutsch) Bitcointalk forum for August 2019!
I counted posts one by one. The German Local Board has 2472 posts in August. That's  79,74 posts per day!

German Main Board (303 posts), Altcoins (Deutsch) (1269 posts), Auktionen (4 posts), Presse (30), Treffen (9), Off-Topic (Deutsch) (54), Projektentwicklung (50), Trading und Spekulation (378), Mining (Deutsch) (67), Anfänger und Hilfe (138), Suche (50), Biete (120).
..........................

All Together 2472 posts
79,74 posts per day in August 2019




Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!