Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions

Question

=+j Describe the various support services delivered by IHR.

Answered: 1 week ago