Home
About You
Introduction
Data Gathering
Draft Player's Names Gathered by Python Scraping Draft Player's Bio and Stats Gathered by Python API Draft Player's Salary Gathered by R Scraping NHL Tweets Gathered by R API
Data Cleaning
Twitter Data Cleaning with Python Bonus Draft Player's Stats Cleaning with Python Draft Player's Bio Cleaned by R Bonus Draft Player's Salary Cleaned with R
Exploring Data
Clustering
Record Data Clustering with R Text Data Clustering with Python
Arm and Networking
Decision Trees
Decision Trees with Record Data Decision Trees with Text Data
Naive Bayes
SVM
Conclusions
Infographics

Bonus Stat(Record Data) Cleaned Using Python

2011 Draft Statistic Data was cleaned using Python

Link to Raw Data

Link to Code

Link to Clean Data

Steps Taken

Step 1: Importing the JSON File and Flattening it

The data was imported from a json file and the data was flattened to unnest the data for easier access.

Unflattened

1st Round of Flattening

2nd Round of Flattening

Step 2: Droping the unneeded rows.

Multiple rows had incomplete data. THis was due to the different standards in each hockey league in data collection. Due to the data being in middle and high school hockey the data was removed. .

Before

After

Step 3: Converting Values to Numerics

The data was converted to numerics for easier analysis.