1 Querying Multiple Tables (50pt) 1. Import data from banks_sec_2002 and banks_al_2002. Delete duplicate rows from...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Querying Multiple Tables (50pt) 1. Import data from banks_sec_2002 and banks_al_2002. Delete duplicate rows from banks_sec_2002 2. Select proper join manner to join banks_sec_2002 and banks_al_2002. Make sure that all data from banks_sec_2002 are kept in the joint table. Report the first 10 observations. 3. Create a new table banks_total. Insert the values from previous joint table into this new one. And set a primary key for the table. 4. For each quarter of the year 2002 count how many banks have security over 20% of its' asset. 5. How many banks have liability over 90% of assets in first quarter of 2002 but goes below 90% in the second quarter of 2002. 6. Export the joint table (banks_total) to a csv file. 2 PostgreSQL API in R. (50pt) Complete following tasks in R using PostgreSQL API: 1. Make a connection to your local PostgreSQL database using API. 2. Import the csv file you got from Problem 1 (banks_total) into a new table in the database using API. (Hint. Please give the table a new name if table 'banks_total' exists in the database) 3. Retrieve the data of table 'banks_total' using API. Count how many rows in the table. 1 Querying Multiple Tables (50pt) 1. Import data from banks_sec_2002 and banks_al_2002. Delete duplicate rows from banks_sec_2002 2. Select proper join manner to join banks_sec_2002 and banks_al_2002. Make sure that all data from banks_sec_2002 are kept in the joint table. Report the first 10 observations. 3. Create a new table banks_total. Insert the values from previous joint table into this new one. And set a primary key for the table. 4. For each quarter of the year 2002 count how many banks have security over 20% of its' asset. 5. How many banks have liability over 90% of assets in first quarter of 2002 but goes below 90% in the second quarter of 2002. 6. Export the joint table (banks_total) to a csv file. 2 PostgreSQL API in R. (50pt) Complete following tasks in R using PostgreSQL API: 1. Make a connection to your local PostgreSQL database using API. 2. Import the csv file you got from Problem 1 (banks_total) into a new table in the database using API. (Hint. Please give the table a new name if table 'banks_total' exists in the database) 3. Retrieve the data of table 'banks_total' using API. Count how many rows in the table.
Expert Answer:
Related Book For
Business Analytics Data Analysis And Decision Making
ISBN: 9780357109953
7th Edition
Authors: S. Christian Albright, Wayne L. Winston
Posted Date:
Students also viewed these databases questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
In Problems, use a calculator to give a decimal approximation of the numbers to three decimal places. e 4
-
In Problems below, a graph is given. Tell where f (x) is concave up, where it is concave down, and where it has points of inflection on the interval - 2 x 2, if the given graph is the graph of (a)f...
-
Sixty-year-old Jim Ebers retired from his computer consulting business in Boston and moved to Florida. There he met 27-year-old Ann Bowers, who had just graduated from Eldon Community College with an...
-
Krista was a passenger in a rented van. She sustained injuries when the driver of the van slammed into a tree after the vans brakes failed. The driver of the van was not an authorized driver pursuant...
-
Classifying Costs: Product or SG&A/Asset or Expense Required Use the following format to classify each cost as a product cost or a selling, general, and administrative (SG&A) cost. Also indicate...
-
6. 7. 8. If one of the diameters of the circle x + y-2x-6y+6=0 is a chord of another circle 'C', whose centre is at (2, 1), then its radius is Let Bi (i = 1, 2, 3) be three independent events in a...
-
On January 1, 2024, Harlon Consulting entered into a three-year lease for new office space agreeing to lease payments of $5,000 in 2024, $6,000 in 2025, and $7,000 in 2026. Payments are due on...
-
An examination of the RB Partnerships tax books provides the following information for the current year. Operating (ordinary) income before guaranteed payments $300,000 Long-term capital gain 6,000...
-
How would you implement usability testing of a web site that you havedeveloped? Describe how you would use server log data, cookies, andtagged pages in the collection of effectiveness website data....
-
Koala Pty Ltd makes premium fishing rods and sells them to fishing retailers around Australia. Their products are in such high demand that Koala Pty Ltd sells everything they make (that is, they have...
-
7. In each of the following scenarios, a through d, determine whether the following is a microeconomic or macroeconomic issue and WHY. a. Dell computers announces that it will raise the price of its...
-
All of us are very familiar with chained food restaurants like KFC, McDonald and Subway. Compare decision-making in certain conditions and decision-making in uncertain conditionsthat occur in the one...
-
Discuss the following: a) b) c) The usefulness of models in managerial decision-making within firms. (5 marks) Process of theory formulation/model building (using an example of a theory/model known...
-
1. a. Define waste. Briefly discuss the physical properties of sewages. b. Write about Bio-medical waste management.
-
Extend Algorithms 3.4 and 3.5 to include as output the first and second derivatives of the spline at the nodes.
-
The file P03_15.xlsx contains monthly data on the various components of the Consumer Price Index (CPI). The source claims that these data have not been seasonally adjusted. The following parts ask...
-
The P04_18.xlsx file contains a single-table Data Model on a companys sales and a single blank worksheet. The goal is to create a pivot table that shows the ratio of average revenue per transaction...
-
The file P12_24.xlsx contains the daily closing prices of Procter & Gamble stock from April 2017 to April 2018. Use only the 2017 data to estimate the trend component of the random walk model. Next,...
-
We define the even and odd parts of a sequence \(x(n), \mathcal{E}\{x(n)\}\) and \(\mathcal{O}\{x(n)\}\) respectively, as \[\begin{aligned}\mathcal{E}\{x(n)\} & =\frac{x(n)+x(-n)}{2}...
-
Find one solution for each of the difference equations below: (a) \(y(n)+2 y(n-1)+y(n-2)=0, y(0)=1\) and \(y(1)=0\) (b) \(y(n)+y(n-1)+2 y(n-2)=0, y(-1)=1\) and \(y(0)=1\).
-
Determine the solutions of the difference equations below, supposing that the systems they represent are initially relaxed: (a) \(y(n)-\frac{1}{\sqrt{2}} y(n-1)+y(n-2)=2^{-n} \sin \left(\frac{\pi}{4}...
Study smarter with the SolutionInn App