Part 2 of your data visualization project
Last updated May 2021
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.
A-D Ohio
E-J Illinois
K-N Georgia
O-S Arizona
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
Table 1
The Data Dictionary
Fields
Description
date_received
The date the CFPB received the complaint
product
The type of product the consumer identified in the complaint
issue
The issue the consumer identified in the complaint
company
The complaint is about this company
state
The state the consumer resides in
zip_code
The mailing ZIP code provided by the consumer
submitted_via
How the complaint was submitted to the CFPB
date_sent_to_company
The date the CFPB sent the complaint to the company
company_response_to_consumer
The response from the company about this complaint
timely_response
Indicates whether the company gave a timely response or not
complaint_id
The unique identification number for a complaint
delay
The number of days between the date received by the CFPB and the date the complaint was submitted to the company
population
Population based on the zip code of the consumer
median_household_income
The 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.
Update the 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
· Why is this interesting or important? What about it is important?
· What requires clarification?
· What pitfalls could cause the analysis to be incomplete or incorrect?
· Who is the audience? What do you think the audience expects?
· How much time do you have to complete the project?
· What are the project conditions?
· What tools do you have access to?
· Or, as is the case in this course, what are you limited to, regarding software?
· Can the evidence be summarized in one visualization? Two? Several?
· Will the results of this analysis be an exhibit (evidence), an explanation (presentation), or an exploration (audience interaction)?
Working with data
When you work with the data, whether cleaning, investigating, or exploring, ask yourself questions as you progress through the process. These questions may include
· Are the right data types assigned?
· How many observations are associated with the state I’m assigned?
· How do I filter for the complaints specific to the analysis I’m assigned?
· Which fields apply to this analysis?
· What is the range of the median household income, the population, and the delay between receiving and forwarding customer complaints?
· Should no or zero delay observations be separated? (Is management more interested in the overall or what or how the response times can be improved?)
· Are there fields of data that would add to the data story that are outside the scope? Does the scope need to be modified? Perhaps you identified that a specific product or company was associated with all of the delays exceeding 50 days. That could be very useful information to the management team. Another possibility might be that there is one type of company response to the customer that has the higher delay time. Perhaps focusing on the delays exceeding a certain number of days offers very different insight than no or only a few days of delay? Yet another possibility? Perhaps the time of year, like a particular season, coincides with the length of the delay?
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 moreEach 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 moreThanks 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 moreYour 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 moreBy 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