Ch. 1 - Importing data from databases (Part 1)
Connect to a database
Establish a connection
Inspect the connection
Import table data
List the database tables
Import users
Import all tables
How do the tables relate?
Ch. 2 - Importing data from databases (Part 2)
SQL Queries from inside R
Query tweater (1)
Query tweater (2)
Query tweater (3)
Query tweater (4)
Join the query madness!
DBI internals
Send - Fetch - Clear
Be polite and …
Ch. 3 - Importing data from the web (Part 1)
HTTP
Import flat files from the web
Secure importing
Downloading files
Import Excel files from the web
Downloading any file, secure or not
Reading a text file from the web
HTTP? httr! (1)
HTTP? httr! (2)
Ch. 4 - Importing data from the web (Part 2)
APIs & JSON
From JSON to R
Quandl API
OMDb API
JSON & jsonlite
JSON practice (1)
JSON practice (2)
toJSON()
Minify and prettify
Ch. 5 - Importing data from statistical software packages
haven
Import SAS data with haven
Import STATA data with haven
What does the graphic tell?
Import SPSS data with haven
Factorize, round two
foreign
Import STATA data with foreign (1)
Import STATA data with foreign (2)
Do you know your data?
Import SPSS data with foreign (1)
Excursion: Correlation
Import SPSS data with foreign (2)
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