Essay Final Project 1

Submitted By lilywang0314
Words: 1737
Pages: 7
Open Document
Consumer Complaints: Financial Products and Regional Analysis

Introduction
As a result of the financial crisis, the financial services industry has been under the spotlight in recent years. It has been alleged that financial institutions have poor business practices, leading to increased risk being transferred to consumers. These poor business practices would be expected to be reflected in consumer complaint data for these services. Public unrest with the financial services industry has also mainly been focused on certain products, such as mortgages, and large public financial corporations, such as Bank of America, or J.P. Morgan Chase.

The goal of our analysis is to understand the actual underlying structure and trends of consumer complaints regarding consumer financial instruments in order to understand if these assumptions hold true. This includes which financial products receive the most complaints, which geographic areas these complaints originate from, and whether a link between company size and consumer complaints can be identified.

Related Work
While multiple studies have been conducted to analyze consumer complaints in relation to behavior, strategy, satisfaction, and response; our approach to review consumer complaint data through financial product geographic segmentation can be deemed unique.

Processes
To fulfill the goals of this analysis, our team explored the following three research questions:

1. For each year in the consumer complaint dataset, which three products recorded the most complaints?

2. What region has the highest proportion of complaints in relation to the population of complaints for each year in the consumer complaint dataset? Within this region, which state has the highest proportion of complaints, and within this state, which zip code has the highest proportion of complaints?

3. Can a correlation between the market capitalization of the company and the rate of complaints received be identified?

To address these questions, we wrote multiple python programs utilizing the pandas library to analyze and visualize the data set.

Prior to starting our analysis of any of our purposed questions, our first step was to confirm data integrity and perform any data cleansing that would be necessary. Right away we discovered that our dataset did not contain complete data for all the years listed. The team concluded that to ensure our analysis was not skewed; the original dataset had to be reduced to only the available years of complete data, 2012 and 2013. From this point, we were able to dig into the data and start answering questions.

1. For each year in the consumer complaint dataset, which three products recorded the most complaints?

The team utilized Python to import the entire dataset into a pandas DataFrame. From the original import we created two additional DataFrames which contained the separated 2012 and 2013 complaint data. We then performed a groupby sum function on both DataFrames, with the grouped criteria being the financial product (ex. Mortgage, Credit Card, etc.). This provided a very clear picture of the top three financial products in each year that received the most complaints. We then chose to graphically display these results by plotting a bar graph. To ensue the clarity of our results, we differentiated the top three complaint products by color.

2. What region has the highest proportion of complaints in relation to the population of complaints for each year in the consumer complaint dataset? Within this region, which state has the highest proportion of complaints, and within this state, which zip code has the highest proportion of complaints?

In order to effectively perform analysis for our second inquiry, we needed to expand our data to encompass population demographics. The original complaint data set provided us with the state and zip code where the complaint was received. This allowed us to merge our existing DataFrame with the following additional
Show More

Related Documents: Essay Final Project 1

1 Final Project Essay

Final Project Instructions—ASAM 308 The final project will be made up of 1) a research paper and 2) a PowerPoint The research paper (5-6 pages not including works cited page) will focus on an issue or topic pertaining to Asian American women of the student’s choice from the curriculum. The research paper should analyze in-depth some aspect of the selected issue or topic in terms of its social or historical context, themes, or problems. You may choose your own topic using the course material or…

Words 787 - Pages 4

Essay about Project 1 Final

Project 1 New Training Division This new training division is to improve on sales techniques as well as sales training for those who are wanting to work in the automotive industry. This is a fairly new training division, which will soon be in an office accessible to every state in Australia. Automotive Industry What to expect This new training is for those who are wanting to gain experience and improve their skills for if they wish to work in the automotive industry. We will be first testing…

Words 313 - Pages 2

Essay on Final Project Feedback Forum 1

For this project I’m working with Emily Zaccone and Mark Rubinstein. Our assigned location is 196 Grand Street Waterbury, CT. We have decided and think this space is perfect for a beauty salon. Choosing the right location is very important when opening a business. Location is critical to the success of our business. 196 Grand Street is a high-traffic area. This helps our business because people usually visit busy streets like this one. We will have easy access for our customers. If parking is a…

Words 360 - Pages 2

Essay on Final Project Outline Notes September 1

I. Environmental Analysis : (A) External Analysis - 1. Macro - the general environment a. economy - b. political - c. legal - approximately 10,000 employees in 2013; non were covered by a collective bargaining agreement; safety is embodied in the hiring, training, and review processes; motor vehicle records are reviewed to ensure a minimum safe driving record of one or two years (driving records, proof of insurance); not aware of any environmental laws (federal, state…

Words 484 - Pages 2

ENG 112 Final Project Example 1 Essay

Student Name Prof. Correll ENG 112 28 April 2014 Kevin Carter’s Haunting Photograph If a picture is worth a thousand words, then Kevin Carter’s 1993 photograph of an emaciated child and a vulture in Sudan is worth a million—at least. This 1994 Pulitzer-prize winning photo is emotionally haunting. The detailed emphasis on the child, along with the comparison between child and vulture and the decision to include the surrounding environment, creates a photo that strikes a nerve with the viewer and…

Words 651 - Pages 3

PSYCH620 Team C Outline For Final Project 1 Essay

Outline for Final Paper Chisha Collins, Jessica Flamont, Terri Jackson, and Yanika Johnson PSY/620 Valarie Bradley-Holliday May 25, 2015 OUTLINE OF FINAL PAPER I. Introduction Religious beliefs and self-identity are among varied cultural factors that governments are expected to respect. Thus when setting national laws, governments should take into account diverse cultures to avoid violating the religious beliefs and self-identity of an individual, such as Muslim women. Muslim women…

Words 415 - Pages 2

English: Writing and Review Drafts / Strategy Essay

principles of organization, purpose, proofreading, graphics, and language structure, students will produce communications appropriate to the careers of their choice. COURSE GOALS: The course is designed to accomplish the following objectives: 1. Understand the necessity for listening to, reading, and following directions 2. Be presented with a grammar review 3. Be presented with the basics of business communications 4. Compose, format, and manage e-mail 5. Evaluate the quality…

Words 1402 - Pages 6

Essay on Teacher: Executive Compensation and Final Project

Final Project: Fortune 500 Company Analysis Dynamics of Business 1 Total 30% of Final Grade Draft Due 2/1 by midnight – 30 points or 3% of Final Grade Final Due 2/12 by midnight – 270 points or 27% of Final Grade FORMAT Project papers must be double-spaced, font size no smaller than 12 (this size), and edited for grammar and spelling. The final submitted exam must be a minimum of five (5) pages and no more than seven (7) pages in length. This does not include a title page, the organization…

Words 1325 - Pages 6

Project Management and Project Essay

the module spec. Aims • To prepare you for your final year project • To aid completion of the project proposal for the final year project • To research a topic area and plan a scheme of work • To structure a piece of academic/technical writing in the appropriate style • To think critically about what you will produce and evaluate your ability to deliver the work For your final year project you will be required to produce a proposal (it is not assessed)…

Words 659 - Pages 3

Essay Linux Vs Mac

Linux vs. Mac Project Plan [Note: Text enclosed in square brackets and displayed in blue italics (style=InfoBlue) is included to provide guidance to the author and should be deleted before publishing the document. Or, one can hide the text for viewing and/or printing because it is set as hidden-text.] 1 Introduction Our Team will compare the contrast between Linux and Mac Operating Systems to see which operating system outweighs the other in relations to the better system usage [Briefly describe…

Words 396 - Pages 2