readxl RStudio webinar

readxl RStudio webinar

http://readxl.tidyverse.org

Like it or not, spreadsheets are a common data source for many of us. We’ll review the overall landscape for importing spreadsheet data into R and then go into detail for the readxl package specifically. readxl is the Tidyverse (http://tidyverse.org) solution for reading data stored in the legacy xls format or the more modern xlsx format. It has no tricky external dependencies, is quite speedy, and is easy to install and use across all operating systems.

0a4f62e90c976eeb44d33add75cca5af?s=128

Jennifer (Jenny) Bryan

May 10, 2017
Tweet

Transcript

  1.   @JennyBryan @jennybc Jennifer Bryan 
 RStudio readxl www.rstudio.com

  2. http://readxl.tidyverse.org readxl www.rstudio.com

  3. http://tidyverse.org

  4. http://r4ds.had.co.nz

  5. readxl www.rstudio.com

  6. 2015 April First readxl CRAN release! v0.1.0, written by Hadley

    Wickham 2016 March v0.1.1 patch release 2017 April v1.0.0, Jenny Bryan is new maintainer lots of bug fixes, some new features
  7. ## install readxl + other packages install.packages(“tidyverse”) ## install readxl

    alone install.packages(“readxl”) ## regardless, load readxl like so: library(readxl)
  8. readxl, openxlsx, XLConnect, xlsx, gdata, RODBC, excel.link, and more!

  9. .xls vs .xlsx self-contained vs. needs Java/Perl data (frame) vs

    cells & formatting
  10. .xls vs .xlsx self-contained vs. needs Java/Perl data (frame) vs

    cells & formatting readxl www.rstudio.com
  11. None
  12. 1. readxl is all about the data rectangle

  13. None
  14. 2. RStudio IDE has a nice Excel helper

  15. None
  16. 3. readxl’s column typing is groovy

  17. None
  18. 4. workflows for multiple sheets and files

  19. let’s work together in the IDE …

  20. 1. readxl is all about the data rectangle 2. RStudio

    IDE has a nice Excel helper 3. readxl’s column typing is groovy 4. workflows for multiple sheets and files
  21. http://readxl.tidyverse.org readxl www.rstudio.com