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.

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
12. 1. readxl is all about the data rectangle
14. 2. RStudio IDE has a nice Excel helper
16. 3. readxl’s column typing is groovy
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