nwawelairoume / data-analyst-portfolio

Python in Juypter Notebook, PyScripts, SQL

Projects

Python, R, SQL

(Filename) - Description

(2022_Housing_Analysis.ipynb) - Scrape of Zillow data to examine Grand Rapids area median home sale prices.

(scraper.py) - to scrape MI candidate website data to get websites to search and return HTML in text files.

(keyword_ranking.py & scraper.py) - to search the HTML of candidate sites for a keyword and return string of each occurence.

(JBalog_Project_CardioGoodFitness.ipynb) - Project for GreatLearning DS/BA course. Using EDA.

(JBalog_Project_Project_BusinessStatistics_AxisInsurance) - Project for GreatLearning DS/BA course using Statistics.

(COVID_SQL) -- From Alex The Analyst Youtube Channel (https://youtu.be/qfyynHBFOsM) customized queries on COVID data.

(JBalog_Project_LinearRegression (1).ipynb) - Project for GreatLearning DS/BA course using Linear Regression (scikitlearn + statsmodel).

(JBalog_SLC_AllBank_GLProject_Classification.ipynb) - Project for GreatLearning DS/BA course using Logistic Regression & Decision Trees.

(JBalog_ET_Project_GTTravel_EnsembleTechniques.ipynb) - Project for GreatLearning DS/BA course using model ensemble techniques.

(JB_Credit_Card_Users_Churn_prediction.ipynb) - Project for GreatLearning DS/BA course using hyperparameter tuning & sampling techniques.

(JBalog_GLProject_AllLifeBank_CustomerSegmentation.ipynb) - Project for GreatLearning DS/BA course using agglomeration hierarchical and k-means clustering techniques.

(SQL_AdventureWorks.ipynb) - Project to pull data from MSQL db into Juypter Notebook to run Python for CRUD commands.

(SQL_4DS_Exercises.sql) - Following along with the book "SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis": https://bit.ly/2YR0st3