Import Yelp dataset

(Harvey Nguyen) #1

Hi everybody,

I am reading "A comprehensive Guide to Graph Algorithms in Neo4j" ebook. According to this book, I have downloaded YELP data to experiment some algorithms. However, I cannot import the data into my Neo4j server.
I have followed guides from github (in the book) but errors have happened. Anybody here can help me or you have an yelp-graph-database so that you can upload somewhere?

Thanks for you help,
Harvey Nguyen

(William Lyon) #2

Can you share the error messages?

There is also a Cypher based import script for the same data here: https://neo4j.com/docs/graph-algorithms/current/yelp-example/#yelp-import

(DKumar) #3

please, share the error message.

(Harvey Nguyen) #4

Thanks for you reply,
There are different errors, one of them is that

Traceback (most recent call last):
  File "json_to_csv.py", line 51, in <module>
    with open("dataset/businessLocations.json") as business_locations_json, \
FileNotFoundError: [Errno 2] No such file or directory: 'dataset/businessLocations.json'

After extracting the database file, there is no file such as "businessLocations.json". I think this python code is not update. Also on the Yelp website, there is no file like that.

I will try with your suggestion.
Thanks a lot.

(Mark Needham) #5

Hey,

That file is generated by running this command:

python lat_long_expansion.py

Or did you try that already and it didn't work?

(Harvey Nguyen) #6

@mark.needham really?
I have followed the instructions on github

image
image.png985×757 24 KB

After extracting, I run

python json_to_csv.py

So, we need to change the order ?

(Mark Needham) #7

Yeh I must have those instructions in the wrong order