The most used emojis on HIVE

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:

According to the results, i can say that generally positive content is published on HIVE.

You can find source code here.

Hive on!