Data Import from Files, JSON, and XML

---

Slide Deck | Recorded Lecture | Lecture Notes | Guest Lectures | Discussions | Self-Assessment | Diary

---

In this lesson you will be introduced to the R functions and packages required to import data from a variety of text files, including comma separated value (CSV) files, tab delimited files, Excel files, R object files (.RData), and foreign statistical package files (SPSS, Stata, and SAS). In addition, importing XML encoded objects using XML parsing is covered.

---

Objectives
Upon completion of this lesson, you will be able to

• import data from CSV files, tab delimited files, Excel files, and R object files
• parse XML and JSON documents

Required Readings

• Chapter 4 in text book

Suggested Readings

• ​​Comma Separated Values, Wikipedia.org.
• Bosede, Tobi. Working with XML Data in R. June 13, 2014
• R and the Web, Part II: XML in R. June 22, 2012
• The R Primer: Read Data from a Simple XML File. August 2012
• Lang, Duncan. An Introduction to the XML Package for R

Sample Data Sets & Code

• ​​Pubmed Extraction: XML File
• US-500 CSV File
• XML to Data Frame