Publications by Keith Rafferty

Assignment_5

29.09.2024

Data Import, Tidying, and Transformation The data is imported as a CVS file and converted to a data frame. The third row is dropped from the data frame because it is an empty row that served as a spacer between the data for the individual airlines in the CSV file. Next, the airline names are duplicated to fill in the missing values in rows 2 an...

1659 sym R (1857 sym/5 pcs) 3 img 3 tbl

Project_1_Data607

23.09.2024

Project 1 Objective: “In this project, you’re given a text file with chess tournament results where the information has some structure. Your job is to create an R Markdown file that generates a .CSV file (that could for example be imported into a SQL database) with the following information for all of the players: Player’s Name, Player’...

550 sym R (65731 sym/25 pcs) 1 tbl

Assignment 3

16.09.2024

Question 1 Using the 173 majors listed in fivethirtyeight.com’s College Majors dataset [https://fivethirtyeight.com/features/the-economic-guide-to-picking-a-college-major/], provide code that identifies the majors that contain either “DATA” or “STATISTICS”. knitr::opts_chunk$set(echo = TRUE) library(tidyverse) ## ── Attaching cor...

1685 sym R (1693 sym/7 pcs)

DATA607 - Assignment_2

09.09.2024

Using MySQL to Generate and Export the Data Within MySQL Workbench, create a schema titled “Movie_scores” or something similar. Import and run the movie_ratings.sql script, which will generate a csv file output. Note that you may need to alter the directory in line 18 for the ouput if you encounter a “–secure-priv-option” type error. ...

994 sym R (516 sym/1 pcs) 1 tbl

Assignment1_updated09072024

07.09.2024

Overview 538’s Generic Ballot polling average (link) is a staple of its election year coverage and forecasting, although it is overshadowed in Presidential election years. The current average, built from the table shown below (note that the columns “election” and “cycle” have been omitted in this rendering), shows that the Democratic ...

940 sym R (234 sym/2 pcs) 1 tbl

Data607_Assignment1

02.09.2024

Overview 538’s Generic Ballot polling average (link) is a staple of its election year coverage and forecasting, although it is overshadowed in Presidential election years. The current average, built from the table shown below (note that the columns “election” and “cycle” have been omitted in this rendering), shows that the Democratic ...

835 sym 1 tbl

Assignment_1

02.09.2024

Overview 538’s Generic Ballot polling average (link) is a staple of its election year coverage and forecasting, although it is overshadowed in Presidential election years. The current average, built from the table shown below (note that the columns “election” and “cycle” have been omitted in this rendering), shows that the Democratic ...

835 sym 1 tbl