1、1What is Social Network Analysis?2https:/ process of investigating social structures by using networks and graphs.Applications of SNA for Pandemics3https:/ and Cleaning Data2.ChatGPT3.Uploading to Gephi4.Additional Applications Creating Social Network Graphs Using GEPHI51.Acquiring and Cleaning Data
2、2.ChatGPT3.Uploading to Gephi4.Additional Applications Creating Social Network Graphs Using GEPHIWhy Do I Even Bother With This Team?6Collect the Following List7Load the Entire Following List8Copy the List9Use the Mouse or Control+Shift+Down Arrow to Select AllCopy and Drag Down At The Same Time10Us
3、ing the mouse will load more.Control+Shift+Down Arrow will not load more.OSINT Tip11You can search the entire list without having loaded the entire list.Paste Into Excel and Start Cleaning Data12To Delete Pictures:A)Select Column AB)Press F5 and Select SpecialABDeleting Objects in Excel13CDETo Delet
4、e Pictures:A)Select Column AB)Press F5 and Select SpecialC)Select ObjectsD)Delete ObjectsE)ResultDeleting Hyperlinks in Excel14To Delete Hyperlinks:F)Select Column AG)Control F,Replace Tab,OptionsFGDeleting Hyperlinks in Excel15To Delete Hyperlinks:F)Select Column AG)Control F,Replace Tab,OptionsH)F
5、ormatI)Choose Format From CellHIDeleting Hyperlinks in Excel16To Delete Hyperlinks:F)Select Column AG)Control F,Replace Tab,OptionsH)FormatI)Choose Format From CellJ)Replace AllK)ResultJKDelete the Word Follow17To Delete Words:L)Select Column,Control F,Replace Tab(you may need to reset the formattin
6、g),Replace All:follow with nothingM)ResultLMDeleting Blank Cells18NOTo Delete Blank Cells:N)Select Column,F5,SpecialO)BlanksDeleting Blank Cells19To Delete Blank Cells:P)Only blank cells are selectedQ)Right click,deleteR)Shift cells upPQRCleaned Following List!20Removed:1)Objects2)Hyperlinks3)Unwant