Modern R Programming Cookbook

How it works…

To connect with the PostgreSQL server from R, the RPostgreSQL library is required, and this library has already been loaded in the first place. The dbDriver() function extracts the necessary database driver that needs to interact with the database from external software, such as R in this case. The dbConnect() function takes the database driver, username, password, and the host name along with the port number as the input and creates a connection between R session and the database server. Once the connection has been established, then you are ready to interact with the database.

To create a new R dataset by taking the unique value of the column named ORIGIN and the frequency of occurrence of each value of the ORIGIN column, ...