Latest Posts – banditkings

On a journey to use data and science to help people make better decisions.

A Trivial Comparison of Python Probabilistic Programming Languages

python

bayesian stats

modeling

A simple side-by-side comparison of the syntax for several probabilistic programming languages (PPL) using a trival regression example.

Revenue Optimization with Price Elasticities and Scipy

python

optimization

modeling

An introductory example of revenue optimization using the minimize function from scipy.optimize

Bayesian Regression with numpyro

python

bayesian stats

modeling

A simple example of regression with numpyro

A friendly introduction to scan with JAX

python

A friendly introduction to scan with JAX and numpyro

Creating Color Palettes from Animated GIFs with Julia

julia

data visualization

How to automatically generate custom color palettes for data visualization from animated GIFs with Julia

Time Series Forecasting 102 for Finance Analysts

python

forecasting

Part 2 of a first-time training around time series forecasting aimed at Finance Analysts in my company, focused on model evaluation.

Time Series Forecasting 101 for Finance Analysts

python

forecasting

Part 1 of a first-time training around time series forecasting aimed at Finance Analysts in my company, focused on identifying types of models used in modern forecasting.

Dash (Plotly) tips - Latex, Google Fonts, and more

dataviz

python

A few tips on making your Dash application look a little better

A SQL to Julia DataFrames Cheatsheet

julia

modeling

What would common SQL expressions look like in Julia DataFrames and Julia DataFramesMeta?

Making Custom Fiscal 52/53 Workweek Calendars in Pandas

modeling

How to build custom financial calendars that have 52 or 53 workweeks in a fiscal year (aka the 4-4-5 calendar) using pandas

Updating Your Julia Installation (Feb 2023)

julia

workflow

What it takes to update from a previous install of Julia on Mac/Linux

Python Pandas - Merging With Wildcards and Conditions

modeling

Merging two dataframes with pandas but only if certain conditions are true.

Making a Basic Corporate Plotly Template

dataviz

TLDR on how to make a corporate themed plotly template

Getting Started with WSL for Data Analysis

workflow

My steps for a fresh install of Windows Subsystem for Linux for Data Analysis

Adding Plotly Charts to Markdown

python

dataviz

workflow

Quick reference that shows options to add plotly charts to a markdown document

‘Tie Fighter’ Errorbar Charts in Python with Plotnine and Altair

python

dataviz

It’s December 2020 and it’s time to check out different python plotting packages. I primarily will use pandas dataframe plotting with either seaborn’s sns.set() or setting…

Quick Bash Script for Complete Newbies

workflow

Basic shell scripting for everyday productivity.

Clean Sparkline-style Line Chart for Dash Cards

dataviz

Code snippet to create a clean line chart to go in a Dash Card.

KPI Card with Dash Bootstrap Components

dataviz

python

Code snippet to create a starter KPI card with Dash Bootstrap Components

Make a Basic PnL Dataframe in Pandas

workflow

Code snippet to create a PnL (Profit and Loss Statement) Dataframe in Pandas

Time Series Cheat Sheet in R

modeling

Getting started using the forecast package for time series data in R, as quickly as possible and no explanations.

How to set up ODBC in Mac OS to connect to MS SQL Server for use with Python and R

workflow

My local data mart runs on MS SQL Server, and I want to pull data directly into R or Python for data analysis. This is really easy on Windows with its’ built-in ODBC manager, but I spent a weekend figuring out how to do this after switching to OSX. A lot of documentation out there is old (from 2012), so I decided to make this for anyone still looking for an answer in 2019.

Fast Excel with the Quick Access Toolbar

Excel is still the lingua franca of Corporate Finance and is blazing fast for quick, ad-hoc analyses. I learned early on to use excel without a mouse, and with the Quick Access Toolbar and some macros, you can even make Excel feel like a video game!