Bitcoin Forum
May 11, 2024, 04:02:29 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: 1 2 [All]
  Print  
Author Topic: Forum Word Clouds - Which words are most common in Topics  (Read 348 times)
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 11, 2018, 06:25:53 PM
Last edit: May 12, 2018, 12:56:04 PM by DdmrDdmr
Merited by vlom (2), stompix (1), coinlocket$ (1), krishnapramod (1), TMAN (1), nev1d (1)
 #1

I have created a word cloud for 9 section/subsections selected at my discretion, using the Topic names only, for the most recent 200 Topics in each of these exercises. Topics get moved around often, so the actual words could change from hour to hour really, but it's not a bad starting point for this analysis.

The idea is to see which are the most trending words in each and see if there are any surprises at all.

1. Bitcoin Discussion

The word Bitcoin rules by far in this section (fortunately), but check out market players: Bill, Gates, Sach, Warren. Government and banks are on the list too ...

2. Development & Technical Discussion

Bitcoin, Network, Blockchain, Lightning, Transaction and Help are at the top.

3. Economics

Bitcoin rules again, followed by cryptocurrency, crypto, blockchain, money and price.


4. Marketplace

Bitcoin, followed by crypto, cryptocurrency, mining, bittrex, bitfinex, market, binance.. and bots!

5. Meta

Merit (no surprise) rules along side account; forum and hacked follow. I didn't see Sir, but maybe Please is replacing it ..

6. Beginners & Help

Beginners is all about bitcoin.. and bounty ..

7. Altcoin Discussion

Etherum/ETH are the main focus in detriment of Bitcoin. Regret is pretty large ..

8. Trading Discussion

Trading is the center. think and strategy are there, but so are fud and dump (I guess the meaning is not what i'm thinking in this case)..


9. Bounty Altcoins

Bounty is the obvious center, followed by Airdrop, Blockchain, Tokens, Campaign, Reward/Rewards (which, if aggregated, would be near the size of Bounty). Icons are a large active to the word cloud too.

Note: The tool I used eliminates numbers (which in this case is good because page numbers would otherwise show up in the word cloud) and dollar signs  amongst others, so $ is not shown..
BitcoinCleanup.com: Learn why Bitcoin isn't bad for the environment
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1715400149
Hero Member
*
Offline Offline

Posts: 1715400149

View Profile Personal Message (Offline)

Ignore
1715400149
Reply with quote  #2

1715400149
Report to moderator
1715400149
Hero Member
*
Offline Offline

Posts: 1715400149

View Profile Personal Message (Offline)

Ignore
1715400149
Reply with quote  #2

1715400149
Report to moderator
vlom
Legendary
*
Offline Offline

Activity: 1498
Merit: 1117


View Profile
May 11, 2018, 06:31:32 PM
 #2

what surprised me most is that the word scam is not used more often. i thought that complaints about being scamed are more frequent. or scam accusations. or false scam accusations.
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 11, 2018, 07:21:18 PM
 #3

what surprised me most is that the word scam is not used more often. i thought that complaints about being scamed are more frequent. or scam accusations. or false scam accusations.

It kind of crops up in the Beginners & Help Word Cloud (near the bottom) and in the Altcoin Discussion (north west of Ethereum), but in a lesser font size since other words are repeated with a higher frequency. It also present in other sections subjects too, but not frequently enough to be drawn.
seoincorporation
Legendary
*
Offline Offline

Activity: 3150
Merit: 2933


Top Crypto Casino


View Profile
May 11, 2018, 08:08:07 PM
 #4

Well, it is good to see that the Bitcoin forum still has Bitcoin as the main topic.
When I took the first look to your thread I was expecting "Merit" and "Scam" as the most used words, due to the rising of scamming accusations regarding merit, as it is happening at least on the meta board. I'm glad to see "Bitcoin" is still the center of the matter in here, as well as "Ethereum" in the Altcoin Section, instead of "Bounty", "ICO" or "Airdrop".

Nevertheless, the meta activity is still somehow concerning, for maybe the correct principal subject should be "Forum", as it probably used to be.
Once more, thanks for your work, great, as usual.

█████████████████████████
████▐██▄█████████████████
████▐██████▄▄▄███████████
████▐████▄█████▄▄████████
████▐█████▀▀▀▀▀███▄██████
████▐███▀████████████████
████▐█████████▄█████▌████
████▐██▌█████▀██████▌████
████▐██████████▀████▌████
█████▀███▄█████▄███▀█████
███████▀█████████▀███████
██████████▀███▀██████████
█████████████████████████
.
BC.GAME
▄▄░░░▄▀▀▄████████
▄▄▄
██████████████
█████░░▄▄▄▄████████
▄▄▄▄▄▄▄▄▄██▄██████▄▄▄▄████
▄███▄█▄▄██████████▄████▄████
███████████████████████████▀███
▀████▄██▄██▄░░░░▄████████████
▀▀▀█████▄▄▄███████████▀██
███████████████████▀██
███████████████████▄██
▄███████████████████▄██
█████████████████████▀██
██████████████████████▄
.
..CASINO....SPORTS....RACING..
█░░░░░░█░░░░░░█
▀███▀░░▀███▀░░▀███▀
▀░▀░░░░▀░▀░░░░▀░▀
░░░░░░░░░░░░
▀██████████
░░░░░███░░░░
░░█░░░███▄█░░░
░░██▌░░███░▀░░██▌
░█░██░░███░░░█░██
░█▀▀▀█▌░███░░█▀▀▀█▌
▄█▄░░░██▄███▄█▄░░▄██▄
▄███▄
░░░░▀██▄▀


▄▄████▄▄
▄███▀▀███▄
██████████
▀███▄░▄██▀
▄▄████▄▄░▀█▀▄██▀▄▄████▄▄
▄███▀▀▀████▄▄██▀▄███▀▀███▄
███████▄▄▀▀████▄▄▀▀███████
▀███▄▄███▀░░░▀▀████▄▄▄███▀
▀▀████▀▀████████▀▀████▀▀
bigmelons25
Member
**
Offline Offline

Activity: 240
Merit: 10


View Profile
May 11, 2018, 08:23:13 PM
 #5

what a pointless thread, op just fishing for merit.
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 11, 2018, 08:25:00 PM
 #6

what a pointless thread, op just fishing for merit.

You’re pretty dumb for a newbie. Bring something new to the table or lurk in the gutters
vlom
Legendary
*
Offline Offline

Activity: 1498
Merit: 1117


View Profile
May 12, 2018, 11:46:34 AM
 #7

what a pointless thread, op just fishing for merit.

no so pointless as your comment. and have a look how many merits OP received. just two from me. the OP did somesthing and i like what he did. thats why i sent him two. btw: i am generous in giving merits. soon i wont have any left.

@OP: could you please provide the figures too. not just the pictures.
stompix
Legendary
*
Offline Offline

Activity: 2884
Merit: 6316


Blackjack.fun


View Profile
May 12, 2018, 12:10:00 PM
 #8

Hmm, pretty interesting..
Segwit missing (or I'm missing it) from Bitcoin Discussion, guess nobody cares discussing it
Philippines and China the top countries in Economics

Edit.

Another interesting thing to do would be to do the same as in the OP but going in deeper: not just Subject name as I have done, but going in to the actual threads and getting their content too. That, from outside the forum software, is too cumbersome to do too, but conceptually interesting.

Oh, just realized this is only for the topic titles, I though first it is for the content of the last 200 topics.
That one would be interesting....

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 12, 2018, 12:11:23 PM
 #9

@OP: could you please provide the figures too. not just the pictures.

Danke.. Unfortunately, the software I used is very simple and only gives me the actual word count if I go and click word by word .. I'd take ages with this tool to get a word count....

What I really had in mind was doing something similar but based on social network traffic such as twitter, facebook and so on, just to see what could be retrieved in relation to Bitcointalk. The idea was to treat the forum as a brand and see what the associated word cloud looked like. This is often done in marketing, along with obtaining the sentiment, temperature and tone of the related flowing messages for example.
Alas, what I found around for free didn't convince me, and it was rather partial and thus non-representative. These kind of studies can be performed by social media agencies, but I lack direct access to the tools.

Another interesting thing to do would be to do the same as in the OP but going in deeper: not just Subject name as I have done, but going in to the actual threads and getting their content too. That, from outside the forum software, is too cumbersome to do too, but conceptually interesting.
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 12, 2018, 12:39:49 PM
 #10

Oh, just realized this is only for the topic titles, I though first it is for the content of the last 200 topics.
That one would be interesting....

Yes, It would be great to actually go into the threads, but for now topic titles is the deepest we can go without better access to forum content data.
The idea was to create these word clouds for fun, and see if any weird stuff cropped up on the subjects themselves.

Note: Added bounties..
MagicSmoker
Full Member
***
Offline Offline

Activity: 420
Merit: 182



View Profile
May 12, 2018, 12:44:01 PM
 #11

Interesting work, but I'd filter out some of the common words which are ambiguous or meaningless without more context like: more, again, never, just, world, take, only, now, etc...

Honestly, upon further consideration I don't know that much can be inferred even from seemingly unambiguous words like, "recommend," as someone could either be recommending for or against a course of action.

To be somewhat more constructive rather than just point out crap I don't like - because who likes a Debbie Downer, right? - I would filter on just coin names for the altcoin sections as that would show relative interest levels and actually be quite useful as a gauge of sentiment/popularity for various coins.

DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 12, 2018, 12:54:36 PM
 #12

<...>

Sure, what you say makes sense. Bare in mind that the tool I used is extremely simple and going only into subject names is not that profound.Whole threads should give us better underlying view into favoured concepts/terms. What this does open up is an interesting possibility to perform these kind of analysis for anyone with access to better tools and a larger master of them applying content/context based filters to group or exclude terms and so forth.

Even more interesting would be to do stuff such as what I wrote on my reply to vlom a few posts above, with social network analysis of Bitcointalk as a brand. That is out of my personal scope though.
Coin-1
Legendary
*
Offline Offline

Activity: 2450
Merit: 2190



View Profile
May 12, 2018, 01:21:41 PM
 #13

I have created a word cloud for 9 section/subsections selected at my discretion, using the Topic names only, for the most recent 200 Topics in each of these exercises. Topics get moved around often, so the actual words could change from hour to hour really, but it's not a bad starting point for this analysis.
Good work. But it is not convenient to look at these images representing clouds. You better to post the most frequently used words as a text in some order. And as it mentioned above, the common words and particles that not concerned to the crypto world should be omitted.

And I am not surprised that the one of the most frequently used word in the current section is "merit". Smiley
digaran
Copper Member
Hero Member
*****
Offline Offline

Activity: 1330
Merit: 899

🖤😏


View Profile
May 12, 2018, 02:36:09 PM
 #14

I'm surprised there is no mention of prostitution, alia and cute little slaves. <insert lol here>.

🖤😏
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 12, 2018, 02:40:48 PM
 #15

I'm surprised there is no mention of prostitution, alia and cute little slaves. <insert lol here>.

I figure they were not yesterday night's trending topics ... (the graphics are based on last 200 topic headers at time of editing).
Beerwizzard
Full Member
***
Offline Offline

Activity: 924
Merit: 148



View Profile
May 12, 2018, 04:36:14 PM
 #16

Well, those pics once again show how bad is the Economics section. The most popular keywords mostly consist of the common things that could be also popular in other sections. I see  a strong lack of any kind of "intellectual" economic discussion there while people are trying to spam this section mostly with the crypto shit.
gantez
Full Member
***
Offline Offline

Activity: 1736
Merit: 121


View Profile
May 12, 2018, 08:31:51 PM
 #17

what a pointless thread, op just fishing for merit.

Your post is amplifying hate for innovative work. Again, if you are creative then show it because users will appreciate it too by either giving some merit or thumbs up. But if you do a shit stunt,  Grin.....I trust the users that you must surely get a spank on the ass
TomCrypto
Full Member
***
Offline Offline

Activity: 715
Merit: 220


View Profile
May 12, 2018, 09:15:40 PM
 #18

Nice Job! It give indeed a good overview of the different part of the forum.
As stated before, filtering of common words (even if this is manual filtering) would be great in order to be more accurate.
But again, congrats for your job!
Welsh
Staff
Legendary
*
Offline Offline

Activity: 3262
Merit: 4110


View Profile
May 12, 2018, 09:54:10 PM
 #19

I was hoping to construct a reply based on the words used in this section, but my creativity isn't good enough. Quite enjoy these statistics that you keep releasing though. The good thing about these word clouds is that I would expect most of these words to consist in their given sections. I guess that it shows that most of the topics/threads in each section are at least on topic somewhat.
Tyrantt
Hero Member
*****
Offline Offline

Activity: 1022
Merit: 564

Need some spare btc for a new PC


View Profile
May 13, 2018, 12:17:30 PM
 #20

I'm surprised there is no mention of prostitution, alia and cute little slaves. <insert lol here>.

haha that's why I'd like to see one made for politics and society.  Grin

Well, those pics once again show how bad is the Economics section. The most popular keywords mostly consist of the common things that could be also popular in other sections. I see  a strong lack of any kind of "intellectual" economic discussion there while people are trying to spam this section mostly with the crypto shit.

Well not that much. Economics is a wide term and pretty much everything is on topic there. Tho, I'm surprised with that "Philippines" and that the words like "end" or "die" aren't a little more involved, since people there tend to create lots of "is bitcoin dead" topics. Even more now when the price's lower. Grin

Need some spare btc for a new PC that can at least run Adobe Dreamweaver.

BTC - 19qm3kH4MZELkefEb55HCe4Y5jgRRLCQmn ♦♦♦ ETH - 0xd71ACd8781d66393eBfc3Acd65B224e97Ae1952D
olari
Newbie
*
Offline Offline

Activity: 322
Merit: 0


View Profile
May 13, 2018, 02:53:09 PM
 #21

Using this knowledge everyone is able to create an attractive and very interesting thread Grin in any part of bitcointalk forum.
As for me, using this words for write sentences can be really funny!
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 14, 2018, 11:47:52 AM
 #22

Seems legit. What tool did you use to make these?
Have you manually examined all of the topic titles then create a Photoshop (or MSPaint) image?

It's based on the recent 200 titles alright, and the images just displayed almost half of it [but the whole thing (except the center) looks uninteresting ],
I want to see most of them.

I think if this was a phrase cloud and not limited to thread titles, the whole forum's center and largest would be: "I think"

This initial approach is a rather simple one. What I was looking for was trending words, thus the focus on 200 topic titles per forum section/subsection. I'm working on a more complex one, but it takes quite some time and it has to be done in off hours.
The painting part is done using a tool called Worditout. It's simple, but for this scenario it got the job done.
DdmrDdmr (OP)
Legendary
*
Offline Offline

Activity: 2310
Merit: 10759


There are lies, damned lies and statistics. MTwain


View Profile WWW
May 28, 2018, 05:46:34 PM
Last edit: May 28, 2018, 07:06:34 PM by DdmrDdmr
 #23

I've tried to replicate the exercise in the OP, but instead of focusing on topic title (which is what I did before), I went for the whole merited post content. I has hopes that it would bring something meaningful, but I'm not convinced now, and actually prefer the results of the first approach (trending topics) to the later (merited posts), although the context is different.

The WordCloud I've created is for Meta. What I've done is count the number of occurrences all the words of all the Meta merited posts, then group manually words with a common structure (i.e. Merit and Merits) from the top of the list, and finally proceeded to perform a manual selection at my discretion of what I considered were relevant words (i.e. discard words like 'the', 'to', 'this' and so on).

The result for Meta is as follows:


It varies from the OP WordCloud for Meta, but I don’t see a clear relation to being merited by using a certain set of keywords. This goes to show, as I see it, that it’s not just the words that are necessary, but a proper construction and context.  Of course these are not retrievable from just a word count, nor is the post’s overall tone and style.

The number of occurrences of the above words is as follows in the aggregate Meta awarded posts:
Code:
tag                                     nTimes
---------------------------------------------
rank                                    5900
Post                                    9978
Merit                                   7631
thread                                  1924
give                                    4565
forum                                   2071
people                                  2062
system                                  2017
sMerit                                  1680
account                                 1304
spam                                    1764
members                                 1764
User                                    1999
think                                   1331
topic                                   1454
time                                    1082
board                                   1214
quality                                 891
need                                    811
know                                    801
receive                                 898
Bitcoin                                 665
trust                                   659
newbies                                 877
source                                  598
campaign                                831
activity                                533
read                                    465
help                                    454
signature                               432
find                                    392
take                                    392
theymos                                 390
work                                    381
better                                  370
list                                    369
Jr                                      359
earn                                    358
Discussion                              349
section                                 349
Hero                                    326
problem                                 319
idea                                    312
Legendary                               299
bitcointalk                             296
English                                 289
trying                                  286
rules                                   280
community                               268
Please                                  268
person                                  267
example                                 265
understand                              259
believe                                 255
bad                                     254
bounty                                  254
reason                                  254
negative                                251
great                                   243
data                                    242
link                                    239
hope                                    238
unique                                  237
agree                                   234
different                               234
OP                                      230
money                                   229
profile                                 228
local                                   226
change                                  224
create                                  218
opinion                                 214
check                                   212
question                                201
meta                                    200
learn                                   197

I'm not sure it's a line of work worth pursuing...
Pages: 1 2 [All]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!