Publications by Keith Rafferty
Assignment_5
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
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
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
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
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
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
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