Positive Phrases | Text Mining | Win a 2.5k HP Delegation

in positivity •  last month 

It was September 2018 when I last did something like this and it's time to dust of some code and find out who's been positive in their commentary on Hive.


The data I'm looking at are comments made from the 20th March 2020, 3 pm UTC right through until today. You will need to ask for a chart to be in the running for the prize, which is 2.5k HP delegated to an account of your choice (yourself is fine!) for a month.

Text Mining / Text Analytics

For a while now, I've been trying to surface various data and information using text held in posts/comments on Hive. The approach has been quite straight-forward, it works (sort of), but is only really scratching the surface of what could be done with a bit more time and programming competency.

Recently, I was passed this link by someone who I think can help me do more in depth and cool stuff in the future using the methods discussed in the article.

One of the text mining elements discussed is Sentiment Analysis.

Quantifying users content, idea, belief, and opinion is known as sentiment analysis. User's online post, blogs, tweets, feedback of product helps business people to the target audience and innovate in products and services. Sentiment analysis helps in understanding people in a better and more accurate way. It is not only limited to marketing, but it can also be utilized in politics, research, and security. source

An off the top of my head example would be to use a sentiment analysis method on with all posts with say, #leofinance and #hive, or #leofinance and #bitcoin.

Would it be possible to collect this information from post/comments and find out how, in a given week, those discussing Hive or Bitcoin on leofinance feel about these coins?

No clue, but at some point i'd like to give it a go and find out. And I wonder how it would compare to coingecko's feature that records user sentiment towards a token:


Anyway, I'm not there with that yet, and so it's back to some dirty SQL script to find out who, based on my selection of words and phrases, has been positive in their comments on Hive since it arrived late March. The words/phrases checked far are:

  • I love this
  • very kind
  • much appreciated
  • thank you so much
  • fantastic
  • well done
  • thank you very much
  • you are very kind
  • hive on!
  • I applaud you
  • you rock
  • excellent!
  • i am very happy
  • this is awesome
  • my pleasure
  • you are welcome
  • congratulations
  • a lovely
  • great!

My results:


And a grand total of 155, which I'm sure some of you will be able top. Those who are verbose have an advantage, but do their comments contain enough positive words/phrases?

The person who requests a chart and has highest total wins a 2.5k HP delegation for a month.



Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Nice, not sure how deep down the rabbit hole you've gone on this. However, if you do decide to go down the route of the tutorial, I'd recommend choosing a different data set as the one mentioned is movie reviews, essentially someone has labeled a ton on movie reviews which the model will use to classify against, the more relevant the type of content, the more relevant the sentiment usually. Fortunately, there are tons of similar labelings for various frameworks:


A method that is slightly less upfront work and could yield interesting result might be something like:


which would simply be an API request, you get 5,000 transactions free a month. I can't comment on the accuracy though as the last time I used it was a couple of years ago and was chat transcript classification.

While I'm here, I might as well ask for a chart too 👍. Could I get one for @quello as that account is much more active than my blog 🙈

Awesome, thanks for the links and the advice. There was a mention in the article of 'kaggle', although I've not read into it as yet.

I checked both your account and @quello, and no matches in comments i'm afraid.

If utopian was still around, this may have been different. Cheers.


Thank you for your engagement on this post, you have recieved ENGAGE tokens.

I'm quite confident that no-one can match either of you on this and so I've sent the delegation out already :)

@jlufer - 2500
@dswigle - 1500

To be returned 1st August.

Well done both, and thank you for your positivity on Hive!

Wow!! Thank you so much, Asher! @abh12345

I truly am at a loss for words and this is above and beyond! To get rewarded for something that you love doing makes it even sweeter!! I appreciate the extra bump you added. thank you for always trying to make Hive a better place.

I would also like to take a moment to congratulate @jlufer!! The man totally rocked it!! Nobody can touch his kindness!!

Thanks again!! Truly. You just made my month!!!

!tip .20

It's my pleasure, you both deserve a boost to go along with the positivity you spread around the Hive. Thank you!

Congratulations dear friend @dswigle as I said, nobody is more deserving of this award than you, I do not know another person who equals the sweetness you have when communicating with another person.

Thank you very much for being how you are
I wish you a wonderful day

Thank you and honestly, I toss the good vibes back to you! I feel blessed to have been given a gift so generous.

Let's both use it wisely! ;)

Have a wonderful day!


Thank you very much dear friend @dswigle for your appreciation
have a wonderful afternoon

🎁 Hi @jlufer! You have received 0.1 HIVE tip from @dswigle!

@dswigle wrote lately about: Nearly Independence Feel free to follow @dswigle if you like it :)

Sending tips with @tipU - how to guide.

🎁 Hi @abh12345! You have received 0.2 HIVE tip from @dswigle!

@dswigle wrote lately about: Nearly Independence Feel free to follow @dswigle if you like it :)

Sending tips with @tipU - how to guide.

how are you dear friend @ abh12345 good morning
What a pleasant surprise, I would never have thought that I had a chance of winning this delegation when I requested the information.

I want to congratulate you and thank you for the positive things you do for our social network and for the people, you are a worthy example to follow, having added another 1500 of delegation confirms it.

Thank you very much for what you do for all of us and especially for our beloved company Hive.
I take the opportunity to wish you a wonderful afternoon

Thank you for the kind words @julfer, you deserve this prize for your continuous positivity on Hive.

Thank you also for the tip, have a lovely week :)

While I do not see myself as a negative person, I also do not really see myself as a positive person either, I feel I am pretty neutral, So a chart, would be nice. I am always up for a good experiment. Thank you, what a lovely idea, I think this is awesome, you rock at charts. I applaud you for this excellent Idea. there all prepped for the next go around.

haha, yep, they will be in next time :)



Not to friendly, but not un-friendly, thank you. I do like these charts to see where I've been.

Please can i request a chart

Sure :)


55, not bad.

That's nice ... wish I was here since march.. thanks

Keep it up my friend and you'll top the charts! In the time you've been here, you've made a pretty good difference so take that as some awesome progress!

Thank you so much for your words of encouragement. They mean a lot to me

You're welcome! I've got a small surprise for you and a couple other people, more information to come about that soon! I'm going to try to get to it today but unsure if work will let me :)

Hello dear friend @ abh12345 good afternoon, I love this measurement, I would love to know how kind I am
I appreciate the time you invest in this type of information
have a beautiful afternoon

Thank you :)


Well! 701 is the total, amazing!

Thank you for your positivity on Hive!

Thank you very much for the information dear friend @ abh12345 That looks very good

Well done @jlufer!

You too have done very well dear friend @dswigle this award, without a doubt it is for you, I do not think that anyone can win you in sweetness, gentle and good treatment.
have a beautiful night

Right there! That is why you will be a winner every time! :) Thank you for your words, @jlufer.

You are, indeed, a kind gentle, man.


🎁 Hi @jlufer! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

One word WOW @jluferover 600 my god you are good

Oh go on man, I would love to see if I am on the scale. Whilst I think I'm a positive person I don't know if a lot of the wordings above are quite the things that I would say but you never know!!

And who can resist a bit of durty SQL!!

You seem, based on 100 beer review videos, like a positive chap to me, and that's prior to getting sloshed, I think!


If only 'top donk' was in the list?!

Hehe, that's not bad. I thought excellent would have been more but then realised that I was saying it a lot and tried to calm it down.

Top donk though, that's my fecking favourite!

I've been a bit mean with 'excellent' and 'great' and require a '!' to show that you really mean it!

Alright, looks quiet around here today, time to burn off some beer calories before refilling them later!

Burn em, add em rinse and repeat! It's the circle of life!!!

Bodacious dude.


I hope I win!

51 :)


What do you reckon to a go at Sentiment Analysis?

I think it works to some degree, but the problem is going to be that there is a wide range of language skill and background. I think it would require a far larger sampling and then cross-referenced with all other data surrounding an account - Facebook style :d

I like these though, it is fun and I would like to see more :)

What I do like is that I have a fair few "you are welcome" comments, which means I have helped at least 14 people in some way on-chain :)

Quite a big task and lots of words to crunch. I used to do this sort of thing quite often, will try to keep it going - just need ideas... :)

You are a nice person with a lot of quality content.. you feel like the winner already to me

I'd like to see what mine looks like my friend! Thanks!
This is awesome

LOL I was just trying to boost mine a little bit with some of those words ;)

Sadly the boosts wont help as the query end date was 3pm UTC today :P

Let's see...


96 in total and 'fantastic' leading the way in style!

Hahaha maybe I use that word a little too much. I figured, good luck to whomever wins the delegation!

Thanks for pulling the data!

Is there any way you could plug in "awesome" to it as well? I think I use that one a hell of a lot lol

Next time maybe :) You are leading the way thus far.

Would love to see mine too

Just one 'a lovely' and one 'much appreciated' for you - perhaps your positivity shines using different words :)

That's bad, might be I am showing the positivity with different vocabulary altogether.

I don't comment all the time so.

Yeah, just one 'you are welcome' for you. I'll have to come up with something for those that don't comment all the time - the 'silence awards' :)

Yes the silence awards, they give upvotes but never comment

How do I check mine?

I post a lot of positive posts, would love to see how my comments goes...

Just one 'I love this' in your comments on Hive - you must save the positivity for the posts!

lol, thanks for sharing.

@sidwrites @looftee you guys shoukd check this out!

Cheers for the shout-outs :D


thanks a lot buddy. I hope I shared some positivity around.

You definitely are with your posts and comments! 😁

Perhaps "awesomesauce" and "amazeballs" can be added for @traciyork haha!

I am a little nervous, like to think I'm a positive comment giver given the previous charting on the "swear list". I'll put that down to all my positive vibes being emphasised by the casual f bomb haha!

Let's have it please Mr Asher!

Traci would win by a mile with those badboy phrases included.

It's good to mix it up - 'fucking excellent!' would earn a point on both posts :)


54, not bad based on the charts so far. I wonder when Traci and the EL bunch will show up - there will likely be some 100+ scores in there I think.

Geez, @nickyhavey & @abh12345 - no wonder my ears are burning! 🤣

Okay, I'm game - whilst I'm a bit nervous since I've been lacking in the comment department for a bit, I'm hoping to at least hit double digits with the positive ones... 😝

Although now that I see that @dswigle has arrived, we should probably all just give in and the prize over to her... 😊🤗

Double digits have been reached :)


Not enough awesome and sauce it seems, sorry!

Denise is off the charts!

LOL! Yay, at least I hit my goal... 🤣 🤣

And no surprise there - you probably should've called the post, "Who Thinks They Can Come Within A Mile Of @dswigle's Delightful Discussions!" 😂

Well done :) And yes, that title looks like it would have suited better!


I slip off to work a while and bang! You hit me up with sweet nothings when I'm not looking! :) You both are too funny. Thanks for the encouraging comments, Traci! @traciyork xo

Oops, and forgot my manners (as evidenced by my chart...lol)! Thanks so much for doing this, @abh12345!

!tip hive

My pleasure, thank you for the tip!

🎁 Hi @abh12345! You have received 0.1 HIVE tip from @traciyork!

Sending tips with @tipU - how to guide.

  ·  last month (edited)

@traciyork - I can't believe you said that. If you look at my thing there's only one word that I say. I think I'm going to have to expand my vocabulary now that I know that there's a contest for being nice I'm going to have to work at it!

PS I love you.




It looks just like you! You rock too, my amazeballs friend! Thank you so much!


🎁 Hi @traciyork! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

🎁 Hi @traciyork! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

Haha! Oh, you are bad! (Do I get dinged for not nice comments?) You are the best, Traci! Love you!


🎁 Hi @traciyork! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

Well that's fucking great!

Was expecting much worse with the whole, you know, being a part timer thing 😏

I think you should do a separate one for Traci haha! With and without "awesomesauce" 😁

ROTFLMAO, Nicky! Well fucking done (or should that be, fucking well done... 🤣) to you. With or without some sauce that's awesome, my chart would most likely look the same, as I've been a wicked slacker in the commenting department over the past few months... working on redeeming myself though...🤣

Haha!! Yeah I have peaks and troughs of activity depending on how wicked crazysauce it is in the old music arena so no sweat! We'll be back with vengeance! Great!

(sneaking that one in there for next time haha)

I'm going to have to think of some new phrases for next time 😜

Haha, damn, going to have to buy a "positive phrase" book and just bombard the comments section with them in hope for a better score 😂

What a joyous place Hive would seem to be if everyone did that :D

Oh!! Do me! I need the SP to feed the fishes! This is absolutely great! I love this kind of contest! Well done! I applaud you for thinking of this! Congratulations on your 100,000 SP yourself!

It is very kind of you to think of us and it is appreciated! You rock! I am very happy to be part of all of this! You always have such fantastic ideas! A lovely day to you! Rock on!


Well if you don't win this time, things are looking good for the next one! :D


650! I might as well send the delegation over right now!

Bravo, can we have a thousand more @dswigle's here please?!

Holy crap that's a lot of thank you's! I like it! Keep it up @dswigle, ousted me as the current top contender for this. Indeed if we could have more doing this, imagine how many would love this place to stay!

@cmplxty Thank you so much for the words! I'm sorry to bump you off like that, but, Asher will find yet another contest that he dreams up one of these nights! We will have to be on the lookout!

I hope you have a great night!


@dswigle wow like wow no more words, and so deserved

You have this one, just different words!

Thank you so much @brittandjosie! I appreciate your words, always.

Have an awesome day!


🎁 Hi @brittandjosie! You have received 0.1 HIVE tip from @dswigle!

@dswigle wrote lately about: Christmas In July With Market Friday Feel free to follow @dswigle if you like it :)

Sending tips with @tipU - how to guide.

🎁 Hi @cmplxty! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

wooow I'm just gonna go ahead and congratulate @dswigle :D Awesomely done!

Sweet, @Kristyglas! But, the honor will be @jlufers! Thank you so much for the kind comment though. :)


aww good luck next time!
thank you for the tip <3

🎁 Hi @kristyglas! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

Wow. I didn't expect a lot of thank you so much from @dswigle. You're generous in distributing kind words. I hope I get mine some day.
Thank you. 🥺🥺🥺

I tend to get comments on my post and I tried to answer every single one. It's hard not to be thankful when people take the time and energy to send you a comment, especially a well-thought-out one. Of course, we don't all have time for well-thought-out comments and I leave tiny little pops of words here and there, and I appreciate them all, and hope that they do also. Thank you for leaving your words . Have a wonderful day!


Ohh. I see where the thank yous come from. Lol 😆😆
You're very nice in replying. It's good to reply every one of them. I do that too.
Thank you very much for your response.
You're very kind

The pleasure is mine. Always.

🎁 Hi @beckie96830! You have received 0.1 HIVE tip from @dswigle!

@dswigle wrote lately about: Nearly Independence Feel free to follow @dswigle if you like it :)

Sending tips with @tipU - how to guide.

Ohh thank you very much

Had to make it bigger so I could see what I was saying way too much and what I never say! Here's hoping that I do well enough to get it, it would be awesome to be able to have a bigger vote. Thanks for doing that for me!

I'm going to take this post home with me so more people will know that this is going on! Thanks so much, Asher! @abh12345


Yes you'll need to go to 'replies' and see the comment/chart in full.

A huge amount of positivity and I think you have this one in the bag :)

Thanks for the tip!

  ·  last month (edited)

I can see @jlufer trounced me! I couldn't have lost to a more deserving person.

There is no denying his always kind and gentle nature.

Hello dear friend @dswigle, I appreciate your kind words, but it is impossible to defeat you, I have always admired your sweet way of being and on several occasions I have mentioned it to you, the people who visit your blog are pleased with the warmth and sweetness that there is in your words

I appreciate very much dear friend @ abh12345 your comment

I wish you a beautiful night and a happy rest

Thank you @jlufer. You know I feel the same about you. Have a peaceful rest.


🎁 Hi @jlufer! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.

Well I think you two are out of sight and so I may have to reassess the delegations :)

And I agree, he is very polite and positive!

Thank you so much for your kind comment and whether it happens or not, my heart is smiling just knowing that you thought of it.

Thank you so much, Asher! With comments like these it's easy to feel positive.

Have a great night!


I'll hold off for a few days, even though I think the 1,2 positions are pretty safe.

Thank you for the tip!

🎁 Hi @abh12345! You have received 0.1 HIVE tip from @dswigle!

Check out @dswigle blog here and follow if you like the content :)

Sending tips with @tipU - how to guide.