Book Image

Learning Neo4j 3.x - Second Edition

By : Jerome Baton
Book Image

Learning Neo4j 3.x - Second Edition

By: Jerome Baton

Overview of this book

Neo4j is a graph database that allows traversing huge amounts of data with ease. This book aims at quickly getting you started with the popular graph database Neo4j. Starting with a brief introduction to graph theory, this book will show you the advantages of using graph databases along with data modeling techniques for graph databases. You'll gain practical hands-on experience with commonly used and lesser known features for updating graph store with Neo4j's Cypher query language. Furthermore, you'll also learn to create awesome procedures using APOC and extend Neo4j's functionality, enabling integration, algorithmic analysis, and other advanced spatial operation capabilities on data. Through the course of the book you will come across implementation examples on the latest updates in Neo4j, such as in-graph indexes, scaling, performance improvements, visualization, data refactoring techniques, security enhancements, and much more. By the end of the book, you'll have gained the skills to design and implement modern spatial applications, from graphing data to unraveling business capabilities with the help of real-world use cases.
Table of Contents (24 chapters)
Title Page
Credits
About the Authors
Acknowledgement
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

LOAD CSV


LOAD CSV is a built-in Cypher instruction that can be used with the filename of a CSV file, and Cypher instructions to play for each line of the CSV file.

Note

CSV stands for comma-separated value. Normally, each column of the file is separated by a comma, which was not a good idea. It is far more common to see the semicolon character used as a separator, which is a better choice, but my personal choice is to use the Unix pipe character | as a separator. The first line may be a list of headers. CSV is text; you do not need a spreadsheet to open CSV files.

Here is a simple example taken from the Neo4j website. It will load data from a URL and, for each line of this source, will run the CREATE command. I have highlighted the points that I'll discuss in this chapter:

LOADCSVWITHHEADERSFROM'https://neo4j.com/docs/cypher-refcard/3.2/csv/artists-with-headers.csv'ASlineCREATE(:Artist{name:line.Name,year:toInt(line.Year)})

LOAD CSV WITH HEADERS means that the first line of the CSV input will...