Skip to content

Instantly share code, notes, and snippets.

@jjaderberg
Forked from davidoliverSP2/nfl_draft.adoc
Created May 11, 2017 16:05
Show Gist options
  • Select an option

  • Save jjaderberg/310d0fb0afb2934e50f1c9df790af6b4 to your computer and use it in GitHub Desktop.

Select an option

Save jjaderberg/310d0fb0afb2934e50f1c9df790af6b4 to your computer and use it in GitHub Desktop.
The 2016 NFL Draft

The 2016 NFL Draft

Introduction

REPLACEME: Introductory text and domain model image.

Rr4qZi3

This domain model diagram was created with the Arrows tool

Setup

LOAD CSV WITH HEADERS FROM 'https://gist.githubusercontent.com/davidoliverSP2/716ed3b7155efbe78b5bd41d4c3c523a/raw/bcba24649549b58f44563766cba39bdb8ba2931b/draft_data.csv' AS line
MERGE (pl:Player {name: line.Player, draftposition: toInt(line.`Draft Position`)})
MERGE (rd:Round {id: toInt(line.Round)})
MERGE (tm:Team {name: line.Team})
MERGE (ps:Position {name: line.Position})
MERGE (cl:College {name: line.College})
MERGE (cn:Conference {name: line.Conference})
CREATE (pl)-[:POSITION_IS]->(ps)
CREATE (pl)-[:TO]->(tm)
CREATE (pl)-[:FROM]->(cl)
CREATE (pl)-[:PICKED_IN]->(rd)
CREATE (pl)-[:PLAYED_IN]->(cn)
CREATE (College)-[:PLAYS_IN]->(cn)
CREATE (Team)-[:SELECTION]->(rd);

REPLACEME: FIRST USECASE TITLE

MATCH (a:Person {name: 'Alice'})-[:FRIENDS_WITH]-(:Person)-[:FRIENDS_WITH]-(fof:Person)
RETURN fof.name as fof, count(*) as frequency

REPLACEME: SECOND USE-CASE TITLE

MATCH path=(a:Person {name: 'Alice'})-[:FRIENDS_WITH]-(:Person)-[:FRIENDS_WITH]-(fof:Person)
RETURN path, a, fof

REPLACEME: THIRD USE-CASE TITLE

Conclusions

REPLACEME: Offer a conclusion

Resources

REPLACEME: Link to resorces like data sources, further discussions,


Created by David Oliver - Twitter | Blog | LinkedIn

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment