Building on Part 1, Part 2 incorporates working with the data used in the visualization project. When you work with data, the objective does not change. It is still a problem to solve, a question to answer, or a hypothesis to test.
How does focus affect cleaning and exploring data?
It is very important to understand the data and how the different fields are interrelated. However, if a field of the data is not relevant to the project, or is outside the scope of the project, that data should not continue to be included in the cleaning and exploration process.
Consider the research question that is the focus of this visualization project.11 In this translation, I used Vermont. However, the state that you will use is based on the first first name listed in Blackboard. Using the first letter of that name, you can find the state you will use.
T-V Washington (state, not D.C.)
W-Z New Jersey
Using the wrong state will cause a loss of no less than 20% of the possible points.
“Is there a relationship between a consumers’ local area population, the consumers’ local median household income, and the days of delay between receiving and forwarding consumer complaints from Vermont in 2020?”
And consider the data dictionary
The Data Dictionary
FieldsDescriptiondate_receivedThe date the CFPB received the complaintproductThe type of product the consumer identified in the complaintissueThe issue the consumer identified in the complaintcompanyThe complaint is about this companystateThe state the consumer resides inzip_codeThe mailing ZIP code provided by the consumersubmitted_viaHow the complaint was submitted to the CFPBdate_sent_to_companyThe date the CFPB sent the complaint to the companycompany_response_to_consumerThe response from the company about this complainttimely_responseIndicates whether the company gave a timely response or notcomplaint_idThe unique identification number for a complaintdelayThe number of days between the date received by the CFPB and the date the complaint was submitted to the companypopulationPopulation based on the zip code of the consumermedian_household_incomeThe median household income based on the zip code of the consumer
Note. This is the data dictionary based on the data adapted from CFPB (n.d.)22 Consumer Financial Protection Bureau. (n.d.) Consumer complaint database API docs [data set and code book]. Office of Civil Rights. Retrieved April 28, 2021, from https://cfpb.github.io/api/ccdb/index.html and Rozzi (2021).33 Rozzi, G. (2021). Data & functions for working with US zip codes. GitHub. https://github.com/gavinrozzi/zipcodeR/
Click here to download the data. (complaints.RData)
Knowing the scope of this analysis, what purpose does the field
zip_code serve? Could this field be pertinent to providing the proper context or the whole picture? Probably not. Potentially this field could be used to validate the cleanliness of the data in the
state field, however, other than that this field is not within the scope of this project. Therefore the data in this field is not something that is necessary to clean or manipulate in the exploration of the data.
Investigate the data sample within the scope of this project. Ensure the data is clean by checking for abnormal entries, incorrect field types, and other inconsistencies.
Before executing the necessary actions in an R script file, think about the plan that you prepared in Part 1. As you work with the data, you will be able to identify things that need to change in your original plan.
For this week’s objective, you will update the plan and add information about the status of the project, after you work with the data.
Consider all of the questions that you did when you made the original plan. What needs to change? What can be clarify better? Don’t write about what is different, only write about the current state of the project. If I want to know what is different, I can reread your Part 1 submission.
Formulating the brief answers these questions
When you work with the data, whether cleaning, investigating, or exploring, ask yourself questions as you progress through the process. These questions may include
It may be helpful to develop these questions in your script file as comments before working with the data, then add the coding applicable to each question as you answer them.
Note: we will be using Arizona
I will provide the data when ready.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more