Questions
- US states:
- Find the first-degree neighbors of Colorado (code CO):
- What are the codes of these neighbors?
- Can you count how many there are using an aggregate function?
- Which states have the highest number of neighbors? The lowest? Think about the ORDER BY clause.
- GitHub graph enhancement:
- From neo4j_repos_github.json, can you save the project language when provided, as a new node? You can use the new Language node label.
- Can you also save the license, when provided, using a new node? Use a Licence node label and save all of the provided information from GitHub as properties.
(Hint: the license is provided with the following format):
"license": {
"key": "other",
"name": "Other",
"spdx_id": "NOASSERTION",
"url": null,
"node_id": "MDc6TGljZW5zZTA="
},
-
- Using the GitHub API, can you save the user locations?
Hint: the URL to get user information is https://api.github.com/users/<login>.
- The location often contains the city and country name, separated by either a space or a comma. Can you write a query to save only the first element of this pair, assumed to be the city?
Hint: checkout APOC text utils.
- Using the GitHub API, can you retrieve the repositories owned by each Neo4j contributor?
Hint: the URL to get the repositories for a given user is https://api.github.com/users/<login>/repos.
- Which location is the most represented among Neo4j contributors?