I am trying to import a CSV into Neo4j in order to create a graph database of the data. This is data from an archaeological dig, where the specific artifacts found are given a unique "FS Number". When the dig is conducted, a site is divided into a grid, with each square being called a feature. Features can be subdivided into sub-features, in the case of this dig there are 4 feature levels, Feature 4 being the biggest division and Feature 1 being the smallest.
Thus, the way this data already is, you have many features within features, though the relationship between a sub feature and a primary feature should be one to many, that is a sub feature can only be in one primary feature, but a primary feature can have multiple sub features. In importing my data however, the database links several sub-features to multiple primary features.
I have played around with the importation and relationship graph that is provided by the Neo4j workspace, but this distinction about the relationship cannot be preserved it seems. I have attached the diagram that I created for the importation. Anyway I can improve this to avoid this issue? Edit 6/26/23: I should have provided a quick overview fo the CSV sorry, I have attached a photo of how it generally works. Each row is an artifact with an FS number as well as certain feature associations. Some artifacts may only have Feature 4 association, others may have a Feature 4 and Feature 3, or Feature 4, Feature 3 and Feature 2 associations. Each artifact has to have at least a Feature 4 association since that is the uppermost division of the site. There are more columns than shown in the photo, but all that matters for this graph database is the feature associations and the FS number for the artifact to construct these relations.
I took a picture of my Data Importer screen for you to check against yours. The biggest step that might be easy to miss is to use the
Map from Filebutton on the right panel to map the fields for each node because the labels in the model do not exactly match what's in the CSV (FS_Artifact vs FS#, Feature2 vs Feature 2). It also confused me on the visualization when I queried the data in Neo4j Browser that the node label was showing a different property than the FS#, so you can click on the label and choose FS# to solve that problem. I hope this helps