Data Cleansing – Spencer Payne

Projects focused on importing, reshaping, standardizing, and validating data. The formats include JSON, Excel, Stata, SPSS, and DBF, and the work covers both Python (pandas) and R (tidyverse).

Picking the Best Day for a Chipotle Promotion

DS 350 · Data Wrangling & Visualization

String Parsing

Data Reshaping

Parsed nested visit-by-weekday strings for thousands of locations to recommend which day to run a promotion.

Combining Five Height Datasets

DS 350 · Data Wrangling & Visualization

Data Wrangling

tidyverse

Imported Stata, SPSS, DBF, and CSV sources, standardized units, and combined them into one tidy dataset to test whether people are getting taller.

Tidying Historical Height Data

DS 350 · Data Wrangling & Visualization

tidyr

Data Cleaning

Reshaped a wide Excel table of average male height by country into tidy long format and charted the trend over time.

Categories

Picking the Best Day for a Chipotle Promotion

Combining Five Height Datasets

Tidying Historical Height Data