DS4100 | Data Collection, Integration and Analysis
  • Home
  • Units
  • Schedule
  • Assignments
    • Assignments >
      • Assignment 1
      • Assignment 2
      • Assignment 3
      • Assignment 4
      • Assignment 5
      • Assignment 6
      • Assignment 7
      • Assignment 8
      • Assignment 9
      • Assignment 10
      • Assignment 11 >
        • Real Estate Appraisal Case
      • Assignment 12
      • Assignment 13
    • Project
    • Portfolios & Blogs
  • Policies
    • Attendance
    • Collaboration
    • Exam Rules
    • Assessments
    • Grading
    • Academic Integrity
  • Resources
    • Lecture Notes >
      • Characteristics and Challenges of Big Data
      • Installing R and RStudio
      • Essential Programming in R
      • Basic Data Shaping
      • Essential Excel
      • Data Import
      • Web Scraping
      • Web APIs
      • Relational Data Storage
      • NoSQL Data Storage
      • Descriptive Analytics
      • Predictive Analytics
      • Explanatory Visualization
      • Analytics Reporting
      • Python for Data Science
      • Machine Learning
      • Data Governance
      • Data Quality
      • Profession of Data Science
      • Ethics in Data Science
    • Tools
    • Text Books
    • Additional Readings >
      • R Style Guide
      • Forecasting Cases
  • Help
    • Blog
    • Class Diary
    • Office Hours
    • Instructor

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
Picture

Learning

Blackboard
Lynda.com
​
Data Camp

Support

Contact Instructor
FAQ
Terms of Use
© COPYRIGHT 2016-17 by Martin Schedlbauer, Ph.D.
​FREE FOR ACADEMIC USE WITH ACKNOWLEDGEMENT AND NOTICE. 
ALL RIGHTS RESERVED.
✕