Create a Table At DB to Store Twitter Data

melisMirza / Covitter

Repository of SWE 573 project

0 stars 0 forks source link

Create a Table At DB to Store Twitter Data #21

Closed melisMirza closed 3 years ago

melisMirza commented 3 years ago

The table should contain the following fields:

Original and cleaned post content.
Favorite / retweet counts
Sentiment Analysis result
post date
emoji content
mentions in the post
entities in the post
owner of the post
whether post is a retweet or not

melisMirza commented 3 years ago

Postgresql DB Created Schema name: STREAMED_DATA Table name: Twitter Columns: id, post_id, post_content, post_date, user_name, hashtags, mentions_screen_name, emojis, post_cleaned, post_lemmatized, sentiment_result, sentiment_score, is_retweet, retweet_count, favourite_count, entities