Neo4j Cypher Example of JSON file line: {"business_id":"Pns2l4eNsfO8kk83dixA6A","name":"Abby Rappoport, LAC, CMQ","addre
Posted: Tue Jul 12, 2022 8:21 am
Neo4j Cypher
Example of JSON file line:
{"business_id":"Pns2l4eNsfO8kk83dixA6A","name":"Abby Rappoport,LAC, CMQ","address":"1616 Chapala St, Ste 2","city":"SantaBarbara","state":"CA","postal_code":"93101","latitude":34.4266787,"longitude":-119.7111968,"stars":5.0,"review_count":7,"is_open":0,"attributes":{"ByAppointmentOnly":"True"},"categories":"Doctors,Traditional Chinese Medicine, Naturopathic\/Holistic, Acupuncture,Health & Medical, Nutritionists","hours":null}
Write a cypher query for each city, that prints the city nameand the number of businesses in the city in descending order ofnumber of businesses.
Write a cypher query of the first ten cities with the number ofbusinesses for each city.
Confused on how to utilize a count function for JSON file input,any guidance or help appreciated.
Example of JSON file line:
{"business_id":"Pns2l4eNsfO8kk83dixA6A","name":"Abby Rappoport,LAC, CMQ","address":"1616 Chapala St, Ste 2","city":"SantaBarbara","state":"CA","postal_code":"93101","latitude":34.4266787,"longitude":-119.7111968,"stars":5.0,"review_count":7,"is_open":0,"attributes":{"ByAppointmentOnly":"True"},"categories":"Doctors,Traditional Chinese Medicine, Naturopathic\/Holistic, Acupuncture,Health & Medical, Nutritionists","hours":null}
Write a cypher query for each city, that prints the city nameand the number of businesses in the city in descending order ofnumber of businesses.
Write a cypher query of the first ten cities with the number ofbusinesses for each city.
Confused on how to utilize a count function for JSON file input,any guidance or help appreciated.