Bruce A. Lee

Introduction In this script, I’m calling an API that houses data for Nintendo Switch titles, so the resulting data frame can be used in other applications. Specifically, I thought it would be interesting to work with the dates contained in the data to visualize everything in a time series. … Setup & Extracting the data # Import appropria... Read More

Introduction: Polars & Discogs API For this project, I’m calling the Discogs API to create a DF of any album I want within Discog’s album catalog so that I can make it into a data frame. Any album can be called by any artist, but be mindful of the name of the artist and file’s name when saving to .csv If its desired to do an entire artist’... Read More

Introduction: This is a showcase of sample SQL queries that I made for practice in learning the language. The sources listed before each query link to the direct place the content came from, unless noted otherwise. Each heading represents a concept of SQL that I touched on. Primary Sources: DataLemur by Nick Singh SQL-practice.com by Boolean-... Read More

Introduction Hello! I made this script to demonstrate what an ETL process looks like using my local PostgreSQL database, Python, some SQL and a schema with sample data from a DVD rental store. I’d say this is a look into days gone by with what used to be the main form of media in the world. Otherwise, this is still a work in progress, so anyon... Read More

Introduction: Hello! In this project, I’m breaking down the top content creators on Youtube over 2017-2018. The very first thing i’ll do is load the libraries I’m going to use: import pandas as pd import numpy as np import seaborn as sb import matplotlib.pyplot as plt import datetime as dt import json from itables import show %matplotlib inl... Read More

The following is a script I made to test features in Python, using a dataset I generated from a local PostgreSQL database. import pandas as pd import numpy as np import matplotlib.pyplot as plt import seaborn as sns #itables for viewing data from itables import init_notebook_mode from itables import show #Read data hr_data = pd.read_csv(... Read More

STARs are workers who are “Skilled Through Alternative Routes”. This population of the workforce comprises of working aged adults who have not attained anything educationally past a High School Diploma, yet, have demonstrated the ability to hone their skill to a competitive edge in the labor market. Usually, STARs go through military service, c... Read More

This is probably the nerdiest thing you’ll ever read about Pokémon. The beauty of this game is that fundamentally, it’s one of numbers. A bevy of formulas and calculations go into every nuance of what happens in-game. From stat modifiers, critical hits, how much damage each move does (which takes into account many variables based on stats) and ... Read More

This is a project based on a tutorial my friend Carlos made to help me learn R initally. I took the content and expanded on it to make the plots you’ll see below. Much of the syntax is tidyverse, so this should serve as a good primer of things to do when getting acclimated to the language. The data set I’m using here is one based on traffic viol... Read More

Hello! Welcome to my analysis of my Spotify listening history, where I break down all the wonderful things that I’ve found in my listening history. This write-up was inspired by many of the pieces I found looking up project ideas relating to Spotifyr, and needless to say, I was amazed to see the things that I’ve been listening to. The first thi... Read More

Here’s some samples from my Tableau Public page, which can be found here. MCP Traffic Stops in the DC Area: This graphic showcases traffic stops among the various demographics that live in Washington DC and the surrounding area. … World Food Programme Global Commodity Analysis Global Food Prices data from the World Food Programme. See cap... Read More

Hello! Welcome! This is my data portfolio. If you happened to wander here, I thank you for your consideration of myself and my experiences. This website is a collection of projects and information meant to definitivly prove that I in fact know how to do Data Analysis. I want to thank everyone that I was able to learn from along the way that he... Read More