Python – Colin Beran

The Omega Protocol (Ultimate) Damage Done Dashboard

Back with another Final Fantasy XIV dashboard, this time for the most recent (and quite difficult) encounter, The Omega Protocol (Ultimate). I started out this one by using GraphQL to collect data through the FFLogs API and imported the data into Google BigQuery. I ran a few SQL queries to preprocess the data (the queriesContinue reading “The Omega Protocol (Ultimate) Damage Done Dashboard”

Dragonsong’s Reprise Damage Taken Exploration

Hello! What I have here today is another look at the same Dragonsong’s Reprise (Ultimate) clear from Final Fantasy XIV, but this time it’s damage taken. Rather than just clone the same boring dashboard from before, I wanted to do a bit of Python work so I did a bit of a dive into theContinue reading “Dragonsong’s Reprise Damage Taken Exploration”

Old School Runescape Hiscores

Python exploration of Old School Runescape Hiscores data gathered on July 21st, 2022. Two small projects here: 1. Boss kill count tracking for one particular username. When executing the code, the user is prompted for a case-sensitive OSRS username and then they are given a table of information including all bosses and that user’s killContinue reading “Old School Runescape Hiscores”

LastFM Customer Value Scoring

Using the sampled dataset found here, I created a simple customer scoring model based on an RFM (Recency, Frequency, Monetary) model, replacing the monetary value with a “uses per day” value. This information was created with the intent of hypothetically implementing a monetization system into LastFM’s service. Check out the GitHub repository for more info.

COVID-19 Vaccination Progress Analysis (Python)

This is a short analysis of the COVID-19 World Vaccination Progress dataset by Gabriel Preda over on Kaggle. (A follow-up of the R version I posted.) I used Python to analyze this dataset and generated plots that show the progress we’ve been making in vaccinating against COVID-19. Check out the full notebook on Kaggle or the outputs on GitHub.

Data Exploration of Video Game Sales (Python)

This is a follow-up on the exploration of the Video Game Sales dataset by GregorySmith on Kaggle, this time using Python. It’s essentially the same information as before, this time there’s a bit more regional comparison. Take a look at the full exploration on Kaggle or the outputs on GitHub.