Question: Complete following tasks in R using PostgreSQL API: 1 . Make a connection to your local PostgreSQL database. 2 2 . Query the PostgreSQL database

Complete following tasks in R using PostgreSQL API:
1. Make a connection to your local PostgreSQL database.
2
2. Query the PostgreSQL database via API to get the original bank data. (The bank data
that you import to PostgreSQL database in Q 1.1) Store the data into a dataframe.
3. Calculate asset growth rate for each quarter and each bank. (asset growth rate =(current
quarter value - previous quarter value)/ previous quarter value). The result start from
second quarter, since we dont have all necessary data for first quarter calculation. Store the
calculation result in a data frame.
4. Export the dataframe of Q 3.3 to the PostgreSQL database via API.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!