There are several possible ways to structure relational data, for example in a matrix, but the method of creating two columns of “sources” and “targets” might be the most intuitive, especially for historical research.
Before we structure our data in this way, we have to ask ourselves what exactly it is that we are connecting. Let’s look at the first two columns (A and B): Obviously, there is a link between a person and the “award edition.”
OpenEdition suggests that you cite this post as follows:
Rudolph Henrike (November 15, 2018). Academy Award Sample Dataset – Part 2: Creating a Spreadsheet that Represents a Network. Political and Academic Networks in the PRC. Retrieved July 27, 2026 from https://panprc.hypotheses.org/468