Chapter 2. Import/Export Data
The main goals of this chapter are to familiarize the reader with the various classes of objects in R, help the reader extract data from various popular formats, connect R with popular databases such as MySQL, and finally, the best export options of the R output. The main purpose is that the practitioner frequently has data available in a fixed format, and sometimes the dataset is available in popular database systems. This chapter helps the reader to extract data from various sources, and also recommends the export options of the R output.
We will begin by gaining a better understanding of the various formats in which R stores the data. Updated information about the import/export options is maintained on http://cran.r-project.org/doc/manuals/R-data.html. On the Python front, we will be using the Jupyter Notebook throughout the book. Here, we will deal with the basic operations and give indications to import the data from external sources. Python session...