Recently Published
DATA 607 Project 3 — Code Validation, Data Transformation, and SQLite Integration (Kevin Martin)
This notebook validates and extends the data engineering workflow for our team’s Data 607 Project 3. It processes the original Google Trends dataset (data_science_skills_gt.csv) into a clean, long-format version (trends_long.csv) and stores it in a structured SQLite database (warehouse.db).
The project demonstrates reproducible data cleaning, transformation, and database loading in R, ensuring team members can reliably access the processed data for analysis and visualization. The process highlights best practices for collaborative version control and R-to-SQL integration in data science workflows.