Emoji Sentiment
Are people that use emoji happier?
@kaggle.harriken_emoji_sentiment
Are people that use emoji happier?
@kaggle.harriken_emoji_sentiment
CREATE TABLE commentinteractions_cleaned (
"unnamed_0" BIGINT,
"employee" BIGINT,
"companyalias" VARCHAR,
"liked" BOOLEAN,
"disliked" BOOLEAN,
"commentid" VARCHAR,
"likes" BIGINT
);
CREATE TABLE comments2emoji_frequency_matrix_cleaned (
"unnamed_0" BIGINT,
"id" BIGINT,
"coa" VARCHAR,
"commentid" VARCHAR,
"txt" VARCHAR,
"like" BIGINT,
"nolike" BIGINT,
"date" TIMESTAMP,
"uid" VARCHAR,
"nchar" BIGINT,
"emoji_count" BIGINT,
"emoji_negative_sum" BIGINT,
"emoji_positive_sum" BIGINT,
"x1f53a" BIGINT,
"x1f356" BIGINT,
"x1f357" BIGINT,
"x1f354" BIGINT,
"x1f355" BIGINT,
"x1f352" BIGINT,
"x1f353" BIGINT,
"x1f351" BIGINT,
"x1f451" BIGINT,
"x1f1ea" BIGINT,
"x1f1eb" BIGINT,
"x1f455" BIGINT,
"x1f1ee" BIGINT,
"x1f1ef" BIGINT,
"x1f924" BIGINT,
"x1f927" BIGINT,
"x1f926" BIGINT,
"x1f921" BIGINT,
"x1f923" BIGINT,
"x1f922" BIGINT,
"x1f534" BIGINT,
"x1f35f" BIGINT,
"x1f35e" BIGINT,
"x1f1e6" BIGINT,
"x1f3de" BIGINT,
"x1f3dd" BIGINT,
"x1f3c3" BIGINT,
"x1f3c4" BIGINT,
"x1f3c5" BIGINT,
"x1f3c6" BIGINT,
"x1f3c7" BIGINT,
"x1f38a" BIGINT,
"x1f38f" BIGINT,
"x1f69c" BIGINT,
"x1f69a" BIGINT,
"x1f628" BIGINT,
"x1f629" BIGINT,
"x1f626" BIGINT,
"x1f627" BIGINT,
"x1f624" BIGINT,
"x1f625" BIGINT,
"x1f622" BIGINT,
"x1f623" BIGINT,
"x1f621" BIGINT,
"x1f381" BIGINT,
"x1f459" BIGINT,
"x1f383" BIGINT,
"x1f382" BIGINT,
"x1f385" BIGINT,
"x1f384" BIGINT,
"x1f386" BIGINT,
"x1f389" BIGINT,
"x1f388" BIGINT,
"x1f3ca" BIGINT,
"x1f3cb" BIGINT,
"x1f3d6" BIGINT,
"x1f3cd" BIGINT,
"x1f3ce" BIGINT,
"x1f5e3" BIGINT,
"x1f692" BIGINT,
"x1f691" BIGINT,
"x1f58d" BIGINT,
"x1f697" BIGINT,
"x1f62f" BIGINT,
"x1f62d" BIGINT,
"x1f62e" BIGINT,
"x1f62b" BIGINT,
"x1f62c" BIGINT,
"x1f62a" BIGINT,
"x1f499" BIGINT,
"x1f498" BIGINT,
"x1f495" BIGINT,
"x1f494" BIGINT,
"x1f496" BIGINT,
"x1f491" BIGINT,
"x1f493" BIGINT,
"x1f319" BIGINT,
"x1f315" BIGINT,
"x1f49e" BIGINT,
"x1f49d" BIGINT,
"x1f49a" BIGINT,
"x1f619" BIGINT,
"x1f49c" BIGINT,
"x1f49b" BIGINT,
"x1f593" BIGINT,
"x1f31b" BIGINT,
"x1f31c" BIGINT
);
CREATE TABLE ijstable (
"char" VARCHAR,
"unnamed_1" VARCHAR,
"unicode" VARCHAR,
"occurrences" VARCHAR,
"position" VARCHAR,
"neg" VARCHAR,
"neut" VARCHAR,
"pos" VARCHAR,
"sentiment_score" VARCHAR,
"sentiment_bar" VARCHAR,
"unicode_name" VARCHAR,
"unicode_block" VARCHAR
);
CREATE TABLE n__readervswriter (
"unnamed_0" VARCHAR,
"emoji" VARCHAR,
"s_writer" DOUBLE,
"s_reader" DOUBLE,
"sd" DOUBLE,
"count" BIGINT,
"description" VARCHAR,
"unnamed_7" VARCHAR,
"diff" DOUBLE
);
CREATE TABLE votes_cleaned (
"unnamed_0" BIGINT,
"employee" BIGINT,
"companyalias" VARCHAR,
"votedate" TIMESTAMP,
"vote" DOUBLE,
"uid" VARCHAR,
"vote_original" BIGINT,
"uiddate" VARCHAR
);
Anyone who has the link will be able to view this.