Dataset: EPL Teams - Twitter Sentiment Dataset

About this Dataset

EPL Teams - Twitter Sentiment Dataset

Introduction

Contains tweets of all teams in the English Premier League with their team hashtag. i.e. #Arsenal, #Chelsea.
Useful for analysing certain events and how they affect supporter behaviour/sentiments.
I've added an additional field called polarity which has the sentiment computed from the text field.
Feel free to explore! Feedback is much appreciated!

Content

Each row represents a tweet. Creation Dates of Tweets Range from 12/07/2020 to 19/09/2020. Will update on a Monthly cadence.

The Team
can be derived from the file_name field.
The Date at which the tweet was created can be got from created_at field.
The Search Query used to query the Twitter Search Engine can be got from search_query field.
The Tweet Full Text can be got from the text field.
The Sentiment can be got from polarity field. (I've used the Vader Model from NLTK to compute this.)

Acknowledgements

Thanks to the tweepy package for making the data extraction via Twitter API so easy.

Shameless Plug

Feel free to checkout my blog if you want to learn how I built the datalake via AWS or for other data shenanigans.

Here's an App I built using a live version of this data.

Tables

N 2020–07–09 Till 2020–09–19

@kaggle.wjia26_epl_teams_twitter_sentiment_dataset.n_2020_07_09_till_2020_09_19

88.15 MB
799240 rows
15 columns


CREATE TABLE n_2020_07_09_till_2020_09_19 (
  "created_at" TIMESTAMP,
  "file_name" VARCHAR,
  "followers" BIGINT,
  "friends" BIGINT,
  "group_name" VARCHAR,
  "location" VARCHAR,
  "retweet_count" BIGINT,
  "screenname" VARCHAR,
  "search_query" VARCHAR,
  "text" VARCHAR,
  "twitter_id" BIGINT,
  "username" VARCHAR,
  "polarity" DOUBLE,
  "partition_0" VARCHAR,
  "partition_1" VARCHAR
);

N 2020–09–20 Till 2020–10–13

@kaggle.wjia26_epl_teams_twitter_sentiment_dataset.n_2020_09_20_till_2020_10_13

27.57 MB
211342 rows
15 columns


CREATE TABLE n_2020_09_20_till_2020_10_13 (
  "created_at" TIMESTAMP,
  "file_name" VARCHAR,
  "followers" BIGINT,
  "friends" BIGINT,
  "group_name" VARCHAR,
  "location" VARCHAR,
  "retweet_count" BIGINT,
  "screenname" VARCHAR,
  "search_query" VARCHAR,
  "text" VARCHAR,
  "twitter_id" BIGINT,
  "username" VARCHAR,
  "polarity" DOUBLE,
  "partition_0" VARCHAR,
  "partition_1" VARCHAR
);