Inspecting the data
This challenge has three questions you must answer:
1. What is the delimiter?
Here is a CSV file opened in a text editor. What single character is used as a delimiter.
-
✓ ,
Hint
Enter the single character used in this file as the delimiter.
Solution
The correct answer is: ,
2. How many rows?
How many rows are in this CSV file: https://data.neo4j.com/importing/ratings.csv You should use Neo4j Browser pane to the right and Cypher to read all records in the file.
-
✓ 3594
Hint
Execute LOAD CSV WITH HEADERS FROM 'https://data.neo4j.com/importing/ratings.csv' AS row RETURN count(row)
Solution
The correct answer is: 3594
3. Is this file readable?
Can all the rows be read from https://data.neo4j.com/importing/test.csv? You should use Neo4j Browser pane to the right and Cypher to read all records in the file.
-
❏ yes
-
✓ no
Hint
Execute LOAD CSV WITH HEADERS FROM 'https://data.neo4j.com/importing/test.csv' AS row RETURN count(row)
Do you get an error?
Solution
Correct answer: no
Summary
In this challenge, you inspected some CSV data.
In the next lesson, you will learn about the data model you will be implementing with your import.