Question: #Read in Files library ( readr ) #Adjust the file name and file path below for each of the 2 files. Use the same file

#Read in Files
library(readr)
#Adjust the file name and file path below for each of the 2 files. Use the same file read code from Milestone Two
firefighter <- read_csv("~/SNHU/DAT-500/Milestones/dat500_milestone_two_data_firefighter.csv")
View(firefighter)
police <- read_csv("~/SNHU/DAT-500/Milestones/dat500_milestone_two_data_police.csv")
View(police)
#Adjust the sample field names and variable names below to be the same fields used in Milestone Two
polTotSalMin<-min(police$`Total Salary`)
polTotSalMax<-max(police$`Total Salary`)
polTotSalAvg<-mean(police$`Total Salary`)
ffTotSalMin<-min(firefighter$`Total Salary`)
ffTotSalMax<-max(firefighter$`Total Salary`)
ffTotSalAvg<-mean(firefighter$`Total Salary`)
polRetMin<-min(police$Retirement)
polRetlMax<-max(police$Retirement)
polRetAvg<-mean(police$Retirement)
ffRetMin<-min(firefighter$Retirement)
ffRetMax<-max(firefighter$Retirement)
ffRetAvg<-mean(firefighter$Retirement)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!