Coding and Data Projects

This page highlights programming and data analysis projects. Click the descriptors in each box below to learn more; a blue pop-up window should appear.

If you are having trouble viewing the pop-ups on a mobile device, try rotating your screen.

Epic Health Information Analysis

As someone interested in data analysis and healthcare, I wanted to gain more experience with real-world data. I began analyzing Epic Systems EHI Tables exported from patient portals of myself and my family members (with their permission!). Tables were stored in a SQLite database and joined to analyze trends. GitHub repository is available here.

First, I used Python to extract claim remittance information and estimate the 10th, 50th, and 90th percentile prices for each billing code in line with the CMS Hospital Price Transparency rule. I then used the remittance data and the Healthcare Cost and Utilization Project's Clinical Classification Software (a SAS program) to determine what types of services were provided. I then created reports in Power BI.

Categories of claims:
A pie chart showing categories of medical services with lab services being most common

Some sliceable tables showing price distributions by insurer and by billing code, with identifying information redacted:
A table showing all services that Insurer 4 charged for and their prices. The bottom of the visual says 16 types of services were delivered at three types of facilities for a total of 76 claims.

A table showing all services that Insurer 4 charged for and their prices. The bottom of the visual says 16 types of services were delivered at three types of facilities for a total of 76 claims.

Table showing all insurers and prices for billing code 12. There were 10 claims in two types of facilities covered by three insurers with the lowest 10th percentile price being $0 and the highest 90th percentile price being $371.

Close

Transit App

While living in the DC metro, I frequently rode Metrorail, Metrobus, and other regional buses. Since transit around the DMV is operated by different entities, I often had to switch between multiple websites while commuting. Additionally, while WMATA's busETA has a map on desktop, on mobile it only shows a list of stops. ART RealTime similarly does not have a map and only shows distance to a specified stop. In March 2024, I made an R Shiny Markdown app that shows the location of multiple trains and buses I rode frequently using protocol buffers from the WMATA/ART APIs.

The website has maps, calculates great-circle distance between buses and specified stops, and shows current WMATA alerts. I initially hard-coded specific routes and stops, then updated the app to allow the user to select a route. Updating the app also accounted for WMATA's updated bus networks in summer 2025. Mousing over each vehicle shows vehicle number, whether it's in motion, nearest stop, and crowding.

Legacy map with defined stops and estimated distance:
a map of ART Route 72 with yellow circles representing buses and green circles representing stops. A section below the map estimates how close the nearest bus is to a specific stop.

a map of ART Route 72 with yellow circles representing buses and green circles representing stops. A section below the map estimates how close the nearest bus is to a specific stop.

A map showing the orange and silver line train locations on Metrorail

New maps with changeable routes:
A map of Metrobus Route A70 with red circles representing buses. Mousing over each circle shows a tooltip with information.

A map of Metrobus Route A70 with red circles representing buses. Mousing over each circle shows a tooltip with information.

A gif showing the user changing bus routes in a dropdown from A70 to A58 to C37. The map updates with each new route.

Close

Food Points Spending

In my first year at Duke, I began scraping transaction data from my student account to analyze patterns in how I spent my food points (Duke's dining dollars). By senior spring, I had enough data to write a narrative for the Duke Chronicle on how my spending habits changed over the years. I created Flourish visuals to accompany the story. One of the interactive visualizations is featured below.

This project received an honorable mention in the Multimedia Feature Story of the Year category in the 2023 Associated Collegiate Press Pacemaker Awards.

Close

Qualtrics Surveys: Duke's incoming classes and student vaccination experiences

I contributed to the Duke Chronicle's annual first-year survey project for three years, leading the team in the third year. Each year, the team designed a survey in Qualtrics, disseminated the survey via flyers, email, and word-of-mouth, and presented the results through a series of articles. We received around 300 responses each year and compared our findings to publicly available information about the first-year class. Trends were visualized in Tableau.

Some of my reports:
Meet Duke's Class of 2026: The Chronicle's first-year survey results
Chronicle to release survey data on Class of 2025: Inside the methodology and limitations
COVID-19 pandemic impacted first-years' living situations, but many still found community

Independently, I designed and administered a survey on students' experiences getting the COVID-19 vaccine during the pandemic. The sample size was nearly 100 people and yielded some interesting trends.

Close

Time for Duke classes to reach 100% enrollment

Inspired by the Daily Bruin's "How quickly do classes fill up?", I created a Python tool to scrape class information from Duke's student information system, DukeHub, periodically for about an hour each day during registration. (I later learned that Duke has an API for class offerings already.) For best results, view the dashboard on Tableau Public on a desktop computer.

A dashboard showing registration over time (line graph) for AAAS 89S First Year Seminar Section 2. Registration is 0 from October 27, 2021 until November 4, 2021. Registration then increases starting November 4 until it reaches 100% on November 8.

Close

HealthCarolina

Over the course of the fall 2021 semester, I developed a website to display North Carolina health statistics at the county level for my Database Systems class. In addition to generating visuals, the website could also calculate the nearest health facility available in the database. After the course ended, I updated the website to make it more user-friendly, with the option to create an account, save search results and make changes via an admin dashboard.

Two screenshots, one of HealthCarolina's export page and one of Microsoft Excel showing the output.

Screenshots of the HealthCarolina admin dashboard showing user information and recent feedback submissions with timestamps, and the edit user functionality for admins.

Close

Text Message Analysis

I wrote a Python script to analyze my text messages, which were stored in a db file on my Macbook. The script calculates how many messages I exchanged with a particular contact, which emojis and reactions I used most frequently, and how often I "double texted" before getting a response and vice versa. The analysis shown in the below images includes messages between December 24, 2020 and December 30, 2021.

Console output showing I sent 2,606 texts to Mom and Mom sent 4,326 texts to me between December 24, 2020 and December 30, 2021. A variety of emojis and reactions were sent and received. I sent an average of 1.4 and a median of 1 message before Mom responded and Mom sent an average of 2.4 and median of 2 messages before I responded.

Console output showing I sent 970 texts to the group chat and received 4,566 texts between March 11, 2021 and December 30, 2021. A variety of emojis and reactions were sent and received. I sent an average of 1.3 and a median of 1 message before the chat responded and received an average of 6.3 and median of 4 messages before I responded.

Close

Interactive graphic for teacher salaries

In this contribution to the Chalkbeat Data Team blog, I explain how I developed a graphic that accepted user input and queried a Google Sheet containing updated salary bands for Memphis teachers.

Is this link broken/unresponsive? Try the Wayback Machine or contact me.

Close

Epic Health Information Analysis

Skills: Python (SQLite3, Subprocessing, Pandas), Power BI, SAS

Transit App

Skills: R Shiny, API Calls

Food Points Spending

Skills: Excel, Python, Flourish

Qualtrics Survey Collection and Analysis

Skills: Survey Design, Communication, Excel, Python, R, Tableau

Duke Class Registration Temporal Data

Skills: Python (Selenium, Multiprocessing, SQLite3), SQL, Tableau

HealthCarolina Website

Skills: SQL, Python (Flask), HTML, CSS

Text Message Analysis

Skills: ETL (SQL), Python

Building an interactive graphic for teacher salaries

Skills: HTML, CSS, JavaScript, Git Versioning, Databases

Last updated