Baselight

US Election 2020:Tweet With Sentiment & Party Name

Exploring Sentiments and Party Affiliations in the November 2020 Discourse

@kaggle.jaidalmotra_usa_2020_elections_tweets

Uselection Tweets 1jul 11nov
@kaggle.jaidalmotra_usa_2020_elections_tweets.uselection_tweets_1jul_11nov

  • 734.66 MB
  • 24201654 rows
  • 13 columns
created_at

Created-At

from_user_id

From-User-Id

to_user_id

To-User-Id

language

Language

retweet_count

Retweet-Count

partyname

PartyName

id

Id

score

Score

scoring_string

Scoring String

negativity

Negativity

positivity

Positivity

uncovered_tokens

Uncovered Tokens

total_tokens

Total Tokens

7/1/20 7:44 PM1223446325758394369387882597enBothParty12783689739486945280.1025641025641026yep (0.31) torturing (-0.77) care (0.56)0.76923076923076930.87179487179487192124
7/1/20 7:44 PM1001407960252342273-1en178Republicans1278368973923528704-0.5897435897435898ugly (-0.59)0.58974358974358982223
7/1/20 7:44 PM1178522693840392195-1en2Democrats12783689739109376000.6923076923076923okay (0.23) lol (0.46)0.69230769230769231719
7/1/20 7:44 PM6426748265497475enRepublicans1278368973893951489-1.4615384615384617damage (-0.56) incompetent (-0.54) resign (-0.36)1.46153846153846173033
7/1/20 7:44 PM1068507190103699456-1en28Republicans12783689738815119360.0256410256410256clean (0.44) threat (-0.62) admit (0.21)0.61538461538461540.64102564102564112831
7/1/20 7:44 PM376033756-1en61527Neither12783689738354565150.0769230769230769stop (-0.31) won (0.69) stop (-0.31)0.61538461538461540.69230769230769243134
7/1/20 7:44 PM306418365-1en178Republicans1278368973822799874-0.5897435897435898ugly (-0.59)0.58974358974358982223
7/1/20 7:44 PM121531787903971328725073877undRepublicans1278368973814411266nan88
7/1/20 7:44 PM1075573514-1en18011Republicans1278368973688418304-0.1794871794871795no (-0.31) defense (0.13)0.30769230769230770.12820512820512822527
7/1/20 7:44 PM1212847642264211456316917406undRepublicans1278368973646594048nan1818

CREATE TABLE uselection_tweets_1jul_11nov (
  "created_at" VARCHAR,
  "from_user_id" BIGINT,
  "to_user_id" BIGINT,
  "language" VARCHAR,
  "retweet_count" DOUBLE,
  "partyname" VARCHAR,
  "id" BIGINT,
  "score" DOUBLE,
  "scoring_string" VARCHAR,
  "negativity" DOUBLE,
  "positivity" DOUBLE,
  "uncovered_tokens" BIGINT,
  "total_tokens" BIGINT
);

Share link

Anyone who has the link will be able to view this.