Each inventor has his or her own line meaning that in order to create an edgelist I need to first create an incidence matrix and then an adjacency matrix, which I'm doing in R using igraph and rgexf packages.
Here's what the incoming data looks like, you can see the multiple inventors for some inventions are given their own line for the same inventionID:
InventionId,DisclosureDate,InventorEMail,InventorCity,EndDate
81455383,3/7/2000,david.k,Beaverton, 11/1/2017
81455383,3/7/2000,ronald.s, Vancouver, 11/1/2017
81455383,3/7/2000,vladek.k,Beaverton, 11/1/2017
81455805,3/21/2000,howard.d,San Dimas, 11/1/2017
81455805,3/21/2000,paul.br,San Dimas, 11/1/2017
81456232,4/25/2000,alexey.k,San Dimas, 11/1/2017
81456285,4/27/2000,joan.v,San Dimas, 11/1/2017
81456347,5/1/2000,vladek.k,Beaverton, 11/1/2017
81456347,5/1/2000,will.al,Beaverton, 11/1/2017
I want to get to a DYNAMIC graph of co-inventor nodes wherein the edges are the inventions but I cannot figure out how to attach the DISCLOSURE DATE to the EDGE rather than to the inventor.
Here's the R script I'm using to pre-process the data. Right now it is set to attach the DisclosureDate and the EndDate to the INVENTOR (node) rather than the inventionID (Edge).
``library(igraph)
library(rgexf)
options(stringsAsFactors=FALSE) #make sure that countries shows up as characters for the nodes
dat<-read.csv(file.choose(),header=TRUE,encoding="UTF-8") #read in the raw data
incidence_matrix<-xtabs(~InventorEMail+InventionId,dat)
adjacency_matrix<-tcrossprod(incidence_matrix)
g<-graph.adjacency(adjacency_matrix,mode="undirected") #creates graph object for undirected graph
#Time to Link "City" to "Inventor"
ix<-match(V(g)$name,dat$InventorEMail)
V(g)$city<-dat$InventorCity[ix]
set.vertex.attribute(graph=g,name='city',value=dat$InventorCity[ix])
#TimeStamps
V(g)$start_date2<-dat$DisclosureDate[ix]
set.vertex.attribute(graph=g,name='start_date2',value=dat$DisclosureDate[ix])
V(g)$end_date2<-dat$EndDate[ix]
set.vertex.attribute(graph=g,name='end_date2',value=dat$EndDate[ix])
#Process for Gephi
g2<-simplify(g,remove.loops=TRUE,remove.multiple = FALSE) #Remove Loops from Dataset, keep duplicates
network.gexf<-igraph.to.gexf(g2)
f<-file("network.gexf")
writeLines(network.gexf$graph,con=f)``
Statistics:Posted by godot90 — 05 Jun 2019 16:18
]]>
Can you show a few rows of your data?
This might help too https://seinecle.github.io/gephi-tutori ... namic.html
https://github.com/gephi/gephi/wiki/Import-Dynamic-Data
Statistics:Posted by eduramiba — 28 Apr 2018 10:39
]]>
this has been a challenge for me, but I hope any of you have the answer.
I collected the pages of my site on Google Analytics with the previous page path, separated by date and hour.
My point is: how can I set the data on a csv (node and edges) to make this work on Gephi?
Thanks a lot!
Statistics:Posted by thbarone — 26 Apr 2018 21:28
]]>
]]>
So, now the issue is that I have a xml file where the format of start time is YYMMDD hh:mm:ss and the type is string. When I modify it either as datetime,date or xsd:dateTime and then open my file with gephi I receive a message saying that it ignores my attribute because it does not recognise the type of data. Any suggestions?
Statistics:Posted by nikolkotz — 18 Apr 2018 13:55
]]>
Statistics:Posted by eduramiba — 12 Apr 2018 11:14
]]>
Can we avoid to create manually the time interval needed for dynamic network plot by setting it in the xml?
Statistics:Posted by nikolkotz — 11 Apr 2018 13:05
]]>
Statistics:Posted by eduramiba — 05 Apr 2018 14:11
]]>
I would like to create a dynamic network of Facebook pages based on how many times they link to each other every year from 2010 to 2017.
I have 7 edge files one for each year with the weights and a time stamp, but I cant find how to merge them in to one dynamic network in the new 9.2 program.
Is it still an option?
Thank you,
Aya
Statistics:Posted by aya.navon — 03 Apr 2018 16:29
]]>
I am using Clement Levallois' excel importer plugin to create a coauthorship network using a database of publications (see attached Excel file for example of the data structure).
I am creating links between authors (field="Creator.Other") and am using the "Date.Season" to provide dynamic information (i.e., year each paper was published).
This successfully creates a dynamic network with an "Interval" field (see attached screenshot).
However, when trying to convert any of the static metrics to dynamic in the Data Lab, I don't get good results (no matter which metric I try). The only metric that appears to be dynamic is Degree, although I can't figure out why...
Is it possible to create dynamic attributes if I am using the excel importer plugin?
Thanks again for your help!
Statistics:Posted by schignell — 28 Mar 2018 02:05
]]>
See https://github.com/gephi/gephi/wiki/Import-Dynamic-Data
Statistics:Posted by eduramiba — 25 Mar 2018 12:02
]]>
However, this does not work with any of the other attributes (e.g., betweenness centrality), they simply remain the same size throughout the whole time period.
I have recorded a video of this behavior and attached it. First I show how betweenness centrality does not change, then I change it to degree and show it changing.
I have also tested this with the dynamic graph example and get the same behavior: only degree response to the auto apply button.
Thanks!
Statistics:Posted by schignell — 25 Mar 2018 01:49
]]>
]]>
Statistics:Posted by eduramiba — 15 Mar 2018 11:41
]]>
I need to show some temporal trends, so is my only option to compute the metrics for each year and manually record them in a spreadsheet?
Statistics:Posted by schignell — 14 Mar 2018 19:05
]]>
About export of values, I don't think it's possible at the moment.
Statistics:Posted by eduramiba — 12 Mar 2018 17:32
]]>
The results appear to be fine, but the x-axis is not labeling with the correct dates (should be years). Any thoughts?
Additionally, is there anyway to export the values behind this chart so I can work with them outside of Gephi?
Thanks!
Statistics:Posted by schignell — 12 Mar 2018 06:00
]]>
I would need to write an application that constantly import nodes and edges into the workspace. Is there any API for this purpose? Would the layout be preserved when importing additional nodes and edges to the existing workspace?
Thanks very much,
YuLing
Statistics:Posted by yuling — 09 Mar 2018 06:50
]]>
I've got a correspondence project I'm working on visualizing with Gephi. My data is plotted on the GeoLayout plugin with latitude and longitude coordinates. I am trying to visualize geographic movement over time, but I am running into difficulties with the timeline feature. My data lab has the intervals created through column merges and the custom bounds are set up within the timeline's settings, but when I press play there is no movement in the graph. The timeline itself moves, but nothing happens with my nodes and edges as I would expect.
What am I missing?
Statistics:Posted by caryso — 04 Mar 2018 08:17
]]>
]]>