Brand new here and did a class a week ago in SF. Though it was really light on data import. I have watched Nicole's video several times and attempting to pull in a small amount of data (~2500 rows). I have attached a smaller file with the data to play along.
Data File has 5 columns
Alta is the id of the patent that belongs to company
Citation is the id of a patent that has a relationship to the Alta patent
Note both "Alta" and "Citation" are the same type of nodes - patents
CiteType defines the direction of the relationship with two values
prior means the "Citation" patent is the source of the relationship and Alta is target
forward means Alta is source and citation is the target
Category determines a property of the relationship (applicant or examiner)
Organization is the company that owns the "citation" patent
What I was thinking of as a model:
Nodes are Patents and include both the "Alta" column and "Citation" column and they are unique.
Organizations are nodes and Unique
There are two relationships:
- Assigns the patent to the organization
- Cites which describe patent to patent relationships with a direction and property (by who).
The data is a bit more complex for a first try, but this is what I am interested on working on.
What I think I need to do is:
I figured out I have to put the file in a specific directory. A bit confusing relative to the video.
Create constraints on Organizations with Name as property
Create constraint on node that contains Patents which has patent number as ID. How do I do this with the two columns?
How do I handle the direction of a relationship (Cite) based on a column CiteType?
Any and all help will be most appreciated.
IP Test.txt (891 Bytes)