Importing Data in R

There are different ways to import data in R depending on the source from which the data is to be imported.

Few of the sources are listed below:

1)   Importing text and spreadsheets (read.table, sep, header, stringsasfactors)

Cmd line method:

Using GUI for data import:

2)   Importing data of different statistical formats in R such as (foreign /SPSS, sas7bdat /SAS)

Using Data.table package

3)   Configuring ODBC on Windows OS

Connecting to RDBMS using RODBC

4)   Using SQLDF for SQL Queries in R

Using Sqlite in R

5)   Web scraping (readlines, RCurl, XML)

JSON data

6)   Reading Data from the Internet

Web Data from RGoogleAnalytics

7)   NoSQL Databases (couchDB, MongoDB)

8)   Introduction to Big Data Packages(ff, bigmemory, RevoScaleR)

Exit mobile version