Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PostgreSQL API in R (15 pt) Complete following tasks in R using PostgreSQL API: 1. Make a connection to your local PostgreSQL database. 2 2.
PostgreSQL API in R (15 pt) 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 don't 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
Step: 1
To complete the tasks using R and the PostgreSQL API youll need ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
