The R-Podcast Episode 6: Importing Data from External Sources

[This article was first published on The R-Podcast, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

In this episode: Listener feedback and importing data from external sources into R. We dive into the basics of importing delimited text files using read.table and its varients. We also discuss recommendations for importing MS Excel spreadsheet files, relational databases such as MySQL, data from HTML tables, and files produced by other statistical computing packages. If you are interested in providing a listner tip about R in audio format, please call the voicemail hotline at +1-269-849-9780 or record a short mp3 or ogg audio clip and send it to theRcast(at) . Hope you enjoy the episode!

The following resources are mentioned in this episode:

Episode 6 Time Stamps

00:00 The R-Podcast #006 Importing Data from External Sources
00:34 Introduction
01:46 Listener Feedback
07:45 Description of delimited text files
09:18 Using read.table and key arguments
18:17 R Data Import-Export Manual
19:10 Importing spreadsheet data considerations
21:10 XLConnect package advantages
25:20 Importing HTML tables using XML package
33:55 Using RMySQL with MySQL databases
43:52 Data from other statistical software
44:18 The foreign package
45:45 sas7bdat package
49:13 Wrapping up: subscribe to the podcast, [email protected], + 1-269-849-9780
53:54 End

To leave a comment for the author, please follow the link and comment on their blog: The R-Podcast. offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)