Group04 Project Findings
GROUP4 |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
PROPOSAL | INTERIM | FINAL |
---|
Contents
Data
Data Scraping
To fulfil the objectives mentioned, we scraped data from platforms whereby SGAG have a strong presence on, namely Facebook and YouTube.
Facebook Posts
We used Facebook's Graph API to scrape 3,806 SGAG Facebook posts. A sample of the content can be seen below:
status_id | status_message | status_type | status_link | status_published | num_reactions | num_comments |
---|---|---|---|---|---|---|
378167172198277_1975245405823771 | We all know someone who takes a lot of sick leaves _Ù÷â | photo | https://www.facebook.com/sgag.sg/photos/a.378177495530578.106131.378167172198277/1975244575823854/?type=3 | 29/11/17 6:00 | 279 | 16 |
num_shares | num_likes | num_loves | num_wows | num_hahas | num_sads | num_angrys |
---|---|---|---|---|---|---|
73 | 197 | 0 | 1 | 80 | 1 | 0 |
In addition, we would be creating a new feature, the number of positive reactions. This is defined as the sum of total number of ‘likes’, number of ‘loves’, number of ‘wows’ and number of ‘hahas’.
Facebook Comments
Next, we scraped 21,940 SGAG Facebook comments and a sample of the content can be seen below:
comment_id | status_id | parent_id | comment_message | comment_author | comment_published | comment_likes |
---|---|---|---|---|---|---|
1975245405823771_1980256198656025 | 378167172198277_1975245405823771 | "Boss, I just got into an accident and broke my arm, fractured a rib, and I might have internal bleeding"
Boss: "Ok la. So what time you coming into the office later?" |
Leorenzo Joseph | 29/11/17 6:06 | 5 |
YouTube
Using an online web scraper, we scraped the first 10,000 comments for Night Owl Cinematic and TheSmartLocal's YouTube videos. In addition, we also scarped the first 1,000 comments for SGAG YouTube videos. A sample of the content can be seen below:
id | user | date | commentText | likes | hasReplies | numberOfReplies |
---|---|---|---|---|---|---|
UgzkUyiEd5tMlCq4Nwh4AaABAg | Frentzen | 29 minutes ago | Single better | 0 | FALSE | 0 |
Inserting headers
- Header 2: ===header 2===
- Header 3: ====header 3====
- Header 4: =====header 4=====
Inserting images and captions
- Image, center alignment: [[Image:SGAG Logo 2.png|140px|center]]
- Image, left alignment: [[Image:SGAG Logo 2.png|140px]]
- Image, left alignment, text wrap: [[Image:SGAG Logo 2.png|140px|left]]
- Image caption: Insert <center>Figure X: Image title</center> below image
Inserting footnotes
Text styles
- Bold: <b>text</b>
- Italic: <i>text</i>
- Underline: <u>text</u>
Data Cleaning
In progress
Understanding Data
In progress.
Methodologies
In progress.
Proposed Deliverables
In progress.