Ramandeep(101483021) edited subsection_Research_on_NHL_Team__.tex  almost 8 years ago

Commit id: 07388ec533da1d290b30de30a1add82c022844c1

deletions | additions      

       

The R code used to get the data from API and also saving the data to local CSV files. R coding is new technique which is very easy for implementation. For this exercise Rcode is used to getting the data from CSV files and saving the data back to CSV file after making the graph of data.  One Note: The data for this post include all of the games completed through January 15th, 2016 within the Atlantic Division.  Steps in this exercise will be followed:-  1. \textbf{Load \subsubsection{\textbf{Load  the data Data  into Neo4j} Neo4j}}  i)First, set the constraint on the id property for teams (which is a value returned by the API), using CREATE query.  ii)Now import the teams(using Load CSV with Headers's query)  iii)Now set the constraint on games(using CREATE CONSTRAINT query)  iv)And Now load the games(using Load CSV with Headers query)  v)Finally, join the teams and games, an set some properties on the relationship(using MATCH and MERGE query)  vi)Last step is Explore \subsubsection{Explore  the Data(MATCH,RETURN query) Data}  explore the all data using MATCH,RETURN query  vii)In this exercise, also gave the ranking to the teams.