Read Data from Other Scources in R

• http://cran.r-project.org/web/packages/foreign/foreign.pdf

 

• RPostresSQL provides a DBI-compliant database connection from R. Tutorial-https://code.google.com/p/rpostgresql/, help file-http://cran.r-project.org/web/packages/RPostgreSQL/RPostgreSQL.pdf
• RODBC provides interfaces to multiple databases including PostgreQL, MySQL, Microsoft Access and SQLite. Tutorial - http://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf, help file - http://cran.r-project.org/web/packages/RODBC/RODBC.pdf
• RMongo http://cran.r-project.org/web/packages/RMongo/RMongo.pdf (example of Rmongohttp://www.r-bloggers.com/r-and-mongodb/) and rmongodb provide interfaces to MongoDb.

 

• https://code.google.com/p/rpostgresql/
• http://cran.r-project.org/web/packages/RPostgreSQL/RPostgreSQL.pdf
• http://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf
• http://cran.r-project.org/web/packages/RODBC/RODBC.pdf
• http://cran.r-project.org/web/packages/RMongo/RMongo.pdf
• http://www.r-bloggers.com/r-and-mongodb/
• http://cran.r-project.org/web/packages/rmongodb/rmongodb.pdf

 

• jpeg - http://cran.r-project.org/web/packages/jpeg/index.html
• readbitmap - http://cran.r-project.org/web/packages/readbitmap/index.html
• png - http://cran.r-project.org/web/packages/png/index.html
• EBImage (Bioconductor) - http://www.bioconductor.org/packages/2.13/bioc/html/EBImage.html

 

• rdgal - http://cran.r-project.org/web/packages/rgdal/index.html
• rgeos - http://cran.r-project.org/web/packages/rgeos/index.html
• raster - http://cran.r-project.org/web/packages/raster/index.html

 

• tuneR - http://cran.r-project.org/web/packages/tuneR/
• seewave - http://rug.mnhn.fr/seewave/

 

Source from: http://jtleek.com/modules/03_GettingData/02_05_readingFromOtherSources/#1

 

If you are interested in read data from Microsoft Excel, please refer to below blog:

http://wendellandservicescience.blogspot.tw/2013/11/r-r.html

file.choose(): to open “Select file” window

Read Data from APIs in R

https://dev.twitter.com/docs/api/1/get/blocks/blocking

https://dev.twitter.com/apps

https://dev.twitter.com/docs/api/1.1/get/search/tweets

https://dev.twitter.com/docs/api/1.1/overview

 

Source from: http://jtleek.com/modules/03_GettingData/02_04_readingFromAPIs/#1

Read Data from Web in R

http://www.theatlantic.com/technology/archive/2014/01/how-netflix-reverse-engineered-hollywood/282679/

http://scholar.google.com/citations?user=HI-I6C0AAAAJ&hl=en

 

http://cran.r-project.org/web/packages/httr/httr.pdf

 

Source from: http://jtleek.com/modules/03_GettingData/02_03_readingFromTheWeb/#1

Read Data from HDF5 in R

• http://www.bioconductor.org/packages/release/bioc/vignettes/rhdf5/inst/doc/rhdf5.pdf
• http://www.hdfgroup.org/HDF5/

Source from: http://jtleek.github.io/modules/03_GettingData/02_02_readingHDF5

Read Data from MySQL in R

http://dev.mysql.com/doc/employee/en/sakila-structure.html

http://dev.mysql.com/doc/refman/5.7/en/installing.html

http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL

http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/

http://genome.ucsc.edu/goldenPath/help/mysql.html

• http://cran.r-project.org/web/packages/RMySQL/RMySQL.pdf
• http://www.pantz.org/software/mysql/mysqlcommands.html
• http://www.r-bloggers.com/mysql-and-r/

 

Source from: http://jtleek.com/modules/03_GettingData/02_01_readingMySQL/#1

 

If you are interested in connect R to Microsoft SQL Server, please refer to below blog:

https://andersspur.wordpress.com/2013/11/26/connect-r-to-sql-server-2012-and-14/