Hello folks. I have a matrix I created in Excel that shows 17 nodes, each node's connection to every other node (if any), and that connections strength. Note the error in the image, cells that represent a node's connection to itself should be null not 0.
0 no connection 1 min connection 2 median connection 3 primary connection
I want to translate this matrix into a database I can use for network visualization but I need help with the structure.
I'd like to avoid having a record for each connection as that's 278 records for my limited dataset alone (final dataset will have 200+ nodes). Would like to have a record for each node that contains every connection and it's connection strength.
Ideal database would look like (columns) Id Name Connections Strengths (where i2,3,4 = connections i2,3,4)
I've done this type of thing before with data trees and XML but looking for a more robust option I can query for online interactive graphics and games.
In terms of translating the Excel file to the database itself I was planning on writing a string parser to convert CSV to SQL but interested to hear if there are other ideas out there.