All of my practice code 💻 and projects will be located here.
Contact me
« Back to Portfolio
☑️ Data cleaning and Exploring using R
☑️ ggplot graphing and data visualization using R
☑️ Coursera 'Programming for everybody' Certificate (Python)
☑️ Google data analytics professional Certificate (*R)
☑️ Completed Kaggle 'Intro to Programming' Course
☑️ Built out a few simple programs in Python through Self Learning
Important
- Learned the power of Pandas and PyQt5 libraries. Also learned the importance of notating code for Bug fixing in the future.
- A web app designed to simplify both meal planning and shopping for dinner.
↪️ - Scraped review data from two competing websites and analyzed overall sentiment of each review. Used nltk VADER model and huggingface RoBERTa moedl to score reviews.
Price Comparison using Selenium
↪️ - Using Selenium and python I scraped products and their prices from the first page of two websites based on search input the user enters. The prices are then averaged and compared from the two websites to see which one has better pricing.
Roller Coaster data exploration
↪️ - Explored and database of roller coaster information that dates back to the early 1900s.
↪️ - Rob Mulla's Kaggle competition to predict his sleep patterns using a sample dataset.
- Explored and cleaned a cell phone price dataset found on Kaggle.
- Made a full breakdown detailing the basic functions and uses of the R* programming language.
- A repo full of my Javascript code. Lots of custom stuff made to work on Carrd websites.
*Click arrow to view content
SQL Queries
8 Weeks of SQL- Explored complex queries to clean data, compute customer figures, and organize data in unusual ways.
Data Lemur SQL Questions
- SQL interview questions using CTEs, multiple joins, subqueries, aggregations, and other advanced SQL functions.
Khan Academy Advanced SQL
- Expand SQL knowledge about combining tables with JOINs and using multiple queries at once.
SQLbolt - SQL lessons
- Refreshed foundational understanding of SQL and discovered context variations among SQL-powered platforms.
Data Analysis / Visuals Projects
Power BI Dashboards- Collection of my Power BI projects/dashboards with detailed analysis and visually appealing data.
Netflix Movies and TV Shows
- Built out multiple sheets to display on a single visual, and created an interactive dashboard.
SLC civilian complaints
- Utilized API calls to gather data from public sources. Built a local DB to use in Power BI to uncover valuable insights.
