social network analysis and growth recommendations for datascience sg community
TRANSCRIPT
![Page 1: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/1.jpg)
![Page 2: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/2.jpg)
![Page 3: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/3.jpg)
••
••••
••
![Page 4: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/4.jpg)
••
•••
•••
![Page 5: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/5.jpg)
User-User friendship connection
![Page 6: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/6.jpg)
User-User friendship connectionSmaller nodes represent long inactive periodsColored from blue (inactive for more than 3 months)to red (active in last one month)
![Page 7: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/7.jpg)
![Page 8: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/8.jpg)
User-User friendship connection
![Page 9: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/9.jpg)
User-User like connection, with locked positions from friendship networkYellow edges- liking posts from non-friendsRed edges - liking posts from friends
![Page 10: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/10.jpg)
•
•
•
•
•
•
![Page 11: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/11.jpg)
User-User like networkColored via Markov ClusteringNodes sized by number of likes given
![Page 12: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/12.jpg)
••
••
••
•
•
![Page 13: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/13.jpg)
User-user like networkExamples of one-off likes who did not like any other posts.
![Page 14: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/14.jpg)
![Page 15: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/15.jpg)
![Page 16: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/16.jpg)
![Page 17: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/17.jpg)
User-user comment connection,using frozen positions from like network previously.Colored by Markov Clustering from the like network
![Page 18: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/18.jpg)
User-user comment network.Colored by Markov Clustering from the like network
![Page 19: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/19.jpg)
![Page 20: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/20.jpg)
![Page 21: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/21.jpg)
•
•
•
•
![Page 22: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/22.jpg)
-
-
-
-
-
![Page 23: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/23.jpg)
![Page 24: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/24.jpg)
■ Use substrings to extract full web links
■ Use Python scripts to “unmask” the redirect link
![Page 25: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/25.jpg)
■ Copy the code above to macro■ The new function called “Title” will be generated■ Drag down as usual
![Page 26: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/26.jpg)
![Page 27: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/27.jpg)
■ Remove punctuation■ Remove Numbers■ Remove stopwords such as “analyst,data,singapore” and the
website name such as ”straits time”■ Perform LDA get top 4 topics and top 7 most frequency words
in the topic
![Page 28: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/28.jpg)
•
•
•
![Page 29: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/29.jpg)
••
•
•
•
•
![Page 30: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/30.jpg)
![Page 31: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/31.jpg)
![Page 32: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/32.jpg)
•••
••
•••
![Page 33: Social network analysis and growth recommendations for DataScience SG community](https://reader030.vdocuments.us/reader030/viewer/2022032504/55c2c922bb61eb7a768b4792/html5/thumbnails/33.jpg)
••
••
••