Data Preparation for Social Network Analysis — Transcript
Full transcript
- 0:00hello everyone welcome to this tutorial
- 0:03on
- 0:04how to perform a social network analysis
- 0:06on gaffy
- 0:08the format of this tutorial allow you to
- 0:11um
- 0:11pause and go back and follow along with
- 0:15um
- 0:16the tutorial while doing it on your own
- 0:17so please feel free to do that
- 0:20so this is part one we're going to start
- 0:22with preparing
- 0:24the data to be imported
- 0:28into tikkefi
- 0:31so first um you can open up this
- 0:35uh data example in the folder
- 0:38provide this is provided for you so you
- 0:40can follow along
- 0:42and do it yourself so this is how a raw
- 0:45data would usually look
- 0:47in column a you would have the people
- 0:50you surveyed or interviewed
- 0:53and you will have in column b
- 0:56the people that they are connected to or
- 0:58they have provided you with
- 1:02so first what you're going to do is
- 1:03you're going to create a new sheet
- 1:05you can name it nodes
- 1:09here you're going to create two
- 1:12columns an id column and a label column
- 1:17this the note sheets is where you list
- 1:20all of
- 1:21the people in your in your network
- 1:25um so first what we're going to do is
- 1:27we're going we're going to go back to
- 1:28data we're going to copy all of
- 1:30the names and put it in
- 1:33in one column so and in label
- 1:37and then on column b
- 1:41the same thing so obviously there's
- 1:45going to be
- 1:46duplicates so what you want to do is
- 1:48highlight
- 1:50all the names that you have
- 1:53go to the tab the data tab
- 1:57and go to remove duplicates
- 2:00you will have this warning come up
- 2:03whether you want to expand the section
- 2:04or continue you continue with the
- 2:06selected section remove duplicate
- 2:09in column b and then okay
- 2:12and it says that we've removed 29
- 2:15duplicates and there are
- 2:1715 remaining so now we know that we have
- 2:2015 people within our
- 2:24network and then you give them ids so
- 2:27this is just
- 2:28a regular id from
- 2:31a number so you can drag it down make it
- 2:34one to 15.
- 2:36so that's it that's um that's all you
- 2:37need for a note notes
- 2:39uh sheet and now you go on into making
- 2:42an
- 2:43edge sheet an edge sheet
- 2:46is um pretty much um what you have
- 2:50here in the data in the raw data
- 2:54but um giving it the id instead of a
- 2:58name
- 3:00so here you need um four columns you
- 3:03need source
- 3:05target type and
- 3:08weight so now we're going to fill up the
- 3:10add sheets
- 3:12pretty much what you're doing is you're
- 3:14taking the names in the raw data
- 3:16and putting it in the source and target
- 3:18column using
- 3:19the id from the note sheet that we've
- 3:22created
- 3:24so first what we're going to do is we're
- 3:26going to copy the id
- 3:27[Music]
- 3:28number and moving and uh pasting it on
- 3:32the right side of the labels
- 3:34uh this is because we're doing this
- 3:36because of
- 3:37um the function that we're about to use
- 3:42so the function the function is called
- 3:44vlookup
- 3:45what we're doing here is looking up the
- 3:48the names and then matching it with
- 3:51the id numbers so the lookup value the
- 3:54first lookup value
- 3:55is current in a1 here
- 4:00and then for a table array we
- 4:03are using the note the note sheet
- 4:07and so we're gonna copy this
- 4:10right here the whole table
- 4:14and then i like to keep
- 4:17um this table locked so it doesn't move
- 4:20when we drag
- 4:23the column index number is going to be 2
- 4:25for the second
- 4:27column that in the table we just picked
- 4:30this can be two
- 4:31and then for range lookup we're looking
- 4:33whether we want an approximate match
- 4:36or an exact match and we want an exact
- 4:38match that will be false
- 4:40close the bracket and there you have
- 4:43um for current it's one and now we can
- 4:47just drag your
- 4:54cursor down and get all of this
- 5:00and there we go there's 23
- 5:04yep there's 22 um
- 5:08sores that we got and then we're doing
- 5:09the same thing
- 5:14for the target and we can drag it this
- 5:16way because now we're looking at
- 5:18b1 on this sheet instead of
- 5:22so we're looking at this benedict now
- 5:25and then we can drag it down
- 5:26just like before
- 5:31so it's whether we want to have a
- 5:34directed or undirected
- 5:36uh graph for the social network analysis
- 5:39for um the basic tutorial purpose we're
- 5:42gonna keep this as
- 5:44undirected
- 5:47so if you do that and just drag it down
- 5:48for the whole thing so for the weight
- 5:53um you're able to give the certain
- 5:58relationship um more value than the
- 6:01others
- 6:02for the basic purpose of this method
- 6:04this tutorial
- 6:05we're going to keep it as one however if
- 6:08if you have um different numbers here
- 6:12it will be shown on your
- 6:15social network analysis in gefi
- 6:19so yeah that's it um we have an edge
- 6:22sheet and a note sheet another thing you
- 6:23can do
- 6:24um in your note sheet which could be
- 6:27useful for your analysis is if you have
- 6:29an information for all of your
- 6:32um your individuals
- 6:36and you want to show them um
- 6:39disaggregate them on your social network
- 6:42analysis
- 6:43you can add them in to your note sheet
- 6:45and it can be transferred into gefi
- 6:47so for example maybe we want gender
- 6:50so here i have um gender listed out
- 6:55so this like for example
- 6:59in your social network analysis you'll
- 7:01be you will be able to
- 7:04see the difference in color between male
- 7:07and female
- 7:08and it could be useful for your project
- 7:12and this can you can have as many
- 7:14columns as you want for
- 7:16this perhaps you want a school
- 7:19where they go to school or
- 7:22what country they're from etc
- 7:27so yeah this is it
- 7:33so to export these information
- 7:37into caffei you will need to export the
- 7:40note sheets and the add sheets
- 7:43into a csv form
- 7:47individually so let's start with i'm
- 7:49going to show you how to do that let's
- 7:50start with the note sheet first you go
- 7:51to
- 7:52you stay on nodes you go to files
- 7:55and then export you're going to change
- 7:58file type into
- 8:00a csv file
- 8:03and then save as
- 8:08and then you can say node i'm going to
- 8:12put it as
- 8:13example nodes
- 8:18save um then just
- 8:22press ok that one doesn't matter
- 8:26and you can go to your add sheet and do
- 8:28the same thing
- 8:30export change file type csv
- 8:34save as and i will name this as
- 8:38example and just unsafe
- 8:43okay
- 8:46and that's it we're gonna next i'm gonna
- 8:49show you how to
- 8:50import these newly made
- 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.