howtwo3
Patricio Romero
Recently Published
DATA 607 – Project 2: NYC Housing Prices Approach
This report presents my approach for analyzing average housing prices in New York City. It describes the dataset selection, planned data transformation using tidyr and dplyr, two research questions, and the proposed analysis.
DATA 607 – Project 2: Water Quality Approach
This report presents my approach for analyzing water quality chemistry data in DATA 607. It describes the dataset selection, planned data transformation using tidyr and dplyr, two research questions, and the proposed analysis.
Project 2 — NYCHA Electricity Approach
Approach for the NYCHA Electricity dataset selected for DATA 607 Project 2.
DATA 607 Week 5A – Airline Delays Code
This project analyzes airline delay data for Alaska Airlines and AM West across five destinations. The original data were recreated, stored in PostgreSQL, retrieved with R, populated for missing airline values, and transformed from wide to long format. The analysis compares overall and city-level delay percentages and explains the discrepancy between the results.
DATA 607 Week 5A – Airline Delays Approach
Approach for the DATA 607 Week 5A Tidying and Transforming Data assignment. This project uses PostgreSQL and R to prepare airline arrival data for Alaska Airlines and AM West, populate missing values reproducibly, transform the data from wide to long format, and compare airline delay percentages overall and across five destinations.DATA607-Week5A-Airline-Delays-Approach
DATA 607 Project 1 – Chess Tournament Code Base
Complete R and Quarto code for transforming a semi-structured chess tournament cross-table into a tidy CSV dataset. The report extracts 64 player records, calculates each player's average opponent pre-tournament rating, validates Gary Hua's expected result of 1605, performs exploratory analysis, and generates chess_tournament_results.csv.
DATA 607 Project 1 – Chess Tournament Approach
Planned approach for transforming a semi-structured chess tournament cross-table into a reproducible CSV dataset using R and Quarto. The document describes the data structure, required variables, transformation plan, validation strategy, and expected output.
DATA 607 Week 3B - Window Functions Approach
Planned approach for using PostgreSQL window functions to calculate year-to-date and six-day moving averages for daily stock prices.
DATA 607 Week 3A – Global Baseline Approach
Planned approach for retrieving movie-rating data from PostgreSQL and preparing a Global Baseline recommendation analysis in R.
DATA 607 Week 2A: SQL and R Approach
Planned approach for the DATA 607 Week 2A assignment. This project describes the collection of movie ratings using Google Forms, the design of a normalized SQLite database, and the planned analysis in R.
https://rpubs.com/howtwo3/1457462/edit
This report presents my planned approach for evaluating a binary classification model using the penguin predictions dataset. It describes the data source, validation process, probability thresholds, confusion matrices, performance metrics, anticipated challenges, and expected results.
DATA 607 Week 1: Electric Vehicle Rebate Analysis Code
A reproducible analysis of the NYSERDA Drive Clean Rebate dataset, including data preparation, summary tables, visualizations, findings, and recommendations. Code
DATA 607 Week 1: Electric Vehicle Drive Clean Rebate Data
My planned approach for analyzing NYSERDA Electric Vehicle Drive Clean Rebate data using R.