Publications by Tyler Frankenberg
CUNY MSDS DATA607 Project 1 - Chess Ratings
Importing the Data We’ll start by reading the raw data into a tibble. rawdata <- as_tibble(read.csv("https://raw.githubusercontent.com/curdferguson/607-project1-chessratings/main/tournamentinfo.txt", header = FALSE, stringsAsFactors = FALSE, sep = "|")) # thank you to Eric Hirsch for helping with this import framework Cleaniing the data To c...
1801 sym R (4399 sym/13 pcs)
College Majors, Fruits & Lady Gaga
Question 1: Subsetting a dataframe using regular expressions Using the 173 majors listed in fivethirtyeight.com’s College Majors dataset…provide code that identifies the majors that contain either “DATA” or “STATISTICS”… url <- "https://projects.fivethirtyeight.com/mid-levels/college-majors/index.html?v=3" majors <- read_html(url)...
2089 sym R (3688 sym/31 pcs)
CUNY MSDS DATA607 Wk1 Homewwork Assignment
Men’s Attitudes about Manliness, by Age group In the FiveThirtyEight post “What Do Men Think It Means To Be A Man?” https://fivethirtyeight.com/features/what-do-men-think-it-means-to-be-a-man/, the authors examine responses to a 2019 survey to see if American men’s attitudes about masculinity vary across regions and within demographics. T...
4234 sym R (3414 sym/7 pcs) 2 img
607-Wk2-Romantic-Movies
How does the Murray’s CX team feel about Romantic Movies? In honor of Valentine’s Day, we’ll conduct a brief and informal survey of the Murray’s Cheese CX team. How do they feel about the best romantic movies of the last 30 years, as aggregated by Rotten Tomatoes? Import movies from Rotten Tomatoes We’ll pull the movie titles with thei...
2858 sym R (2542 sym/7 pcs) 1 img
CUNY_MSDS_607-wk9-hw9
Introduction The New York Times API service at https://api.nytimes.com offers a wealth of information with relatively easy access to those who register as developers. In this vignette we’re going to connect to the API for the purpose of locating the current “Food and Nutrition” bestseller’s list. Finding the appropriate list We’re inte...
812 sym R (475 sym/2 pcs)
CUNY_MSDS_607-wk7-hw7
HTML url <- "https://raw.githubusercontent.com/curdferguson/607-wk7-hw7/main/recommended_reads_cheese.html" books_parsed <- read_html(url) # read the information from the HTML table books_html <- books_parsed %>% html_table(fill = TRUE) %>% .[[1]] %>% as_tibble() %>% rename(`Link Text` = `Buy Online`) # create a column for ...
24 sym R (2326 sym/4 pcs)
CUNY_MSDS_607-wk6-project2-USSenate
Introduction We often hear about the advantage of incumbency in American leglislative elections. This data from senate races 1974 - 2018 shows the amount spent and number of candidates per party, with additional variables including which challenger vs incumbent, and outcome including the margin of victory. This data comes from the Brookings Intit...
1316 sym R (4866 sym/13 pcs)
CUNY MSDS DATA607-wk6-project2-Data_at_Work
Introduction Week 5 Discussion Inspiration In week 5 discussion posts, one classmate proposed looking at data scraped from LinkedIn, while another proposed wrangling data obtained in .JSON format through an API call. While I initially hoped to get relevant data on recruiters’ and job seekers’ advertised skills from LinkedIn’s API, I found ...
5176 sym R (5547 sym/13 pcs) 1 img
607 Final Project Part 1 - Azure SQL Transactions Database
Step 1… Provisioning the Azure SQL database and Azure Blob Storage container This project started with provisioning an Azure SQL database on a brand new server, dedicated for this project. My aim was to establish a database in the cloud I could manage using SQL Server Management Studio or Azure Data Studio. In this database, we’ll be taking t...
5545 sym R (5345 sym/6 pcs) 13 img
CUNY_MSDS_607-wk11-hw11
Kroger.com Kroger.com (https://www.kroger.com/) is the eCommerce home for the nation’s largest grocery retailer, The Kroger Co. Kroger.com’s target users are online grocery shoppers, as well as shoppers of its brick-and-mortar retail supermarkets across the country. Their key goals are to select from a wide variety of grocery products, either...
3549 sym 5 img