Publications by Marco Castro

MC - Project 1 - Chess Data

04.10.2024

Overview For this project, we were given a text document with a very specific formatting and we were asked to reformat into dataframe of columns “Id”, “Player”, “State”, “Total”, “Player Pre-Tournament Rtg”, “Avg. Openent Tournament Rating” that can exported as a csv. Since read the text file in two ways: * using readLines, ...

4141 sym 1 tbl

D607 - Assignment 04

29.09.2024

Overview In this assigment, we were tasked with importing a messy (un-tidy) dataset, performing tiddying operations, and performing some basic analysis on our data. First, I read the csv stored on my github page # load messy dataframe from github page messy_numbersense <- read_csv("https://raw.githubusercontent.com/mcastro64/d607-assignments/refs/h...

3785 sym Python (5000 sym/15 pcs) 1 img 5 tbl

Assignment #3 - Regex and Normalization

22.09.2024

Overview For assignment #3, we focused on normalization and regular expressions. 1. Normalization This section focuses on normalizing dataframes. First I constucted the three dummy dataframes focusing on subset of Major League baseball teams, their respective stadiums and leagues, and the last 4 games (a series) played using the tribble functions....

2617 sym Python (4942 sym/22 pcs) 1 img

D607 - Assignment 2 - Movie Ratings

16.09.2024

Overview I conducted a simple survey asking six participants to rate six movies on a scale from 1 (low) to 5 (hi). Survey submissions were stored in a MySQL database and retrieved in R using the RMySQL package. ## Warning: package 'RMySQL' was built under R version 4.3.3 ## Loading required package: DBI ## Warning: package 'digest' was built under ...

1062 sym Python (2989 sym/14 pcs) 1 img

D607 - Assignment 1 - Urbanization Index

08.09.2024

Overview For the first assignment, I decided to explore FiveThirtyEight’s Urbanization Index which was used as one of backbones for the article How Urban Or Rural Is Your State? And What Does That Mean For The 2020 Election? (https://fivethirtyeight.com/features/how-urban-or-rural-is-your-state-and-what-does-that-mean-for-the-2020-election/). Fiv...

2780 sym Python (2180 sym/3 pcs) 3 img