DNP

Andrew Friedman

afriedman412 [at] gmail [dot] com

Home • Work • Projects • Open Source • Writing • Content

PROJECTS

Short-Term Rental Revenue Estimator

12-5-2025

Put in a Zillow link in Chicago, the number of bedrooms and bathrooms and how many people it accommodates, get back optimal price per night, expected annual occupancy and predicted total revenue if you were to list it on AirBNB.

Built on a trio of LightGBM models and powered by a neighbor-search stack that uses BallTree for precise local comps, FAISS for fast semantic similarity, and KNN-style aggregation to turn those neighbors into pricing and occupancy signals.

MSDS Capstone project. Blood, sweat and tears. Code available soon. Not investment advice!!!

SKILLS:
Machine Learning, Feature Engineering, Backend Development, Cloud Deployment, DevOps & Tooling

Look At Me

12-4-2023

A light, modular website template built on Python, Jinja2 and not much else.

I made Look At Me because I was having trouble figuring out how to best structure a portfolio website that could showcase projects that fell under multiple categories. For example: I wanted to have a "writing" page and a "data journalism" page, with projects formatted differently on each page. Some projects fell under both categories, but having an entry on each page for the same project didn't seem like the best approach.

Look At Me lets you build a site by filling out some YAML and maybe tweaking some Jinja code if you are feeling spicy. As a bonus, you don't need to learn a new language, or use an external service to do it!

SKILLS:
Flask, Jinja2, CSS

SaysWho

4-1-2023

A Python package for identification and attribution of quotes within a document.

Finds quotes and their speakers using a combination of grammar and logic.
Uses coreferencing models to resolve ambiguous speakers.
Built on SpaCy and Textacy

SKILLS:
SpaCy, Named Entity Recognition, Numpy, Regular Expressions

Rap Caviar Gender Balance Tracker

10-1-2022

Automated data collection and visualization of Spotify's influential Rap Caviar playlist, tracking how the gender balance of artists continues to change over time.

Pulls chart updates daily using the Spotify API.
Infers artist gender based on pronoun usage in artist bios from several sources.
Identifies groups and breaks them into their constituent artists.
Visualizes data using Plotly, including charts of raw and normalized gender balance.

SKILLS:
SQL, AWS, ElasticBeanstalk, Plotly, Pandas

Tracking Use of Passive Voice When Reporting on Police Violence

1-13-2022

I tracked the rate of use of "officer-involved" and similar exonerative language across 20 years of American reporting on police violence. Collaboration with Brandon Soderberg.

SKILLS:
natural language processing

G Sheets Tools

9-1-2020

Light Python package for moving data in and out of Google Sheets.

Manipulate, analyze and share.csv (and .csv-like) data using tools like Jupyter and Pandas.
Avoid the formatting and versioning issues raised by repeated imports and exports.
Easier than using the Google Cloud API!

Housing Court Data Scraper

6-1-2020

I built an app to help housing lawyers fight eviction during the pandemic upheaval.

Automatically identified tenants at risk of missing court dates, allowing lawyers to reach out and offer assistance.
Reduced hours of manually searching through online forms to a few minutes.

SKILLS:
Selenium, BeautifulSoup, SQL

Tenant Help Hotline

6-1-2020

I set up a hotline to make it easier for tenants without internet access to contact BED if they needed the organization's help.

Provides useful tenant information in English and Spanish.
Automatically populates documents from voicemail transcriptions to streamline intake of new tenants looking for help.
Quick resposne line sends a text to members on call in case of emergency.

SKILLS:
Twilio, SQL, AWS

Congressional Financial Disclosure Scraper

6-1-2019

I developed and continue to maintain an app which downloads congressional financial disclosure forms for Sludge, a non-partisan site dedicated to investigating money in politics.

Scrapes public senate and house transaction reports hourly, and uploads new data to SQL database.
Sends text alerts of new financial disclosures to reporting team.

A few of the stories which utilized data from the app:

SKILLS:
Selenium, BeautifulSoup, SQL, Twilio