I would like to convert a relational database encoded in a excel file to a directed graph that shows the entities, some of the attributes and the directed relations.
The excel file is organized is follows. Column A and B contain entity names. Column A may contain duplicated names. Column B may contain Null entries. The relation direction goes from A to B. An exmplary file can be found here: https://www.dropbox.com/s/gpcqzyls3mqulhz/database.xlsx?dl=0. The outcome of this particular file should be something like this.
Would you know an elegant way to solve this for a big excel file? For now, I copy the entity and attribute names by hand, enter the edges by hand etc. The xlsx.-import did not seem to do the trick.
Greetings from Frankfurt,