#SSR Tweets Dataset
#SSR_TWEET_DATASET ON TWITTER
@kaggle.suyashpratapsingh_ssr_tweets_dataset
#SSR_TWEET_DATASET ON TWITTER
@kaggle.suyashpratapsingh_ssr_tweets_dataset
Dataset on #SSR can be used to practice basic data analysis and also to extract the exact tweets and perform sentimental analysis.
It consists of 13 columns :
1.'id': Id of the tweet posted
2.'created_at': Date and Time of the tweet posted
3.'retweet_count': Count of how many times the same tweet is re-tweeted.
4.'source': From which platform the tweet was posted
5.'user_id': Id of the user posting the tweet
6.'user_name': Name of the user posting the tweet
7.'user_description': Description of the user posting the tweet
8.'user follower count': Count of how many followers does the user have
9.'user-friends count':': Count of how many friends does the user have
10.'user_location': Location from where the user posted the tweet
11.'user_verified': Is the user verified by Twitter or not
12.'user_url': URL of the user's profile
13.'length of tweet': The total length of the tweet posted by the user ( words ).
CREATE TABLE ssr_tweet_dataset (
"id" DOUBLE,
"text" VARCHAR,
"users_id" DOUBLE,
"user_screen_name" VARCHAR,
"user_name" BIGINT,
"created_at" VARCHAR,
"n__retweet_count" BIGINT -- Retweet Count,
"source" VARCHAR,
"user_id" DOUBLE,
"user_description" VARCHAR,
"user_follower_count" BIGINT,
"user_friends_count" BIGINT,
"user_location" VARCHAR,
"user_verified" BOOLEAN,
"user_url" VARCHAR,
"lenght_of_tweet" BIGINT
);Anyone who has the link will be able to view this.