YouTube2Text

Data Preparation for Social Network Analysis — Transcript

by WinrockIntl · 1,126 words · 195 segments · language en · Watch on YouTube

Full transcript

  1. 0:00hello everyone welcome to this tutorial
  2. 0:03on
  3. 0:04how to perform a social network analysis
  4. 0:06on gaffy
  5. 0:08the format of this tutorial allow you to
  6. 0:11um
  7. 0:11pause and go back and follow along with
  8. 0:15um
  9. 0:16the tutorial while doing it on your own
  10. 0:17so please feel free to do that
  11. 0:20so this is part one we're going to start
  12. 0:22with preparing
  13. 0:24the data to be imported
  14. 0:28into tikkefi
  15. 0:31so first um you can open up this
  16. 0:35uh data example in the folder
  17. 0:38provide this is provided for you so you
  18. 0:40can follow along
  19. 0:42and do it yourself so this is how a raw
  20. 0:45data would usually look
  21. 0:47in column a you would have the people
  22. 0:50you surveyed or interviewed
  23. 0:53and you will have in column b
  24. 0:56the people that they are connected to or
  25. 0:58they have provided you with
  26. 1:02so first what you're going to do is
  27. 1:03you're going to create a new sheet
  28. 1:05you can name it nodes
  29. 1:09here you're going to create two
  30. 1:12columns an id column and a label column
  31. 1:17this the note sheets is where you list
  32. 1:20all of
  33. 1:21the people in your in your network
  34. 1:25um so first what we're going to do is
  35. 1:27we're going we're going to go back to
  36. 1:28data we're going to copy all of
  37. 1:30the names and put it in
  38. 1:33in one column so and in label
  39. 1:37and then on column b
  40. 1:41the same thing so obviously there's
  41. 1:45going to be
  42. 1:46duplicates so what you want to do is
  43. 1:48highlight
  44. 1:50all the names that you have
  45. 1:53go to the tab the data tab
  46. 1:57and go to remove duplicates
  47. 2:00you will have this warning come up
  48. 2:03whether you want to expand the section
  49. 2:04or continue you continue with the
  50. 2:06selected section remove duplicate
  51. 2:09in column b and then okay
  52. 2:12and it says that we've removed 29
  53. 2:15duplicates and there are
  54. 2:1715 remaining so now we know that we have
  55. 2:2015 people within our
  56. 2:24network and then you give them ids so
  57. 2:27this is just
  58. 2:28a regular id from
  59. 2:31a number so you can drag it down make it
  60. 2:34one to 15.
  61. 2:36so that's it that's um that's all you
  62. 2:37need for a note notes
  63. 2:39uh sheet and now you go on into making
  64. 2:42an
  65. 2:43edge sheet an edge sheet
  66. 2:46is um pretty much um what you have
  67. 2:50here in the data in the raw data
  68. 2:54but um giving it the id instead of a
  69. 2:58name
  70. 3:00so here you need um four columns you
  71. 3:03need source
  72. 3:05target type and
  73. 3:08weight so now we're going to fill up the
  74. 3:10add sheets
  75. 3:12pretty much what you're doing is you're
  76. 3:14taking the names in the raw data
  77. 3:16and putting it in the source and target
  78. 3:18column using
  79. 3:19the id from the note sheet that we've
  80. 3:22created
  81. 3:24so first what we're going to do is we're
  82. 3:26going to copy the id
  83. 3:27[Music]
  84. 3:28number and moving and uh pasting it on
  85. 3:32the right side of the labels
  86. 3:34uh this is because we're doing this
  87. 3:36because of
  88. 3:37um the function that we're about to use
  89. 3:42so the function the function is called
  90. 3:44vlookup
  91. 3:45what we're doing here is looking up the
  92. 3:48the names and then matching it with
  93. 3:51the id numbers so the lookup value the
  94. 3:54first lookup value
  95. 3:55is current in a1 here
  96. 4:00and then for a table array we
  97. 4:03are using the note the note sheet
  98. 4:07and so we're gonna copy this
  99. 4:10right here the whole table
  100. 4:14and then i like to keep
  101. 4:17um this table locked so it doesn't move
  102. 4:20when we drag
  103. 4:23the column index number is going to be 2
  104. 4:25for the second
  105. 4:27column that in the table we just picked
  106. 4:30this can be two
  107. 4:31and then for range lookup we're looking
  108. 4:33whether we want an approximate match
  109. 4:36or an exact match and we want an exact
  110. 4:38match that will be false
  111. 4:40close the bracket and there you have
  112. 4:43um for current it's one and now we can
  113. 4:47just drag your
  114. 4:54cursor down and get all of this
  115. 5:00and there we go there's 23
  116. 5:04yep there's 22 um
  117. 5:08sores that we got and then we're doing
  118. 5:09the same thing
  119. 5:14for the target and we can drag it this
  120. 5:16way because now we're looking at
  121. 5:18b1 on this sheet instead of
  122. 5:22so we're looking at this benedict now
  123. 5:25and then we can drag it down
  124. 5:26just like before
  125. 5:31so it's whether we want to have a
  126. 5:34directed or undirected
  127. 5:36uh graph for the social network analysis
  128. 5:39for um the basic tutorial purpose we're
  129. 5:42gonna keep this as
  130. 5:44undirected
  131. 5:47so if you do that and just drag it down
  132. 5:48for the whole thing so for the weight
  133. 5:53um you're able to give the certain
  134. 5:58relationship um more value than the
  135. 6:01others
  136. 6:02for the basic purpose of this method
  137. 6:04this tutorial
  138. 6:05we're going to keep it as one however if
  139. 6:08if you have um different numbers here
  140. 6:12it will be shown on your
  141. 6:15social network analysis in gefi
  142. 6:19so yeah that's it um we have an edge
  143. 6:22sheet and a note sheet another thing you
  144. 6:23can do
  145. 6:24um in your note sheet which could be
  146. 6:27useful for your analysis is if you have
  147. 6:29an information for all of your
  148. 6:32um your individuals
  149. 6:36and you want to show them um
  150. 6:39disaggregate them on your social network
  151. 6:42analysis
  152. 6:43you can add them in to your note sheet
  153. 6:45and it can be transferred into gefi
  154. 6:47so for example maybe we want gender
  155. 6:50so here i have um gender listed out
  156. 6:55so this like for example
  157. 6:59in your social network analysis you'll
  158. 7:01be you will be able to
  159. 7:04see the difference in color between male
  160. 7:07and female
  161. 7:08and it could be useful for your project
  162. 7:12and this can you can have as many
  163. 7:14columns as you want for
  164. 7:16this perhaps you want a school
  165. 7:19where they go to school or
  166. 7:22what country they're from etc
  167. 7:27so yeah this is it
  168. 7:33so to export these information
  169. 7:37into caffei you will need to export the
  170. 7:40note sheets and the add sheets
  171. 7:43into a csv form
  172. 7:47individually so let's start with i'm
  173. 7:49going to show you how to do that let's
  174. 7:50start with the note sheet first you go
  175. 7:51to
  176. 7:52you stay on nodes you go to files
  177. 7:55and then export you're going to change
  178. 7:58file type into
  179. 8:00a csv file
  180. 8:03and then save as
  181. 8:08and then you can say node i'm going to
  182. 8:12put it as
  183. 8:13example nodes
  184. 8:18save um then just
  185. 8:22press ok that one doesn't matter
  186. 8:26and you can go to your add sheet and do
  187. 8:28the same thing
  188. 8:30export change file type csv
  189. 8:34save as and i will name this as
  190. 8:38example and just unsafe
  191. 8:43okay
  192. 8:46and that's it we're gonna next i'm gonna
  193. 8:49show you how to
  194. 8:50import these newly made
  195. 8:54csv files into gephi

About this transcript

This page contains the full transcript of Data Preparation for Social Network Analysis by WinrockIntl, generated from the public captions YouTube serves with the video. The transcript has 1,126 words across 195 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.

What you can do with it

Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.

Free YouTube transcript tool

YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.