Tutorials – Peter Amerkhanian

The following are a collection of my informal notes and tutorials on topics in programming, math, statistics, and policy analysis. Note that these posts do not reflect the views of my employer.

Subscribe for Email Updates RSS

Using The Excel Object Model in Python

Python

Data Management

Replace VBA with Python. Interacting with Excel using xlwings/pywin32 to produce formatted tables.

Working with ACS microdata in R

R

Data Management

What’s the median household income in Oakland? Using ipumsr, geocorr, and survey to analyze census micro-data for a small-geography.

Grouping Problems with SQL

SQL

Data Management

An overview of GROUP BY and PARTITION BY statements in SQL.

Building Time-series Utilities for `matplotlib`

Python

Writing utility functions for matplotlib and using them to visualize BART’s ridership data.

The Covariance Matrix from Scratch

Python

Linear Algebra

Notes on matrix algebra and covariance, with a mix of formal notation and python code.

Integrals in Probability

R

Calculus

Probability

Notes on the definite integral and probability modeling, with a mix of formal notation, plotly visuals, and sympy computation.

Production Maximization with Lagrange Mutlipliers

R

Calculus

Solving an optimization problem in (Strang and Herman 2016) using lagrange multipliers, with some plotly visuals mixed in.

Simple Optimization in 3D

R

Calculus

Solving an optimization problem in (Strang and Herman 2016), with plotly visuals.

Linear Approximation in 3D

Python

Calculus

Using taylor series to approximate function output, with python visuals.

Law Enforcement Activity in San Francisco, 2018-2024

Policy Analysis

I analyze trends in arrests and citations in San Francisco

Overfitting and The Train-Test Split

Python

Statistics

Using re-sampling to better estimate model performance.

Iterated Expectations

Python

Probability

Notes on conditional probability and adam’s law, with a mix of formal notation and python code.

Newton’s Method From The Ground Up

Python

Calculus

Using newton’s method for root-finding and optimization, with python code and a .gif of the search.

Simple Constrained Optimization in 2D

Python

Calculus

Introductory optimization, with formal notation, python code, and matplotlib visuals.

Policy Responses to a Coronavirus Pandemic

Policy Analysis

I develop a mathematical model to analyze the effects of policy interventions during a Coronavirus pandemic.

Reliable PDF Scraping with tabula-py

Python

Data Management

Using tabula in python to read in tables from .pdf files