Emojis are the easiest way to show emotion through text. We all use them very often.
Have you ever wondered which emojis are most commonly used on HIVE? I did. As a small weekend project i decided to find that out.
At first,i needed a dataset in order to start analysis. I got latest 100k content from hivemind with the query below and saved into a csv.
SELECT body from hive_posts_cache ORDER BY post_id desc LIMIT 100000;
Dataset consist of mixed posts+comments.
This small piece of python script does the job:
import operator
import csv
import emoji
def extract_emojis(s):
return ''.join(c for c in s if c in emoji.UNICODE_EMOJI)
with open('data.csv', 'r') as file:
content = file.read()
emojis = extract_emojis(content)
group = {}
total = 0
for e in emojis:
total += 1
if e in group:
group[e] += 1
else:
group[e] =1
sorted_group = sorted(group.items(), key=operator.itemgetter(1), reverse=True)
print('Total: {}'.format(total))
print("""
| Emoji | Name | Count | Percent |
| -------- | -------- | -------- | -------- |""")
for i in sorted_group[0:40]:
[em, count] = i
name = emoji.demojize(em).replace(':', '')
perc = 100 * count/total
print('|{} | {} | {} | {}% |'.format(em, name, count, '{:.2f}'.format(perc)))
20,127 emojis matched in total.
Here is list of the most used 40 emojis:
| Emoji | Name | Count | Percent |
|---|---|---|---|
| 👍 | thumbs_up | 1554 | 7.72% |
| 😊 | smiling_face_with_smiling_eyes | 1316 | 6.54% |
| 😂 | face_with_tears_of_joy | 1041 | 5.17% |
| 😉 | winking_face | 858 | 4.26% |
| 😁 | beaming_face_with_smiling_eyes | 797 | 3.96% |
| 🙂 | slightly_smiling_face | 753 | 3.74% |
| 😍 | smiling_face_with_heart-eyes | 752 | 3.74% |
| ❤ | red_heart | 749 | 3.72% |
| 😀 | grinning_face | 652 | 3.24% |
| 🤣 | rolling_on_the_floor_laughing | 583 | 2.90% |
| 🤗 | hugging_face | 561 | 2.79% |
| 🎉 | party_popper | 419 | 2.08% |
| 🙏 | folded_hands | 408 | 2.03% |
| 🥳 | partying_face | 363 | 1.80% |
| 🍍 | pineapple | 327 | 1.62% |
| 😎 | smiling_face_with_sunglasses | 301 | 1.50% |
| 😅 | grinning_face_with_sweat | 295 | 1.47% |
| 😄 | grinning_face_with_smiling_eyes | 251 | 1.25% |
| 😘 | face_blowing_a_kiss | 249 | 1.24% |
| 👏 | clapping_hands | 248 | 1.23% |
| 👌 | OK_hand | 229 | 1.14% |
| 🥰 | smiling_face_with_3_hearts | 221 | 1.10% |
| 👋 | waving_hand | 205 | 1.02% |
| 💕 | two_hearts | 198 | 0.98% |
| ♥ | heart_suit | 194 | 0.96% |
| 😃 | grinning_face_with_big_eyes | 193 | 0.96% |
| ✅ | white_heavy_check_mark | 191 | 0.95% |
| 🍻 | clinking_beer_mugs | 166 | 0.82% |
| 🏼 | medium_light_skin_tone | 158 | 0.79% |
| ☺ | smiling_face | 147 | 0.73% |
| 😆 | grinning_squinting_face | 144 | 0.72% |
| 📸 | camera_with_flash | 139 | 0.69% |
| 💪 | flexed_biceps | 139 | 0.69% |
| 🌺 | hibiscus | 138 | 0.69% |
| ✌ | victory_hand | 135 | 0.67% |
| 🔥 | fire | 131 | 0.65% |
| 🤙 | call_me_hand | 128 | 0.64% |
| 💖 | sparkling_heart | 115 | 0.57% |
| 🙌 | raising_hands | 115 | 0.57% |
| 💥 | collision | 114 | 0.57% |
According to the results, i can say that generally positive content is published on HIVE.
You can find source code here.
Hive on!
Now that is some great analysis!
Thumbs up!
I don't even know how to call an emoji! But I know how to call tipu!
@tipu curate
Upvoted 👌 (Mana: 6/28)
Thank you!
I have never wondered how often some emojis are used on Hive but now I want to know
Interesting, people tend to use emoji when they want to convey positive emotions. Opposite, usually ends up short without emojis 😊
yes, apparently that's right 😀
Nah. I don't like Emojis. I use emoticons :D
This is some analysis that I never knew I needed in my life, but boy am I glad that it exists. If anyone ever asks, I'm now prepared to tell them which emoji is the most popular on Hive. Cheers 👍
ESTM Boosting refund to @talhasch!
Due to one of these reasons:
1. Post is not published with Esteem apps.
2. Post is already curated by Esteem team.
3. Post is not curated by our curators within 24 hours.
4. Post might be too old post, try more recent content.
5. Author already received vote in last few hours, try again later.
Install Android: https://android.esteem.app, iOS: https://ios.esteem.app mobile app or desktop app for Windows, Mac, Linux: https://desktop.esteem.app
Learn more: https://esteem.app
Join our discord: https://discord.me/esteem
Wow, amazing job ! 👏
Nice post
And then there is me who never used a single emoji on Hive :D