Twitter Sentiment Analysis And Word Embeddings
A dataset containing 940k+ tweets about Messi&Ronaldo, and GloVe+Sentiment140
@kaggle.ibrahimserouis99_twitter_sentiment_analysis_and_word_embeddings
A dataset containing 940k+ tweets about Messi&Ronaldo, and GloVe+Sentiment140
@kaggle.ibrahimserouis99_twitter_sentiment_analysis_and_word_embeddings
CREATE TABLE cleaned_messi_tweets (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" BIGINT,
"like_count" BIGINT,
"quote_count" BIGINT
);
CREATE TABLE cleaned_ronaldo_tweets (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" DOUBLE,
"like_count" DOUBLE,
"quote_count" DOUBLE
);
CREATE TABLE messi_final (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" BIGINT,
"like_count" BIGINT,
"quote_count" BIGINT,
"prediction" DOUBLE,
"label" VARCHAR
);
CREATE TABLE messi_tweets (
"tweet_id" VARCHAR,
"author_id" VARCHAR,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" VARCHAR,
"like_count" VARCHAR,
"quote_count" VARCHAR
);
CREATE TABLE predictions_messi (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" BIGINT,
"like_count" BIGINT,
"quote_count" BIGINT,
"prediction" DOUBLE,
"label" VARCHAR
);
CREATE TABLE predictions_ronaldo (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" DOUBLE,
"like_count" DOUBLE,
"quote_count" DOUBLE,
"prediction" DOUBLE,
"label" VARCHAR
);
CREATE TABLE ronaldo_final (
"tweet_id" BIGINT,
"author_id" BIGINT,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" DOUBLE,
"like_count" DOUBLE,
"quote_count" DOUBLE,
"prediction" DOUBLE,
"label" VARCHAR
);
CREATE TABLE ronaldo_tweets (
"tweet_id" VARCHAR,
"author_id" VARCHAR,
"content" VARCHAR,
"lang" VARCHAR,
"date" VARCHAR,
"source" VARCHAR,
"geo" VARCHAR,
"retweet_count" VARCHAR,
"like_count" VARCHAR,
"quote_count" VARCHAR
);
Anyone who has the link will be able to view this.