This portfolio is a compilation of notebooks that I created for data analysis or for the exploration of machine learning algorithms.
The goal of this project was to web scrape The Onions youtube channel and analyze the data with two objectives:
- (1) Analyze the titles of the videos (Natural Language Processing).
- (2) Discover the correlation between the number of views and when the video was posted (Data Manipulation, & Data Visuliation).
Please find the notebook here.
This folder is dedicated to displaying my advanced SQL knowledge. You will find four items:
- (1) A (rough draft) Entity Relationship Diagram of the DB
- (2) A (finalized) Entity Relationship Diagram of the DB
- (3) The SQL code creating the tables and inserting values into those tables
- (4) The SQL code that displays storing, manipulating, and retrieving data in databases.
Please find the notebook here.
This folder is dedicated to showcasing my high-level knowledge and application of interacting with JSON data. You will find two folders:
- (1) JSON-web-dev folder
- (2) JSON-to-Python-and-JSON-to-SQL folder
Technologies utilized: SQL, Python, and web-dev tools (jquery, AJAX, JSON and PHP, servers, APIs). Please find the notebook here.