Connecting-postgreSQL-R

Creating a database in PostgreSQL, importing data to the db, connecting with R and performing analysis on the db using R

All you need is R with RPostgreSQL package and a PostgreSQL database.

Steps:

1. Create the database
2. Copy the table(s) needed to your db
3. Load the RPostgreSQL package in R (or Rstudio)
4. Create a connection to the data base
5. The query your data into an R dataframe
6. You are the free to do your analysis in R!!!