I would like a quick and easy way to make variables in the edge sheet based on attributes of both sender and recipient attributes that are strored in the node sheet.
I realize that Vlookup has some capability for this type of thing in general, but I have not had any success in using it for this purpose.
For instance, I have a dataset that measures when people in a community adopted a new technology, and records of the structure of their interaction. I want to visualize the flow of influence in the network, and thus I will color nodes based on whether
they have not yet adopted, are adopting, or adopted in the past. I also want to see when 'infected people' talk to those who are just then adopting (possibly a source of influence on their adoption decision). I want to color edges that come from nodes
that areinfected differently than edges that come from un-infected nodes. I also want to color edges differently when they are coming from infected nodes and leading to newly infected nodes.
Thus I need to make variables in the edgesheet that depend on data from the nodesheet for both sender and recipient. This could be done in two steps. It is totally fine to return variables from sender in one cell and recipient in the next and simply define
a third variable as their combination.
For instance, in this case my node sheet, in addition to other variables has variables that indicate whether a node has adopted an innovation in that time period (coded as a 2) adopted in the past (coded as 1) or has not yet adopted the innovation (coded
as a 0).
Node Name T1Adopt T2Adopt T3 Adopt
Bob 1 1 1
Fred 0 2 1
Mary 0 0 2
Susan 2 1 1
Sender Recipient T1Edge T2Edge T3 Edge Tetc.
Bob Fred 0 1 1
Bob Susan 1 0 0
On my edgesheet I want to make variables that indicate when, for instance, a newly infected node has a tie with a node that was infected in the past.
Sender Recipient T1Edge T2Edge T3 Edge Tetc. T1Infect T2 Infect T3Infect
Bob Fred 0 1 1 1 2 1
Bob Susan 1 0 0 2 0 0
this is more complex than Vlookup expects, partly because I need excel to check the sender or the recipient column in the edgesheet and then check for that name in column 1 of the nodesheet. My understanding is that vlookup wants to find the id variable
in column 1.