Big Data R Program Assignments | Online Homework Help

Week 15 Assignment – 100 points
Objective: Using SQL query in R data frame. Given the Consumer_Complaints.csv, use sqldf( ) to query the database for the following reports:
1) Query for all the states where “Movement Mortgage” are present – (columns are Company & State)
2) Query for all the states where “Movement Mortgage” OR “Hewitt-Capital” are present – (columns are Company & State). Sort the by Company.
3) Query for the Product of “Consumer Loan” and the various means of Submitting the complain relating to Consumer Loan (Submission via). Count each mean of submission (Submission via). (Columns are Product, ‘Submitted via’, ‘Count Submitted Via’
4) Query for company called “ACS Education Services” and its various Company Response. Count each Company Response. Columns are Company, CompanyResponse & ‘Count Company Response’.
5) Query for all Product and ‘Submitted via’ and count each of the ‘Submitted via’. Sort by Product and ‘Submitted via’. Your columns are Product, Submittedvia, & ‘Count Submitted via’

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

professional writing services near me
> sqldf(“select company, state from myData where company ==’360 Mortgage'”)
Company State
1 360 Mortgage MD
2 360 Mortgage CA
3 360 Mortgage FL
4 360 Mortgage AZ
5 360 Mortgage TX
6 360 Mortgage UT
7 360 Mortgage TX
We start by loading the appropriate libraries in R: sqldf package as follows:
> install.packages(“sqldf”) > library(sqldf)
Next, we load the csv file and check the statistical properties of the csv File as follow:
> setwd(“C:/RData”) # your working directory
> myData <- read.csv(“path to Consumer_complaint.csv”) # loading the file
> str(myData) # check the properties of the file
. . . continue from here!
Important Note
You need to rename the column with space to remove the space. For example, you should rename ‘Submitted via’ to SubmittedVia before you begin your query because R programming does not like either space or dot in-between words.
Useful Links
Additional Note:
Your paper must have cover-page and reference-page.
There will be penalty for late assignment. No any screenshot is allowed in this assignment.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
looks great
Customer 463501, October 16th, 2022
Good job.
Customer 459155, May 31st, 2022
English 101
Good one.
Customer 453625, May 25th, 2022
Absolutely wonderful speech! Thank you so much!
Customer 462815, April 20th, 2022
Health Care
It is exactly my expectation. Thank you.
Customer 454755, June 30th, 2020
Business and administrative studies
Customer 459467, May 1st, 2022
A job well done. The writer followed the instructions to detail.
Customer 463679, March 30th, 2023
The PowerPoint Presentation is PHENOMENAL! The writer went above and beyond my expectations! Thank you so much.
Customer 452455, February 15th, 2023
Healthcare & Medical
Thank You for such a great content
Customer 463469, October 29th, 2022
ASCI 491 Operational Applications in Aeronautics
Excellent. Ensure your color selections enhance group presentations.
Customer 457731, March 29th, 2022
Excellent work.
Customer 459155, June 7th, 2022
good job
Customer 452741, March 27th, 2020
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat