library(tidyverse)
library(tidyr)
library(dplyr)
###PRACTICE MERGING###
#1. Read in each file from the folder NH-2020-M5
#2. Perform some exploration of the data and understand how these datasets join
#3. Join these datasets to create a masters NIBRS dataset
#4. Use this dataset to answer questions for your R Lab Quiz
#5. Use this dataset to create a relational diagram in the lucidchart app (DATABASE ER DIAGRAM: CROWS FOOT)
#6. Use this dataset to explore the central limit theorem
###########Perform your analysis and data manipulation below##########
#1. NH-2020-M5 DATASET FILE READ IN
ref_race<-read.csv(‘/cloud/project/NH-2020-M5/REF_RACE.csv’)
NIBRS_OFFENSE<-read.csv(‘/cloud/project/NH-2020-M5/NIBRS_OFFENSE.csv’)
NIBRS_OFFENSE_TYPE<-read.csv(‘/cloud/project/NH-2020-M5/NIBRS_OFFENSE_TYPE.csv’)
NIBRS_OFFENDER<-read.csv(‘/cloud/project/NH-2020-M5/NIBRS_OFFENDER.csv’)
NIBRS_LOCATION_TYPE<-read.csv(‘/cloud/project/NH-2020-M5/NIBRS_LOCATION_TYPE.csv’)
NIBRS_incident<-read.csv(‘/cloud/project/NH-2020-M5/NIBRS_incident.csv’)
agencies<-read.csv(‘/cloud/project/NH-2020-M5/agencies.csv’)
Requirements: concise (simplified)

Leave a Reply
You must be logged in to post a comment.