Join William Lyon for an in-depth discussion in this video Model data for joining datasets, part of Database Clinic: Neo4J.
- I've downloaded three files from data.gov.uk.…Two of these are csv files…which we can import directly into Neo4j…using the load csv functionality built into Cypher.…One of these files, however, was an Excel spreadsheet.…Now we can't read excel files directly into Neo4j…so I used Excel to convert the Vehicle Type Lookup sheet…into a csv file…and saved it here as Vehicle_Type_Lookup.csv.…
I'm going to start neo4j next.…And I need to choose a new directory…for our new Neo4j database.…So I'll create a new folder.…Let's call this "join_datasets".…And we'll go ahead and click "Start"…to start Neo4j.…Now as a security measure…by default Neo4j is only able to read files for import…located in a directory called Import…within this database directory that we just created.…
So let's copy these csv files.…Switch over to User Documents.…Neo4j…join_datasets…The database directory that we just created.…Now I'm going to create a new folder…and name this Import…and paste the csv files…into this directory.…We'll now be able to reference these files…
Author
William Lyon
Released
9/19/2017- Strengths and weaknesses of Neo4j
- Data modeling
- Creating a database
- Joining data sets
- Modeling data for joining data sets
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 17s
-
The Database Clinic series1m 22s
-
-
1. Neo4j in Five Minutes
-
A brief overview of Neo4j3m 23s
-
-
2. Create a Database
-
Data modeling3m 52s
-
Creating a database3m 56s
-
Import data10m 27s
-
Query data3m 12s
-
3. Join Two Datasets
-
Join datasets2m 50s
-
Import data6m 26s
-
-
4. Search a Database
-
Database search1m 51s
-
Query the database5m 22s
-
Finalize the database query3m 34s
-
-
5. Create, Read, Update, and Delete Operations
-
CRUD operations2m 31s
-
Create operations in Neo4j8m 36s
-
Update operations in Neo4j8m 11s
-
Delete operations in Neo4j3m 44s
-
Read operations in Neo4j3m 43s
-
-
6. Averages and Calculations
-
Calculations1m 59s
-
Update the data model3m 36s
-
Refactor the data model10m 22s
-
Import data for calculations5m 52s
-
Perform calculations7m 55s
-
-
Conclusion
-
Next steps1m 44s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Model data for joining datasets