Ch. 1 - Importing data from flat files with utils
Introduction & read.csv
read.csv
stringsAsFactors
Any changes?
read.delim & read.table
read.delim
read.table
Arguments
Column classes
Final Thoughts
Ch. 2 - readr & data.table
readr: read_csv & read_tsv
read_csv
read_tsv
readr: read_delim
read_delim
skip and n_max
col_types
col_types with collectors
data.table: fread
fread
fread: more advanced use
Dedicated classes
Ch. 3 - Importing Excel data
readxl (1)
List the sheets of an Excel file
Import an Excel sheet
Reading a workbook
readxl (2)
The col_names argument
The skip argument
gdata
Import a local file
read.xls() wraps around read.table()
Work that Excel data!
Ch. 4 - Reproducible Excel work with XLConnect
Reading sheets
Connect to a workbook
List and read Excel sheets
Customize readWorksheet
Adapting sheets
Add worksheet
Populate worksheet
Renaming sheets
Removing sheets
About Michael Mallari
Michael is a hybrid thinker and doer—a byproduct of being a StrengthsFinder “Learner” over time. With nearly 20 years of engineering, design, and product experience, he helps organizations identify market needs, mobilize internal and external resources, and deliver delightful digital customer experiences that align with business goals. He has been entrusted with problem-solving for brands—ranging from Fortune 500 companies to early-stage startups to not-for-profit organizations.
Michael earned his BS in Computer Science from New York Institute of Technology and his MBA from the University of Maryland, College Park. He is also a candidate to receive his MS in Applied Analytics from Columbia University.
LinkedIn | Twitter | michaelmallari.com