Join William Lyon for an in-depth discussion in this video Perform calculations, part of Database Clinic: Neo4J.
- [Instructor] The process that we'll use…to compute our forecast…will be to compute the state population by year,…then calculate cohort percentages…for the various educational attainment levels,…and multiply these percentages…by the total population prediction, giving us the forecast…for each educational attainment level.…So the first component that we need…is the population prediction at the state level.…We can calculate state total population by year…by matching on each population prediction node…then aggregating by year by summing the population property.…
So let's go ahead and do that.…Match on population prediction,…with an outgoing four year relationship to the year node.…Then we'll return y.year, alias that to year…for better readability,…then we want to sum the population property,…alias that to population,…and let's order that by year.…Run this query.…This will take a moment to complete…because we need to match…on all 3.6 million population prediction nodes.…
And now we can see that we have…our state population prediction by year,…
- Strengths and weaknesses of Neo4j
- Data modeling
- Creating a database
- Joining data sets
- Modeling data for joining data sets
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Intermediate
1. Neo4j in Five Minutes
A brief overview of Neo4j3m 23s
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 44s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.