Data Cleaning with Janitor

install.packages("janitor")

trying URL 'https://dirichlet.mat.puc.cl/bin/windows/contrib/3.4/janitor_0.3.1.zip'
Content type 'application/zip' length 71709 bytes (70 KB)
downloaded 70 KB

package ‘janitor’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\S.Uribe\AppData\Local\Temp\RtmpIZSt7Y\downloaded_packages

p_load(readxl, janitor, dplyr, here)

trying URL 'https://dirichlet.mat.puc.cl/bin/windows/contrib/3.4/here_0.1.zip'
Content type 'application/zip' length 16779 bytes (16 KB)
downloaded 16 KB

package ‘here’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\S.Uribe\AppData\Local\Temp\RtmpIZSt7Y\downloaded_packages

here installed

roster_raw <- read_excel("dirty_data.xls")

Error in read_fun(path = path, sheet = sheet, limits = limits, shim = shim,  : 
  Evaluation error: path[1]="dirty_data.xls": El sistema no puede encontrar el archivo especificado.

glimpse(roster_raw)

Observations: 13
Variables: 11
$ `First Name`        <chr> "Jason", "Jason", "Alicia", "Ada", "Desus", "Chien-Shiung", "Chien-Shiung", NA, "James...
$ `Last Name`         <chr> "Bourne", "Bourne", "Keys", "Lovelace", "Nice", "Wu", "Wu", NA, "Joyce", "Lamarr", "Bo...
$ `Employee Status`   <chr> "Teacher", "Teacher", "Teacher", "Teacher", "Administration", "Teacher", "Teacher", NA...
$ Subject             <chr> "PE", "Drafting", "Music", NA, "Dean", "Physics", "Chemistry", NA, "English", "Science...
$ `Hire Date`         <dbl> 39690, 39690, 37118, 27515, 41431, 11037, 11037, NA, 32994, 27919, 42221, 34700, 40071
$ `% Allocated`       <dbl> 0.75, 0.25, 1.00, 1.00, 1.00, 0.50, 0.50, NA, 0.50, 0.50, NA, NA, 0.80
$ `Full time?`        <chr> "Yes", "Yes", "Yes", "Yes", "Yes", "Yes", "Yes", NA, "No", "No", "No", "No", "No"
$ `do not edit! --->` <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
$ Certification       <chr> "Physical ed", "Physical ed", "Instr. music", "PENDING", "PENDING", "Science 6-12", "S...
$ Certification__1    <chr> "Theater", "Theater", "Vocal music", "Computers", NA, "Physics", "Physics", NA, "Engli...
$ Certification__2    <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA

Find duplicates

Tables