Question: This question is based on stocksdb database. You will also need the DBI and RMYSQL packages, as well as the ggplot 2 package in R.
This question is based on stocksdb database. You will also need the DBI and RMYSQL packages, as well as the ggplot 2 package in R. a) Load the "Transaction" table into a data frame tDF in R using the dbReadTable command (similar to what we did in class and assignments). Show the R-Code. (While you need to create the connection string and run it in R, you need not show that code here; it is sufficient to show the R code for dbReadTable). b)Plot the histogram of the Quantity column. Show the R-Code and the Result. c) Plot the histogram of Quantity using the transaction type as the facet. (Hint: Use the facet_wrap feature). Show the R-Code and the Result
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
