Scripting for Data Analysis

Catalog description

This hands-on course teaches students to design implement, and deploy scripts for real world data analysis using Python and SQL. Students will learn to ingest, parse, validate, and transform data from JSON, APIs, spreadsheets (e.g., CSV, google sheets and Excel), and streaming sensor sources (e.g., thermostats, power meters, telemetry, etc. Emphasis is on building both small utilities, small scripts and modular scripts that automate data pipelines, integrate SQL queries, produce meaningful static graphics, interactive visualizations, and reproducible reports. The course culminates in a project where students deliver an end-to-end pipeline from data acquisition to dash-boarded results. Prerequisite: Grade of D- or higher in CS 142. Offered: Fall, Spring.