Data Analytics & Python

Dashboard in Excel

Data Visualization in Excel

Microsoft excel icon

Reformated the data in the Excel columns so that they were more readable. For example, changing 'M' and 'S' to 'Married' and 'Single' so that you don't have to guess what the single letters stand for. Used the information to create pivot tables and then used those pivot tables to create a dashboard with filters.

View Project
Screenshot of SQL queries

SQL: Data Cleaning and Exploration

SQL iconMicrosoft Excel icon

Used SQL to analyze Covid data. Looked at things like countries with the highest rates of infection per population, countries with the highest death count per population, and continents with the highest death count per population.

View Project
A measuring tape on top of a scale

Python: BMI Calculator

Jupyter iconAnaconda icon

Your standard body mass index (BMI) calculator written in Python. It'll prompt the user their name, weight in pounds, and height in inches, and then let you know what category you fall in.

View Project
Files being sorted into a folder

Python: Automatic File Sorter

Jupyter iconAnaconda icon

Input your file path and it will create a seperate folder for png, csv, and text files and then seperate those files into their respective folders.

View Project
Image of several 20 dollar bills under a laptop keyboard

Python Web Scraping: Amazon

Jupyter iconAnaconda iconMicrosoft Excel icon

Built a web scraper using Python in Jupyter Notebook that checks on a "Got Data?" t-shirt that is for sale on Amazon. It pulls the title, price, rating, and description information, formats the information to make it more readable, and logs the data in a csv file (creating the csv file if it doesn't already exist). I set it up to automatically pull the data once a day and append it to the csv file. There's also code to send an email if the t-shirt's price drops below $14.00.

View Project
Several gold coins with the BitCoin logo in front of a line graph

Python: Crypto Currency API

Jupyter iconAnaconda iconMicrosoft Excel icon

Pulls information from a crypto currency API and stores it in a dataframe using Pandas and Python. Set it collect the data once every minute and then append the data to the dataframe. Then worked on cleaning the data and making it more readable and eventually putting the data into charts.

View Project