1

I've an table in SQL Server with the following schema:

 - Partner_ID
 - Child_ID
 - Relationship_Name

Example of my data:

Partner_ID  Child_ID    Relationship_Name
A             A1            Normal
B             B1            Custom
B             B2            Custom
A1           AAA            Custom
B1           B1.1           Normal
B2            BBB           Normal

I want to draw a network visualization (like the charts that we can do using Gephi) using the table as input.

There exists any open source tool that allows me to make this implementation?

Many thanks!!!

  • Could you give more details about what you need, output formats, main features and the like? Right now I think there are many possibilities, hence it's too broad to answer. – Alejandro Feb 20 '18 at 13:58
  • @Alejandro I only want to see the relationships on a display hierarchical structure. I don't want to add any strenght to the relationship only to know if the fields are connected. – John_Rodgers Feb 20 '18 at 14:04
1

You could do this in R:

# some newer libraries for dealing with networks
library(ggraph)
library(tidygraph)
theme_set(theme_void())

#read in data
txt <- read.table(text = "
Partner_ID Child_ID Relationship_Name
A A1 Normal
B B1 Custom
B B2 Custom
A1 AAA Custom
B1 B1.1 Normal
B2 BBB Normal", 
header=TRUE, sep=" ", stringsAsFactors = FALSE)

# table (data frame) to graph object
gr <- as_tbl_graph(txt)


#plot it
ggraph(gr,layout="nicely")+
        geom_edge_link(colour="blue",alpha=0.3)+
        geom_node_point()+
        geom_node_text(aes(label=name),size=4,repel=T)

Result:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.