In [27]:
# 1. Import pandas as pd and read the CFPB CSV into a dataframe assigned variable 'df'.
import pandas as pd
df = pd.read_csv('data/cfpb_complaints_with_fictitious_data.csv')
df
Out[27]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
0
3/24/2015
Credit card
NaN
Other
NaN
Received Capital One charge card offer XXXX. A...
NaN
Capital One
OH
440XX
...
Consent provided
Web
3/30/2015
Closed with explanation
Yes
No
1297939
332.63
217.18
130.22
1
3/23/2015
Debt collection
Other (i.e. phone, health club, etc.)
Improper contact or sharing of info
Contacted me after I asked not to
I do n't know how they got my cell number. I t...
NaN
CCS Financial Services, Inc.
AR
727XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296593
54.79
41.48
49.14
2
3/23/2015
Credit card
NaN
Rewards
NaN
I 'm a longtime member of Charter One Bank/RBS...
NaN
Citizens Financial Group, Inc.
MI
482XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
Yes
1296693
215.04
231.67
155.28
3
3/23/2015
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
After looking at my credit report, I saw a col...
Company chooses not to provide a public response
Experian
FL
331XX
...
Consent provided
Web
3/27/2015
Closed with non-monetary relief
Yes
No
1296955
3.31
6.30
4.59
4
3/23/2015
Debt collection
Payday loan
Improper contact or sharing of info
Talked to a third party about my debt
I received a call from a XXXX XXXX from XXXX @...
NaN
Big Picture Loans, LLC
SC
291XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296727
73.99
76.75
46.02
5
3/23/2015
Student loan
Non-federal student loan
Dealing with my lender or servicer
Having problems with customer service
Was not contacted 4 years later about some pri...
NaN
Oliphant Financial Corporation
IL
605XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1296773
15869.20
14414.94
12964.40
6
3/23/2015
Debt collection
Medical
Cont'd attempts collect debt not owed
Debt was paid
Collection Consultants is reporting a collecti...
NaN
Collection Consultants of California
CA
923XX
...
Consent provided
Web
4/30/2015
Closed with explanation
Yes
No
1296774
47.43
55.38
31.79
7
3/23/2015
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
I had my purse stolen in 2007. They never foun...
Company chooses not to provide a public response
Experian
ME
044XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296785
5.47
4.06
6.69
8
3/23/2015
Credit card
NaN
Other
NaN
I attempted to apply for a Discover Card Onlin...
NaN
Discover
MD
217XX
...
Consent provided
Web
3/23/2015
Closed with non-monetary relief
Yes
No
1295056
262.58
220.21
96.66
9
3/23/2015
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt resulted from identity theft
Continued attempts by XXXX XXXX XXXX to collec...
NaN
Stellar Recovery Inc.
CT
060XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1296777
84.60
81.44
65.64
10
3/23/2015
Student loan
Non-federal student loan
Can't repay my loan
Can't decrease my monthly payments
This is a continuation of a previous issue wit...
Company chooses not to provide a public response
Citibank
SC
296XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1295228
17690.44
25099.77
12962.02
11
3/23/2015
Debt collection
Mortgage
Communication tactics
Threatened to take legal action
Going through a divorce, my ex and I were unab...
NaN
Citibank
FL
330XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1295146
78.73
59.09
58.94
12
3/23/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I am assisted with my mortgage through an agen...
NaN
Ditech Financial LLC
GA
300XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
Yes
1296823
185482.51
159366.50
234193.94
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296831
101340.54
182761.24
122579.47
14
3/23/2015
Debt collection
I do not know
Disclosure verification of debt
Not given enough info to verify debt
I recieved a notice from Midland Credit Manage...
NaN
Encore Capital Group
TX
787XX
...
Consent provided
Web
3/23/2015
Closed with non-monetary relief
Yes
No
1295409
81.47
45.18
45.77
15
3/23/2015
Credit card
NaN
Late fee
NaN
XXXX Card services was bought out by Capital O...
NaN
Capital One
MI
488XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
No
1296880
240.76
162.92
174.56
16
3/23/2015
Credit card
NaN
Billing disputes
NaN
I was reported late by Discover Card to the re...
NaN
Discover
OK
741XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296890
258.53
232.54
194.73
17
3/24/2015
Credit card
NaN
Credit line increase/decrease
NaN
XXXX i receive an email from citibank regardin...
Company chooses not to provide a public response
Citibank
NV
891XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1299216
186.52
278.21
288.13
18
3/24/2015
Debt collection
Other (i.e. phone, health club, etc.)
False statements or representation
Attempted to collect wrong amount
I agreed to a settlement arrangement on a acco...
NaN
MS Services LLC
TN
381XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297589
56.39
62.17
37.96
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103381.81
186432.77
110905.24
20
3/24/2015
Payday loan
Payday loan
Can't stop charges to bank account
Can't stop charges to bank account
I took out a Loan from Cash Central XXXX, Al f...
Company chooses not to provide a public response
Community Choice Financial, Inc.
AL
351XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1299258
6.02
25.44
19.35
21
3/24/2015
Debt collection
Credit card
Cont'd attempts collect debt not owed
Debt was discharged in bankruptcy
I filed ChapterXXXX bankruptcy on my accounts ...
NaN
JPMorgan Chase & Co.
NE
681XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297609
72.04
64.01
42.37
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297626
219860.35
153908.22
99746.42
23
3/24/2015
Bank account or service
Checking account
Using a debit or ATM card
NaN
I 'm no longer an account holder of SunTrust. ...
Company chooses not to provide a public response
SunTrust Banks, Inc.
FL
334XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297629
88.66
70.81
53.64
24
3/24/2015
Debt collection
Credit card
Communication tactics
Frequent or repeated calls
I 've been receiving numerous robocalls, hang-...
NaN
Amex
CT
064XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297377
74.58
63.52
34.51
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297644
153377.06
169317.86
79792.59
26
3/24/2015
Credit reporting
NaN
Incorrect information on credit report
Account status
Please investigate the practices of Experian. ...
Company chooses not to provide a public response
Experian
CA
900XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297500
3.31
1.29
0.34
27
3/24/2015
Debt collection
I do not know
Disclosure verification of debt
Not disclosed as an attempt to collect
Portfolio Recovery does not disclose who is ca...
NaN
Portfolio Recovery Associates, Inc.
WA
980XX
...
Consent provided
Web
3/25/2015
Closed with non-monetary relief
Yes
No
1297662
70.24
68.01
45.16
28
3/24/2015
Bank account or service
Checking account
Account opening, closing, or management
NaN
After banking with Citibank for over 3 years, ...
NaN
Citibank
TX
797XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297676
86.24
62.34
44.37
29
3/24/2015
Debt collection
Auto
False statements or representation
Attempted to collect wrong amount
I am a victim of a parked debt bought by a deb...
NaN
Accelerated Financial Solutions, LLC
NV
891XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297316
60.50
67.60
45.81
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125650
10/27/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My original mortgage was with XXXX. In XXXX 20...
NaN
Nationstar Mortgage
NY
103XX
...
Consent provided
Web
10/27/2016
Closed with explanation
Yes
No
2182081
236687.68
221160.59
64958.93
125651
9/29/2016
Consumer Loan
Installment loan
Problems when you are unable to pay
NaN
Excessive daily calls.
NaN
RFNA, LP
GA
301XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2139621
5753.08
3347.99
4810.15
125652
10/18/2016
Bank account or service
Checking account
Problems caused by my funds being low
NaN
My checking account was set up to decline any ...
NaN
Commerce Bank
MO
630XX
...
Consent provided
Web
10/18/2016
Closed with explanation
Yes
No
2165678
73.34
59.51
49.38
125653
12/12/2016
Debt collection
Medical
Cont'd attempts collect debt not owed
Debt is not mine
I recently reviewed my credit reports and I ha...
Company believes it acted appropriately as aut...
ATG Credit, LLC
IL
605XX
...
Consent provided
Web
12/12/2016
Closed with explanation
Yes
NaN
2245422
83.07
76.03
47.62
125654
11/18/2016
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
XXXX XXXX has had complaints filed against him...
NaN
Integrity First Financial Group, Inc.
MO
631XX
...
Consent provided
Web
11/18/2016
Closed with explanation
No
NaN
2215900
74632.68
57102.99
182860.61
125655
12/2/2016
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt was paid
This Collection Agency keeps sending me and my...
Company believes it acted appropriately as aut...
Duncan Solutions, lnc.
CA
941XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2233235
61.07
55.34
34.73
125656
11/4/2016
Student loan
Non-federal student loan
Dealing with my lender or servicer
Keep getting calls about my loan
This is the third time I am writing you about ...
Company believes it acted appropriately as aut...
Capital Management Services, LP
GA
302XX
...
Consent provided
Web
11/7/2016
Closed with explanation
Yes
No
2197243
20249.89
9145.76
6248.93
125657
11/18/2016
Debt collection
Medical
Disclosure verification of debt
Right to dispute notice not received
I receive a call Capio Partners being disrespe...
NaN
Capio Partners, LLC
FL
327XX
...
Consent provided
Web
11/18/2016
Closed with non-monetary relief
Yes
NaN
2215200
82.64
57.09
57.02
125658
12/12/2016
Credit card
NaN
Identity theft / Fraud / Embezzlement
NaN
SYNCB/GAP ACCOUNT NUMBERs : XXXX XX/XX/XXXX XX...
Company has responded to the consumer and the ...
Synchrony Financial
FL
329XX
...
Consent provided
Web
12/12/2016
Closed with explanation
Yes
Yes
2244918
220.97
276.09
91.89
125659
11/9/2016
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt is not mine
XXXX agent miss represent there service and pa...
NaN
Afni, Inc.
CA
945XX
...
Consent provided
Web
11/9/2016
Closed with explanation
Yes
No
2201273
59.04
60.44
33.40
125660
12/13/2016
Bank account or service
Checking account
Account opening, closing, or management
NaN
I applied for a joint checking account with my...
Company believes it acted appropriately as aut...
USAA Savings
IL
606XX
...
Consent provided
Web
12/13/2016
Closed with non-monetary relief
Yes
NaN
2247284
78.73
68.11
46.51
125661
10/4/2016
Debt collection
Medical
Disclosure verification of debt
Not given enough info to verify debt
I contacted this creditor on their secure logi...
NaN
The Law Offices of Mitchell D. Bluhm & Associates
FL
327XX
...
Consent provided
Web
11/14/2016
Closed with non-monetary relief
Yes
No
2145608
83.07
69.67
51.44
125662
12/13/2016
Credit card
NaN
Rewards
NaN
I signed up a new Citi XXXX XXXX credit card o...
Company has responded to the consumer and the ...
Citibank
NY
115XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
Yes
2248594
258.87
189.00
129.45
125663
11/6/2016
Student loan
Federal student loan servicing
Dealing with my lender or servicer
Received bad information about my loan
I have a unsubsidized Stafford loan from colle...
NaN
Nelnet
GA
306XX
...
Consent provided
Web
11/6/2016
Closed with explanation
Yes
No
2198041
16803.25
24457.31
20028.10
125664
11/12/2016
Credit reporting
NaN
Incorrect information on credit report
Account status
This company XXXX just bought my loan in the p...
Company has responded to the consumer and the ...
Experian
GA
300XX
...
Consent provided
Web
11/12/2016
Closed with explanation
Yes
No
2205209
3.41
4.04
0.90
125665
11/10/2016
Credit reporting
NaN
Incorrect information on credit report
Personal information
I have incorrect info on my credit report with...
Company has responded to the consumer and the ...
TransUnion Intermediate Holdings, Inc.
OK
730XX
...
Consent provided
Web
11/10/2016
Closed with explanation
Yes
No
2203177
7.37
5.44
2.49
125666
12/14/2016
Credit card
NaN
Other
NaN
Since the last few months I 've been unable to...
Company has responded to the consumer and the ...
Bank of America
CA
941XX
...
Consent provided
Web
12/14/2016
Closed with explanation
Yes
NaN
2247267
214.31
205.83
225.27
125667
12/13/2016
Bank account or service
Checking account
Account opening, closing, or management
NaN
I applied to join XXXX XXXX XXXX for a home lo...
Company has responded to the consumer and the ...
Fidelity National Information Services, Inc. (...
GA
301XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248753
73.33
70.85
44.17
125668
11/3/2016
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
There was fraud on my account and does not bel...
NaN
Factual Data
KY
405XX
...
Consent provided
Web
11/3/2016
Closed with explanation
Yes
No
2193913
2.40
2.11
5.82
125669
11/19/2016
Debt collection
Credit card
Disclosure verification of debt
Not given enough info to verify debt
I have disputed this Capital One Credit card c...
NaN
Capital One
IL
604XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
NaN
2216039
87.67
54.43
65.87
125670
11/18/2016
Debt collection
I do not know
Cont'd attempts collect debt not owed
Debt is not mine
I received an alert from credit monitoring ser...
NaN
Midwest Recovery Systems
SC
291XX
...
Consent provided
Web
11/18/2016
Untimely response
No
NaN
2213687
79.67
56.16
39.76
125671
11/16/2016
Debt collection
I do not know
Improper contact or sharing of info
Talked to a third party about my debt
First Source Adv. is contacting family members...
Company believes it acted appropriately as aut...
FirstSource Advantage, LLC
PA
164XX
...
Consent provided
Web
11/16/2016
Closed with explanation
Yes
No
2210820
85.51
73.63
27.10
125672
11/19/2016
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
This is a complaint against the Bureau of Equi...
NaN
Equifax
FL
331XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
NaN
2215661
7.25
2.12
0.92
125673
9/27/2016
Bank account or service
Checking account
Using a debit or ATM card
NaN
I do n't believe I had this account with bank ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
...
Consent provided
Web
9/30/2016
Closed with explanation
Yes
No
2133648
69.74
67.79
41.98
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247724
136798.52
114342.28
106343.36
125675
10/21/2016
Consumer Loan
Vehicle lease
Managing the loan or lease
NaN
I leased a vehicle from ALLY, paying all payme...
Company has responded to the consumer and the ...
Ally Financial Inc.
VA
201XX
...
Consent provided
Web
10/21/2016
Closed with explanation
Yes
No
2170435
4126.85
4797.82
1931.60
125676
11/18/2016
Student loan
Non-federal student loan
Can't repay my loan
Can't get flexible payment options
Today my lender increased my private student l...
NaN
AES/PHEAA
NY
130XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2215331
24212.35
24333.23
5957.27
125677
11/4/2016
Bank account or service
Other bank product/service
Account opening, closing, or management
NaN
In XXXX 2016, my computer crashed and deleted ...
Company has responded to the consumer and the ...
BB&T Financial
PA
191XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2194728
75.45
69.03
44.28
125678
11/4/2016
Bank account or service
Checking account
Deposits and withdrawals
NaN
I opened a checking account with Simple Bank (...
NaN
BBVA Compass
VA
223XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2196938
70.11
63.83
35.03
125679
11/9/2016
Credit reporting
NaN
Credit reporting company's investigation
Inadequate help over the phone
I have been contacting Transunion for over 2 m...
Company has responded to the consumer and the ...
TransUnion Intermediate Holdings, Inc.
IL
600XX
...
Consent provided
Web
11/9/2016
Closed with explanation
Yes
No
2202865
4.17
4.67
-0.18
125680 rows × 21 columns
In [28]:
# 2. Select a single column via bracket notation []. What is the type of the column?
type(df['Product']) # df.Product
Out[28]:
pandas.core.series.Series
In [29]:
# 3. Select two or more columns using double bracket notation (list inside of brackets).
df[['Product', 'Sub-product']].head(5)
Out[29]:
Product
Sub-product
0
Credit card
NaN
1
Debt collection
Other (i.e. phone, health club, etc.)
2
Credit card
NaN
3
Credit reporting
NaN
4
Debt collection
Payday loan
In [30]:
# 4. Use the dataframe's loc[] attribute to get the first row of the df by index.
df.loc[0]
Out[30]:
Date received 3/24/2015
Product Credit card
Sub-product NaN
Issue Other
Sub-issue NaN
Consumer complaint narrative Received Capital One charge card offer XXXX. A...
Company public response NaN
Company Capital One
State OH
ZIP code 440XX
Tags NaN
Consumer consent provided? Consent provided
Submitted via Web
Date sent to company 3/30/2015
Company response to consumer Closed with explanation
Timely response? Yes
Consumer disputed? No
Complaint ID 1297939
Consumer Claim 332.63
Company Offer 217.18
Amount Received 130.22
Name: 0, dtype: object
In [31]:
# 5. Use iloc[] to get the last row of the dataframe by number.
df.iloc[-1]
Out[31]:
Date received 11/9/2016
Product Credit reporting
Sub-product NaN
Issue Credit reporting company's investigation
Sub-issue Inadequate help over the phone
Consumer complaint narrative I have been contacting Transunion for over 2 m...
Company public response Company has responded to the consumer and the ...
Company TransUnion Intermediate Holdings, Inc.
State IL
ZIP code 600XX
Tags NaN
Consumer consent provided? Consent provided
Submitted via Web
Date sent to company 11/9/2016
Company response to consumer Closed with explanation
Timely response? Yes
Consumer disputed? No
Complaint ID 2202865
Consumer Claim 4.17
Company Offer 4.67
Amount Received -0.18
Name: 125679, dtype: object
In [32]:
# 6. # Use df[] notation to get a True/False series for 'Product == Mortgage'. Assign to 'mask', then show.
mask = df['Product'] == 'Mortgage'
df[mask]
Out[32]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
12
3/23/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I am assisted with my mortgage through an agen...
NaN
Ditech Financial LLC
GA
300XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
Yes
1296823
185482.51
159366.50
234193.94
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296831
101340.54
182761.24
122579.47
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103381.81
186432.77
110905.24
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297626
219860.35
153908.22
99746.42
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297644
153377.06
169317.86
79792.59
33
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1299207
105940.81
123409.96
89578.55
43
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was emailed that my online account had been ...
NaN
Wells Fargo & Company
MT
598XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297874
234463.04
133847.95
104833.17
44
3/19/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX was submitted XX/XX/XXXX. At the time I s...
NaN
Rushmore Loan Management Services LLC
CA
956XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1292137
177586.11
57294.34
89278.77
46
3/19/2015
Mortgage
Reverse mortgage
Application, originator, mortgage broker
NaN
I am very disappointed that the CFPB did not h...
NaN
CIT Bank National Association
NJ
080XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290543
71574.50
24275.87
65055.48
47
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We fell behind in our payments back in 2014 fo...
NaN
Nationstar Mortgage
VA
230XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292139
61228.78
80961.10
22089.39
48
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a Successor - in -interest to a property ...
NaN
Nationstar Mortgage
CA
925XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290545
180004.43
214540.82
29346.45
49
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am writing this letter because my mortgage a...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
NJ
080XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292065
136855.25
-7012.71
70034.66
50
3/19/2015
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I had a mortgage with from XXXX of XXXX to XXX...
NaN
Citizens Financial Group, Inc.
MA
021XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290564
110769.16
85293.98
140950.99
57
3/19/2015
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I made a payment on a {$69000.00} loan of $ XX...
NaN
Specialized Loan Servicing LLC
NJ
074XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290644
171647.18
167269.02
115595.66
58
3/24/2015
Mortgage
Other mortgage
Settlement process and costs
NaN
I applied for a loan modification with Suntrus...
Company chooses not to provide a public response
SunTrust Banks, Inc.
CO
804XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1298042
91360.36
161713.50
17758.65
64
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was {$48.00} behind on our mortgage because ...
NaN
Ditech Financial LLC
MA
020XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
Yes
1298116
186816.79
228400.77
134987.03
69
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I have been trying to get an audit of my accou...
NaN
Citibank
MD
207XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290765
174171.64
79753.02
101711.41
72
3/27/2015
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We had a Line of Credit with US Bank that was ...
Company chooses not to provide a public response
U.S. Bancorp
CO
801XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
No
1304648
183467.48
130950.91
141618.46
81
3/27/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Ocwen financial services claims simultaneously...
NaN
Ocwen
MA
017XX
...
Consent provided
Web
4/1/2015
Closed with explanation
Yes
No
1304057
94292.76
136124.02
123227.27
87
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I had a mortgage with XXXX XXXX XXXX from XXXX...
NaN
Nationstar Mortgage
TX
775XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290871
213279.65
157675.58
79534.17
88
3/24/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029.12
74100.13
40478.75
101
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My wife and I just went through 7 months of ap...
Company chooses not to provide a public response
U.S. Bancorp
KS
664XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
Yes
1304971
182034.47
114693.36
67510.76
102
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We have been working or a Short Sale for Selec...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
FL
333XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
No
1304692
150718.63
165691.38
136517.37
104
3/19/2015
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
I got behind in payments and worked with B of ...
Company chooses not to provide a public response
Bank of America
CA
926XX
...
Consent provided
Web
3/19/2015
Closed with monetary relief
Yes
No
1291084
127616.28
66064.08
77037.93
107
3/24/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Yesterday, I called my mortgage company, Ocwen...
NaN
Ocwen
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1298656
150701.05
167926.46
53600.10
121
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Wells Fargo Mortgage began foreclosure action ...
NaN
Wells Fargo & Company
AZ
853XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1291277
166114.09
81243.71
26314.16
122
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Caliber Home loans has claimed to have made pa...
NaN
Caliber Home Loans, Inc
IN
463XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1298770
198868.56
127222.11
104428.20
127
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Our Mortgage was sold to Carrington Mortgage S...
NaN
Carrington Mortgage Holdings, LLC.
TX
755XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292613
249757.98
136786.81
71294.46
131
3/27/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
...
Consent provided
Web
4/6/2015
Closed with explanation
Yes
Yes
1305325
169979.86
91967.15
12702.47
139
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We are a victim of Ocwen mortgage and their fr...
NaN
Ocwen
KS
666XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1292075
200977.97
208273.54
140895.90
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125541
10/2/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get approved for a loan modific...
Company has responded to the consumer and the ...
Wells Fargo & Company
CA
945XX
...
Consent provided
Web
10/5/2016
Closed with explanation
Yes
No
2141468
121095.06
7620.71
-1882.12
125543
12/13/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have asked Nationstar for assistance for a f...
Company believes it acted appropriately as aut...
Nationstar Mortgage
CA
920XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247658
202258.79
123664.33
92247.20
125546
12/13/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
In XX/XX/2016, I received a solicitation from ...
Company has responded to the consumer and the ...
Freedom Mortgage
SC
295XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248476
141880.00
148011.31
-15018.41
125553
6/30/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX Immediate concern: Stop the forec...
Company chooses not to provide a public response
Wells Fargo & Company
CA
943XX
...
Consent provided
Web
6/30/2015
Closed with explanation
Yes
No
1444123
152880.49
102193.95
173177.07
125557
11/16/2016
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I was advised by XXXX XXXX at omni mortgage th...
NaN
OMNI MORTGAGE CORPORATION
NY
117XX
...
Consent provided
Web
11/16/2016
Closed with explanation
No
NaN
2209300
147430.37
114010.33
47345.30
125564
10/26/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am so devastated and so very disappointed wi...
Company believes it acted appropriately as aut...
North Dakota Housing Finance Agency
ND
586XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
No
2180679
177723.48
216986.74
125397.78
125582
12/13/2016
Mortgage
VA mortgage
Settlement process and costs
NaN
I contracted with USAA Federal Savings Bank to...
Company believes complaint is the result of an...
USAA Savings
GA
303XX
...
Consent provided
Web
12/13/2016
Closed with monetary relief
Yes
NaN
2247493
114277.49
158659.18
85375.31
125583
10/7/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Since the purchase of my house throughout the ...
NaN
Nationstar Mortgage
UT
846XX
...
Consent provided
Web
10/7/2016
Closed with explanation
Yes
No
2152061
129114.44
98844.55
56791.42
125585
12/10/2016
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
Over a period a six months, my XXXX mother app...
Company has responded to the consumer and the ...
BB&T Financial
TX
752XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2244513
65426.99
140152.91
99335.38
125591
12/9/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
RE : Complaint # XXXX Subject : XXXX / Foreclo...
Company believes it acted appropriately as aut...
Shellpoint Partners, LLC
CA
949XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
Yes
2243820
169197.05
66552.62
85769.96
125593
11/11/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get a principal reduction for m...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
302XX
...
Consent provided
Web
11/11/2016
Closed with explanation
Yes
No
2205208
237211.09
47003.87
190013.21
125596
11/3/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
US Bank has not released the lien and sent pro...
Company has responded to the consumer and the ...
U.S. Bancorp
FL
329XX
...
Consent provided
Web
11/3/2016
Closed with explanation
Yes
No
2192518
97710.88
64392.79
74558.88
125601
10/19/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
I filed a rescission to my mortgage lender yea...
NaN
Ocwen
NJ
078XX
...
Consent provided
Web
11/2/2016
Closed with explanation
Yes
No
2169166
140341.51
138125.27
83521.07
125610
12/13/2016
Mortgage
FHA mortgage
Credit decision / Underwriting
NaN
Sales Manager keeps asking for same info repea...
Company believes it acted appropriately as aut...
Nations Lending Coporation
OH
430XX
...
Consent provided
Web
12/14/2016
Closed with explanation
Yes
NaN
2248733
117591.02
103684.51
43800.98
125616
11/19/2016
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
OWCEN made an error on my XXXX XXXX, 2016 and ...
NaN
Ocwen
NY
102XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
Yes
2214614
142775.89
191873.76
101699.37
125618
9/23/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
My loan was transferred to DiTech for servicin...
Company believes complaint represents an oppor...
Ditech Financial LLC
PA
190XX
...
Consent provided
Web
9/23/2016
Closed with explanation
Yes
No
2128559
182275.93
67170.52
92324.06
125619
11/18/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I just refinanced my mortgage to a 15 yr fixed...
NaN
Arvest Bank
IN
463XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2214834
170016.45
65751.65
1991.28
125620
10/10/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
Monday, XX/XX/XXXX " From : XXXX XXXX XXXX XXX...
Company has responded to the consumer and the ...
Round Point Mortgage
GA
300XX
...
Consent provided
Web
10/14/2016
Closed with explanation
Yes
No
2153211
61244.98
99590.82
99820.75
125621
10/31/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My mortgage company ( Ditech ) changed their c...
Company believes complaint represents an oppor...
Ditech Financial LLC
TX
750XX
...
Consent provided
Web
11/2/2016
Closed with explanation
Yes
No
2186239
194123.95
63202.10
47589.77
125622
11/2/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Please see CFPB case # XXXX - I am submitting ...
NaN
Dovenmuehle Mortgage Inc.
PA
191XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2191249
143222.59
16049.53
112755.79
125623
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
SLS purchased the servicing of my mortgage fro...
Company has responded to the consumer and the ...
Specialized Loan Servicing LLC
NY
100XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248373
161307.06
119452.98
56043.00
125632
11/18/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We had a loan modification done with Nationsta...
NaN
Nationstar Mortgage
TN
377XX
...
Consent provided
Web
11/18/2016
Closed
Yes
NaN
2215986
134966.28
163581.65
59377.15
125634
10/26/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have doubled my income in the last 2 months ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
...
Consent provided
Web
10/26/2016
Closed with explanation
Yes
No
2177009
85949.83
165111.24
84770.01
125636
11/5/2016
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
Nova financial, you are better off finding ano...
NaN
NOVA Financial & Investment Corporation
AZ
856XX
...
Consent provided
Web
11/5/2016
Closed with explanation
Yes
No
2197004
236151.02
119853.39
123155.57
125638
11/18/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have been working with my lender for a loan ...
NaN
Caliber Home Loans, Inc
CA
925XX
...
Consent provided
Web
11/18/2016
Closed
Yes
NaN
2216156
126366.03
67134.38
133643.76
125645
11/18/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I obtain a mortgage loan from Finance of Ameri...
NaN
Finance of America Mortgage LLC
NJ
083XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2215655
185077.71
92015.61
69618.41
125647
9/20/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have had my mortgage loan through Bank of Am...
Company has responded to the consumer and the ...
Bank of America
WI
531XX
...
Consent provided
Web
9/20/2016
Closed with monetary relief
Yes
No
2122648
207892.82
180364.18
35887.38
125650
10/27/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My original mortgage was with XXXX. In XXXX 20...
NaN
Nationstar Mortgage
NY
103XX
...
Consent provided
Web
10/27/2016
Closed with explanation
Yes
No
2182081
236687.68
221160.59
64958.93
125654
11/18/2016
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
XXXX XXXX has had complaints filed against him...
NaN
Integrity First Financial Group, Inc.
MO
631XX
...
Consent provided
Web
11/18/2016
Closed with explanation
No
NaN
2215900
74632.68
57102.99
182860.61
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247724
136798.52
114342.28
106343.36
26811 rows × 21 columns
In [33]:
# 7. Use boolean indexing by putting the mask inside df[] notation to filter out everything but mortgage.
df[~mask]
Out[33]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
0
3/24/2015
Credit card
NaN
Other
NaN
Received Capital One charge card offer XXXX. A...
NaN
Capital One
OH
440XX
...
Consent provided
Web
3/30/2015
Closed with explanation
Yes
No
1297939
332.63
217.18
130.22
1
3/23/2015
Debt collection
Other (i.e. phone, health club, etc.)
Improper contact or sharing of info
Contacted me after I asked not to
I do n't know how they got my cell number. I t...
NaN
CCS Financial Services, Inc.
AR
727XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296593
54.79
41.48
49.14
2
3/23/2015
Credit card
NaN
Rewards
NaN
I 'm a longtime member of Charter One Bank/RBS...
NaN
Citizens Financial Group, Inc.
MI
482XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
Yes
1296693
215.04
231.67
155.28
3
3/23/2015
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
After looking at my credit report, I saw a col...
Company chooses not to provide a public response
Experian
FL
331XX
...
Consent provided
Web
3/27/2015
Closed with non-monetary relief
Yes
No
1296955
3.31
6.30
4.59
4
3/23/2015
Debt collection
Payday loan
Improper contact or sharing of info
Talked to a third party about my debt
I received a call from a XXXX XXXX from XXXX @...
NaN
Big Picture Loans, LLC
SC
291XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296727
73.99
76.75
46.02
5
3/23/2015
Student loan
Non-federal student loan
Dealing with my lender or servicer
Having problems with customer service
Was not contacted 4 years later about some pri...
NaN
Oliphant Financial Corporation
IL
605XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1296773
15869.20
14414.94
12964.40
6
3/23/2015
Debt collection
Medical
Cont'd attempts collect debt not owed
Debt was paid
Collection Consultants is reporting a collecti...
NaN
Collection Consultants of California
CA
923XX
...
Consent provided
Web
4/30/2015
Closed with explanation
Yes
No
1296774
47.43
55.38
31.79
7
3/23/2015
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
I had my purse stolen in 2007. They never foun...
Company chooses not to provide a public response
Experian
ME
044XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296785
5.47
4.06
6.69
8
3/23/2015
Credit card
NaN
Other
NaN
I attempted to apply for a Discover Card Onlin...
NaN
Discover
MD
217XX
...
Consent provided
Web
3/23/2015
Closed with non-monetary relief
Yes
No
1295056
262.58
220.21
96.66
9
3/23/2015
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt resulted from identity theft
Continued attempts by XXXX XXXX XXXX to collec...
NaN
Stellar Recovery Inc.
CT
060XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1296777
84.60
81.44
65.64
10
3/23/2015
Student loan
Non-federal student loan
Can't repay my loan
Can't decrease my monthly payments
This is a continuation of a previous issue wit...
Company chooses not to provide a public response
Citibank
SC
296XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1295228
17690.44
25099.77
12962.02
11
3/23/2015
Debt collection
Mortgage
Communication tactics
Threatened to take legal action
Going through a divorce, my ex and I were unab...
NaN
Citibank
FL
330XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1295146
78.73
59.09
58.94
14
3/23/2015
Debt collection
I do not know
Disclosure verification of debt
Not given enough info to verify debt
I recieved a notice from Midland Credit Manage...
NaN
Encore Capital Group
TX
787XX
...
Consent provided
Web
3/23/2015
Closed with non-monetary relief
Yes
No
1295409
81.47
45.18
45.77
15
3/23/2015
Credit card
NaN
Late fee
NaN
XXXX Card services was bought out by Capital O...
NaN
Capital One
MI
488XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
No
1296880
240.76
162.92
174.56
16
3/23/2015
Credit card
NaN
Billing disputes
NaN
I was reported late by Discover Card to the re...
NaN
Discover
OK
741XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296890
258.53
232.54
194.73
17
3/24/2015
Credit card
NaN
Credit line increase/decrease
NaN
XXXX i receive an email from citibank regardin...
Company chooses not to provide a public response
Citibank
NV
891XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1299216
186.52
278.21
288.13
18
3/24/2015
Debt collection
Other (i.e. phone, health club, etc.)
False statements or representation
Attempted to collect wrong amount
I agreed to a settlement arrangement on a acco...
NaN
MS Services LLC
TN
381XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297589
56.39
62.17
37.96
20
3/24/2015
Payday loan
Payday loan
Can't stop charges to bank account
Can't stop charges to bank account
I took out a Loan from Cash Central XXXX, Al f...
Company chooses not to provide a public response
Community Choice Financial, Inc.
AL
351XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1299258
6.02
25.44
19.35
21
3/24/2015
Debt collection
Credit card
Cont'd attempts collect debt not owed
Debt was discharged in bankruptcy
I filed ChapterXXXX bankruptcy on my accounts ...
NaN
JPMorgan Chase & Co.
NE
681XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297609
72.04
64.01
42.37
23
3/24/2015
Bank account or service
Checking account
Using a debit or ATM card
NaN
I 'm no longer an account holder of SunTrust. ...
Company chooses not to provide a public response
SunTrust Banks, Inc.
FL
334XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297629
88.66
70.81
53.64
24
3/24/2015
Debt collection
Credit card
Communication tactics
Frequent or repeated calls
I 've been receiving numerous robocalls, hang-...
NaN
Amex
CT
064XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297377
74.58
63.52
34.51
26
3/24/2015
Credit reporting
NaN
Incorrect information on credit report
Account status
Please investigate the practices of Experian. ...
Company chooses not to provide a public response
Experian
CA
900XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297500
3.31
1.29
0.34
27
3/24/2015
Debt collection
I do not know
Disclosure verification of debt
Not disclosed as an attempt to collect
Portfolio Recovery does not disclose who is ca...
NaN
Portfolio Recovery Associates, Inc.
WA
980XX
...
Consent provided
Web
3/25/2015
Closed with non-monetary relief
Yes
No
1297662
70.24
68.01
45.16
28
3/24/2015
Bank account or service
Checking account
Account opening, closing, or management
NaN
After banking with Citibank for over 3 years, ...
NaN
Citibank
TX
797XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297676
86.24
62.34
44.37
29
3/24/2015
Debt collection
Auto
False statements or representation
Attempted to collect wrong amount
I am a victim of a parked debt bought by a deb...
NaN
Accelerated Financial Solutions, LLC
NV
891XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297316
60.50
67.60
45.81
30
3/24/2015
Credit card
NaN
Identity theft / Fraud / Embezzlement
NaN
I have been a XXXX XXXX XXXX for 4.5 years and...
Company chooses not to provide a public response
Barclays PLC
CA
940XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297327
312.17
213.44
174.58
31
3/24/2015
Credit reporting
NaN
Credit reporting company's investigation
No notice of investigation status/result
I noticed an incorrect item when I received fr...
NaN
TransUnion Intermediate Holdings, Inc.
HI
968XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1297382
5.90
1.64
2.91
32
3/24/2015
Debt collection
Medical
Cont'd attempts collect debt not owed
Debt is not mine
I find this medical debt reported on my credit...
Company chooses not to provide a public response
Healthcare Collections-I, LLC
AZ
860XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297685
78.64
65.67
51.62
34
3/24/2015
Debt collection
Other (i.e. phone, health club, etc.)
False statements or representation
Attempted to collect wrong amount
I received a letter from Penn Credit Collectio...
Company believes it acted appropriately as aut...
Penn Credit Corporation
FL
330XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297371
77.42
56.55
35.24
35
3/24/2015
Debt collection
I do not know
Communication tactics
Frequent or repeated calls
This gentleman called me and asked for persona...
Company believes it acted appropriately as aut...
Client Services, Inc.
NC
274XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297758
49.66
74.74
53.90
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125646
12/13/2016
Debt collection
Other (i.e. phone, health club, etc.)
Disclosure verification of debt
Not given enough info to verify debt
I am wanting to make sure that this debt is be...
Company believes it acted appropriately as aut...
ERC
TX
785XX
...
Consent provided
Web
12/13/2016
Closed
Yes
NaN
2246957
73.73
57.40
56.63
125648
12/13/2016
Credit card
NaN
Billing disputes
NaN
We made a furniture purchase in the amount of ...
Company has responded to the consumer and the ...
Synchrony Financial
SC
294XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247898
245.66
160.68
184.44
125649
11/16/2016
Credit reporting
NaN
Credit reporting company's investigation
Problem with statement of dispute
The investigation told me about debt collector...
NaN
Equifax
IL
600XX
...
Consent provided
Web
11/16/2016
Closed with explanation
Yes
No
2209167
5.39
4.21
5.39
125651
9/29/2016
Consumer Loan
Installment loan
Problems when you are unable to pay
NaN
Excessive daily calls.
NaN
RFNA, LP
GA
301XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2139621
5753.08
3347.99
4810.15
125652
10/18/2016
Bank account or service
Checking account
Problems caused by my funds being low
NaN
My checking account was set up to decline any ...
NaN
Commerce Bank
MO
630XX
...
Consent provided
Web
10/18/2016
Closed with explanation
Yes
No
2165678
73.34
59.51
49.38
125653
12/12/2016
Debt collection
Medical
Cont'd attempts collect debt not owed
Debt is not mine
I recently reviewed my credit reports and I ha...
Company believes it acted appropriately as aut...
ATG Credit, LLC
IL
605XX
...
Consent provided
Web
12/12/2016
Closed with explanation
Yes
NaN
2245422
83.07
76.03
47.62
125655
12/2/2016
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt was paid
This Collection Agency keeps sending me and my...
Company believes it acted appropriately as aut...
Duncan Solutions, lnc.
CA
941XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2233235
61.07
55.34
34.73
125656
11/4/2016
Student loan
Non-federal student loan
Dealing with my lender or servicer
Keep getting calls about my loan
This is the third time I am writing you about ...
Company believes it acted appropriately as aut...
Capital Management Services, LP
GA
302XX
...
Consent provided
Web
11/7/2016
Closed with explanation
Yes
No
2197243
20249.89
9145.76
6248.93
125657
11/18/2016
Debt collection
Medical
Disclosure verification of debt
Right to dispute notice not received
I receive a call Capio Partners being disrespe...
NaN
Capio Partners, LLC
FL
327XX
...
Consent provided
Web
11/18/2016
Closed with non-monetary relief
Yes
NaN
2215200
82.64
57.09
57.02
125658
12/12/2016
Credit card
NaN
Identity theft / Fraud / Embezzlement
NaN
SYNCB/GAP ACCOUNT NUMBERs : XXXX XX/XX/XXXX XX...
Company has responded to the consumer and the ...
Synchrony Financial
FL
329XX
...
Consent provided
Web
12/12/2016
Closed with explanation
Yes
Yes
2244918
220.97
276.09
91.89
125659
11/9/2016
Debt collection
Other (i.e. phone, health club, etc.)
Cont'd attempts collect debt not owed
Debt is not mine
XXXX agent miss represent there service and pa...
NaN
Afni, Inc.
CA
945XX
...
Consent provided
Web
11/9/2016
Closed with explanation
Yes
No
2201273
59.04
60.44
33.40
125660
12/13/2016
Bank account or service
Checking account
Account opening, closing, or management
NaN
I applied for a joint checking account with my...
Company believes it acted appropriately as aut...
USAA Savings
IL
606XX
...
Consent provided
Web
12/13/2016
Closed with non-monetary relief
Yes
NaN
2247284
78.73
68.11
46.51
125661
10/4/2016
Debt collection
Medical
Disclosure verification of debt
Not given enough info to verify debt
I contacted this creditor on their secure logi...
NaN
The Law Offices of Mitchell D. Bluhm & Associates
FL
327XX
...
Consent provided
Web
11/14/2016
Closed with non-monetary relief
Yes
No
2145608
83.07
69.67
51.44
125662
12/13/2016
Credit card
NaN
Rewards
NaN
I signed up a new Citi XXXX XXXX credit card o...
Company has responded to the consumer and the ...
Citibank
NY
115XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
Yes
2248594
258.87
189.00
129.45
125663
11/6/2016
Student loan
Federal student loan servicing
Dealing with my lender or servicer
Received bad information about my loan
I have a unsubsidized Stafford loan from colle...
NaN
Nelnet
GA
306XX
...
Consent provided
Web
11/6/2016
Closed with explanation
Yes
No
2198041
16803.25
24457.31
20028.10
125664
11/12/2016
Credit reporting
NaN
Incorrect information on credit report
Account status
This company XXXX just bought my loan in the p...
Company has responded to the consumer and the ...
Experian
GA
300XX
...
Consent provided
Web
11/12/2016
Closed with explanation
Yes
No
2205209
3.41
4.04
0.90
125665
11/10/2016
Credit reporting
NaN
Incorrect information on credit report
Personal information
I have incorrect info on my credit report with...
Company has responded to the consumer and the ...
TransUnion Intermediate Holdings, Inc.
OK
730XX
...
Consent provided
Web
11/10/2016
Closed with explanation
Yes
No
2203177
7.37
5.44
2.49
125666
12/14/2016
Credit card
NaN
Other
NaN
Since the last few months I 've been unable to...
Company has responded to the consumer and the ...
Bank of America
CA
941XX
...
Consent provided
Web
12/14/2016
Closed with explanation
Yes
NaN
2247267
214.31
205.83
225.27
125667
12/13/2016
Bank account or service
Checking account
Account opening, closing, or management
NaN
I applied to join XXXX XXXX XXXX for a home lo...
Company has responded to the consumer and the ...
Fidelity National Information Services, Inc. (...
GA
301XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248753
73.33
70.85
44.17
125668
11/3/2016
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
There was fraud on my account and does not bel...
NaN
Factual Data
KY
405XX
...
Consent provided
Web
11/3/2016
Closed with explanation
Yes
No
2193913
2.40
2.11
5.82
125669
11/19/2016
Debt collection
Credit card
Disclosure verification of debt
Not given enough info to verify debt
I have disputed this Capital One Credit card c...
NaN
Capital One
IL
604XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
NaN
2216039
87.67
54.43
65.87
125670
11/18/2016
Debt collection
I do not know
Cont'd attempts collect debt not owed
Debt is not mine
I received an alert from credit monitoring ser...
NaN
Midwest Recovery Systems
SC
291XX
...
Consent provided
Web
11/18/2016
Untimely response
No
NaN
2213687
79.67
56.16
39.76
125671
11/16/2016
Debt collection
I do not know
Improper contact or sharing of info
Talked to a third party about my debt
First Source Adv. is contacting family members...
Company believes it acted appropriately as aut...
FirstSource Advantage, LLC
PA
164XX
...
Consent provided
Web
11/16/2016
Closed with explanation
Yes
No
2210820
85.51
73.63
27.10
125672
11/19/2016
Credit reporting
NaN
Incorrect information on credit report
Information is not mine
This is a complaint against the Bureau of Equi...
NaN
Equifax
FL
331XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
NaN
2215661
7.25
2.12
0.92
125673
9/27/2016
Bank account or service
Checking account
Using a debit or ATM card
NaN
I do n't believe I had this account with bank ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
...
Consent provided
Web
9/30/2016
Closed with explanation
Yes
No
2133648
69.74
67.79
41.98
125675
10/21/2016
Consumer Loan
Vehicle lease
Managing the loan or lease
NaN
I leased a vehicle from ALLY, paying all payme...
Company has responded to the consumer and the ...
Ally Financial Inc.
VA
201XX
...
Consent provided
Web
10/21/2016
Closed with explanation
Yes
No
2170435
4126.85
4797.82
1931.60
125676
11/18/2016
Student loan
Non-federal student loan
Can't repay my loan
Can't get flexible payment options
Today my lender increased my private student l...
NaN
AES/PHEAA
NY
130XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2215331
24212.35
24333.23
5957.27
125677
11/4/2016
Bank account or service
Other bank product/service
Account opening, closing, or management
NaN
In XXXX 2016, my computer crashed and deleted ...
Company has responded to the consumer and the ...
BB&T Financial
PA
191XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2194728
75.45
69.03
44.28
125678
11/4/2016
Bank account or service
Checking account
Deposits and withdrawals
NaN
I opened a checking account with Simple Bank (...
NaN
BBVA Compass
VA
223XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2196938
70.11
63.83
35.03
125679
11/9/2016
Credit reporting
NaN
Credit reporting company's investigation
Inadequate help over the phone
I have been contacting Transunion for over 2 m...
Company has responded to the consumer and the ...
TransUnion Intermediate Holdings, Inc.
IL
600XX
...
Consent provided
Web
11/9/2016
Closed with explanation
Yes
No
2202865
4.17
4.67
-0.18
98869 rows × 21 columns
In [34]:
# 8. Do the mask operation in steps 6 and 7 in a single line.
df = df[df['Product'] == 'Mortgage']
df
Out[34]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
12
3/23/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I am assisted with my mortgage through an agen...
NaN
Ditech Financial LLC
GA
300XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
Yes
1296823
185482.51
159366.50
234193.94
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296831
101340.54
182761.24
122579.47
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103381.81
186432.77
110905.24
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297626
219860.35
153908.22
99746.42
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297644
153377.06
169317.86
79792.59
33
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1299207
105940.81
123409.96
89578.55
43
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was emailed that my online account had been ...
NaN
Wells Fargo & Company
MT
598XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297874
234463.04
133847.95
104833.17
44
3/19/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX was submitted XX/XX/XXXX. At the time I s...
NaN
Rushmore Loan Management Services LLC
CA
956XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1292137
177586.11
57294.34
89278.77
46
3/19/2015
Mortgage
Reverse mortgage
Application, originator, mortgage broker
NaN
I am very disappointed that the CFPB did not h...
NaN
CIT Bank National Association
NJ
080XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290543
71574.50
24275.87
65055.48
47
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We fell behind in our payments back in 2014 fo...
NaN
Nationstar Mortgage
VA
230XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292139
61228.78
80961.10
22089.39
48
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a Successor - in -interest to a property ...
NaN
Nationstar Mortgage
CA
925XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290545
180004.43
214540.82
29346.45
49
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am writing this letter because my mortgage a...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
NJ
080XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292065
136855.25
-7012.71
70034.66
50
3/19/2015
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I had a mortgage with from XXXX of XXXX to XXX...
NaN
Citizens Financial Group, Inc.
MA
021XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290564
110769.16
85293.98
140950.99
57
3/19/2015
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I made a payment on a {$69000.00} loan of $ XX...
NaN
Specialized Loan Servicing LLC
NJ
074XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290644
171647.18
167269.02
115595.66
58
3/24/2015
Mortgage
Other mortgage
Settlement process and costs
NaN
I applied for a loan modification with Suntrus...
Company chooses not to provide a public response
SunTrust Banks, Inc.
CO
804XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1298042
91360.36
161713.50
17758.65
64
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was {$48.00} behind on our mortgage because ...
NaN
Ditech Financial LLC
MA
020XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
Yes
1298116
186816.79
228400.77
134987.03
69
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I have been trying to get an audit of my accou...
NaN
Citibank
MD
207XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1290765
174171.64
79753.02
101711.41
72
3/27/2015
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We had a Line of Credit with US Bank that was ...
Company chooses not to provide a public response
U.S. Bancorp
CO
801XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
No
1304648
183467.48
130950.91
141618.46
81
3/27/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Ocwen financial services claims simultaneously...
NaN
Ocwen
MA
017XX
...
Consent provided
Web
4/1/2015
Closed with explanation
Yes
No
1304057
94292.76
136124.02
123227.27
87
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I had a mortgage with XXXX XXXX XXXX from XXXX...
NaN
Nationstar Mortgage
TX
775XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1290871
213279.65
157675.58
79534.17
88
3/24/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029.12
74100.13
40478.75
101
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My wife and I just went through 7 months of ap...
Company chooses not to provide a public response
U.S. Bancorp
KS
664XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
Yes
1304971
182034.47
114693.36
67510.76
102
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We have been working or a Short Sale for Selec...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
FL
333XX
...
Consent provided
Web
3/27/2015
Closed with explanation
Yes
No
1304692
150718.63
165691.38
136517.37
104
3/19/2015
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
I got behind in payments and worked with B of ...
Company chooses not to provide a public response
Bank of America
CA
926XX
...
Consent provided
Web
3/19/2015
Closed with monetary relief
Yes
No
1291084
127616.28
66064.08
77037.93
107
3/24/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Yesterday, I called my mortgage company, Ocwen...
NaN
Ocwen
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1298656
150701.05
167926.46
53600.10
121
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Wells Fargo Mortgage began foreclosure action ...
NaN
Wells Fargo & Company
AZ
853XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1291277
166114.09
81243.71
26314.16
122
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Caliber Home loans has claimed to have made pa...
NaN
Caliber Home Loans, Inc
IN
463XX
...
Consent provided
Web
3/25/2015
Closed with explanation
Yes
No
1298770
198868.56
127222.11
104428.20
127
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Our Mortgage was sold to Carrington Mortgage S...
NaN
Carrington Mortgage Holdings, LLC.
TX
755XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
No
1292613
249757.98
136786.81
71294.46
131
3/27/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
...
Consent provided
Web
4/6/2015
Closed with explanation
Yes
Yes
1305325
169979.86
91967.15
12702.47
139
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We are a victim of Ocwen mortgage and their fr...
NaN
Ocwen
KS
666XX
...
Consent provided
Web
3/19/2015
Closed with explanation
Yes
Yes
1292075
200977.97
208273.54
140895.90
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125541
10/2/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get approved for a loan modific...
Company has responded to the consumer and the ...
Wells Fargo & Company
CA
945XX
...
Consent provided
Web
10/5/2016
Closed with explanation
Yes
No
2141468
121095.06
7620.71
-1882.12
125543
12/13/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have asked Nationstar for assistance for a f...
Company believes it acted appropriately as aut...
Nationstar Mortgage
CA
920XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247658
202258.79
123664.33
92247.20
125546
12/13/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
In XX/XX/2016, I received a solicitation from ...
Company has responded to the consumer and the ...
Freedom Mortgage
SC
295XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248476
141880.00
148011.31
-15018.41
125553
6/30/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX Immediate concern: Stop the forec...
Company chooses not to provide a public response
Wells Fargo & Company
CA
943XX
...
Consent provided
Web
6/30/2015
Closed with explanation
Yes
No
1444123
152880.49
102193.95
173177.07
125557
11/16/2016
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I was advised by XXXX XXXX at omni mortgage th...
NaN
OMNI MORTGAGE CORPORATION
NY
117XX
...
Consent provided
Web
11/16/2016
Closed with explanation
No
NaN
2209300
147430.37
114010.33
47345.30
125564
10/26/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am so devastated and so very disappointed wi...
Company believes it acted appropriately as aut...
North Dakota Housing Finance Agency
ND
586XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
No
2180679
177723.48
216986.74
125397.78
125582
12/13/2016
Mortgage
VA mortgage
Settlement process and costs
NaN
I contracted with USAA Federal Savings Bank to...
Company believes complaint is the result of an...
USAA Savings
GA
303XX
...
Consent provided
Web
12/13/2016
Closed with monetary relief
Yes
NaN
2247493
114277.49
158659.18
85375.31
125583
10/7/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Since the purchase of my house throughout the ...
NaN
Nationstar Mortgage
UT
846XX
...
Consent provided
Web
10/7/2016
Closed with explanation
Yes
No
2152061
129114.44
98844.55
56791.42
125585
12/10/2016
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
Over a period a six months, my XXXX mother app...
Company has responded to the consumer and the ...
BB&T Financial
TX
752XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2244513
65426.99
140152.91
99335.38
125591
12/9/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
RE : Complaint # XXXX Subject : XXXX / Foreclo...
Company believes it acted appropriately as aut...
Shellpoint Partners, LLC
CA
949XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
Yes
2243820
169197.05
66552.62
85769.96
125593
11/11/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get a principal reduction for m...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
302XX
...
Consent provided
Web
11/11/2016
Closed with explanation
Yes
No
2205208
237211.09
47003.87
190013.21
125596
11/3/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
US Bank has not released the lien and sent pro...
Company has responded to the consumer and the ...
U.S. Bancorp
FL
329XX
...
Consent provided
Web
11/3/2016
Closed with explanation
Yes
No
2192518
97710.88
64392.79
74558.88
125601
10/19/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
I filed a rescission to my mortgage lender yea...
NaN
Ocwen
NJ
078XX
...
Consent provided
Web
11/2/2016
Closed with explanation
Yes
No
2169166
140341.51
138125.27
83521.07
125610
12/13/2016
Mortgage
FHA mortgage
Credit decision / Underwriting
NaN
Sales Manager keeps asking for same info repea...
Company believes it acted appropriately as aut...
Nations Lending Coporation
OH
430XX
...
Consent provided
Web
12/14/2016
Closed with explanation
Yes
NaN
2248733
117591.02
103684.51
43800.98
125616
11/19/2016
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
OWCEN made an error on my XXXX XXXX, 2016 and ...
NaN
Ocwen
NY
102XX
...
Consent provided
Web
11/19/2016
Closed with explanation
Yes
Yes
2214614
142775.89
191873.76
101699.37
125618
9/23/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
My loan was transferred to DiTech for servicin...
Company believes complaint represents an oppor...
Ditech Financial LLC
PA
190XX
...
Consent provided
Web
9/23/2016
Closed with explanation
Yes
No
2128559
182275.93
67170.52
92324.06
125619
11/18/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I just refinanced my mortgage to a 15 yr fixed...
NaN
Arvest Bank
IN
463XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2214834
170016.45
65751.65
1991.28
125620
10/10/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
Monday, XX/XX/XXXX " From : XXXX XXXX XXXX XXX...
Company has responded to the consumer and the ...
Round Point Mortgage
GA
300XX
...
Consent provided
Web
10/14/2016
Closed with explanation
Yes
No
2153211
61244.98
99590.82
99820.75
125621
10/31/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My mortgage company ( Ditech ) changed their c...
Company believes complaint represents an oppor...
Ditech Financial LLC
TX
750XX
...
Consent provided
Web
11/2/2016
Closed with explanation
Yes
No
2186239
194123.95
63202.10
47589.77
125622
11/2/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Please see CFPB case # XXXX - I am submitting ...
NaN
Dovenmuehle Mortgage Inc.
PA
191XX
...
Consent provided
Web
11/4/2016
Closed with explanation
Yes
No
2191249
143222.59
16049.53
112755.79
125623
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
SLS purchased the servicing of my mortgage fro...
Company has responded to the consumer and the ...
Specialized Loan Servicing LLC
NY
100XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2248373
161307.06
119452.98
56043.00
125632
11/18/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We had a loan modification done with Nationsta...
NaN
Nationstar Mortgage
TN
377XX
...
Consent provided
Web
11/18/2016
Closed
Yes
NaN
2215986
134966.28
163581.65
59377.15
125634
10/26/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have doubled my income in the last 2 months ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
...
Consent provided
Web
10/26/2016
Closed with explanation
Yes
No
2177009
85949.83
165111.24
84770.01
125636
11/5/2016
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
Nova financial, you are better off finding ano...
NaN
NOVA Financial & Investment Corporation
AZ
856XX
...
Consent provided
Web
11/5/2016
Closed with explanation
Yes
No
2197004
236151.02
119853.39
123155.57
125638
11/18/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have been working with my lender for a loan ...
NaN
Caliber Home Loans, Inc
CA
925XX
...
Consent provided
Web
11/18/2016
Closed
Yes
NaN
2216156
126366.03
67134.38
133643.76
125645
11/18/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I obtain a mortgage loan from Finance of Ameri...
NaN
Finance of America Mortgage LLC
NJ
083XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
NaN
2215655
185077.71
92015.61
69618.41
125647
9/20/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have had my mortgage loan through Bank of Am...
Company has responded to the consumer and the ...
Bank of America
WI
531XX
...
Consent provided
Web
9/20/2016
Closed with monetary relief
Yes
No
2122648
207892.82
180364.18
35887.38
125650
10/27/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My original mortgage was with XXXX. In XXXX 20...
NaN
Nationstar Mortgage
NY
103XX
...
Consent provided
Web
10/27/2016
Closed with explanation
Yes
No
2182081
236687.68
221160.59
64958.93
125654
11/18/2016
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
XXXX XXXX has had complaints filed against him...
NaN
Integrity First Financial Group, Inc.
MO
631XX
...
Consent provided
Web
11/18/2016
Closed with explanation
No
NaN
2215900
74632.68
57102.99
182860.61
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2247724
136798.52
114342.28
106343.36
26811 rows × 21 columns
In [35]:
# 9. Use df[(condition_1) | (condition_2)] notation to get Mortgage and Credit card products.
# Hint: separate conditions must be wrapped in () (and use | or & like notation).
df[(df['Product'] == 'Mortgage') & (df['State'] == 'GA')]
Out[35]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
12
3/23/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I am assisted with my mortgage through an agen...
NaN
Ditech Financial LLC
GA
300XX
...
Consent provided
Web
3/23/2015
Closed with monetary relief
Yes
Yes
1296823
185482.51
159366.50
234193.94
88
3/24/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029.12
74100.13
40478.75
131
3/27/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
...
Consent provided
Web
4/6/2015
Closed with explanation
Yes
Yes
1305325
169979.86
91967.15
12702.47
149
3/28/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
This complaint relates to my mortgage, service...
NaN
JPMorgan Chase & Co.
GA
303XX
...
Consent provided
Web
3/28/2015
Closed with explanation
Yes
Yes
1305793
184625.19
1226.74
10242.66
180
3/29/2015
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I was approved for an FHA loan by MLD MORTGAGE...
Company disputes the facts presented in the co...
MLD Mortgage, Inc.
GA
303XX
...
Consent provided
Web
3/29/2015
Closed with explanation
Yes
No
1306165
214602.28
143057.00
122503.93
329
3/30/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
The complaint is against Wells Fargo Mortgage ...
NaN
Wells Fargo & Company
GA
308XX
...
Consent provided
Web
3/30/2015
Closed with explanation
No
No
1307141
76500.33
81054.54
203861.04
398
3/30/2015
Mortgage
FHA mortgage
Settlement process and costs
NaN
The XXXX company have tried to enforce a fraud...
Company chooses not to provide a public response
SunTrust Banks, Inc.
GA
302XX
...
Consent provided
Web
5/4/2015
Closed with explanation
Yes
Yes
1307644
166344.51
93443.10
104976.01
466
4/4/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
We got behind on our house payments, and the m...
NaN
Ditech Financial LLC
GA
302XX
...
Consent provided
Web
4/4/2015
Closed with explanation
Yes
No
1315899
128175.27
69980.88
113732.41
667
4/1/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am writing this on behalf of my client, who ...
Company believes it acted appropriately as aut...
Servis One, Inc.
GA
300XX
...
Consent provided
Web
4/1/2015
Closed with explanation
Yes
No
1310406
147487.55
105607.53
21039.04
837
4/1/2015
Mortgage
Other mortgage
Loan modification,collection,foreclosure
NaN
I applied for a loan modification through BSI ...
Company believes complaint is the result of an...
Servis One, Inc.
GA
306XX
...
Consent provided
Web
4/1/2015
Closed with explanation
Yes
Yes
1311558
224559.48
180150.22
55289.36
978
4/16/2015
Mortgage
Conventional adjustable mortgage (ARM)
Application, originator, mortgage broker
NaN
Capital One has XXXX me once again. This would...
NaN
Capital One
GA
300XX
...
Consent provided
Web
4/16/2015
Closed with explanation
Yes
No
1334018
151710.20
140374.67
73828.95
1311
4/13/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
XX/XX/XXXX and XX/XX/XXXX - I tried to make a ...
NaN
Carrington Mortgage Holdings, LLC.
GA
301XX
...
Consent provided
Web
4/13/2015
Closed with explanation
Yes
No
1328166
126602.27
231495.06
181341.73
1324
4/18/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Once again, FOR THE NINTH CONSECUTIVE MONTH, t...
NaN
Ocwen
GA
300XX
...
Consent provided
Web
4/21/2015
Closed with explanation
Yes
Yes
1336418
161569.82
116721.57
79172.50
1429
4/20/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
We applied for a mortgage with BBVA Compass. S...
NaN
BBVA Compass
GA
303XX
...
Consent provided
Web
4/20/2015
Closed with explanation
Yes
No
1336628
164600.70
192379.80
99823.85
1461
4/23/2015
Mortgage
Reverse mortgage
Loan servicing, payments, escrow account
NaN
For more than XXXX days, the family of XXXX XX...
NaN
CIT Bank National Association
GA
300XX
...
Consent provided
Web
5/20/2015
Closed with explanation
No
No
1344920
89796.25
97208.45
9496.22
1670
4/14/2015
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
In XXXX of XXXX I notified PNC Mortgage that I...
NaN
PNC Bank N.A.
GA
301XX
...
Consent provided
Web
4/14/2015
Closed with explanation
Yes
No
1328808
196960.65
179300.09
180097.21
1701
4/15/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
Dual Tracking and Foreclosure violation by Cal...
NaN
Caliber Home Loans, Inc
GA
300XX
...
Consent provided
Web
4/15/2015
Closed with explanation
Yes
No
1330526
178336.92
178085.09
140899.80
1813
5/8/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
Green Tree Servicing ( Called GT here ) owns m...
NaN
Ditech Financial LLC
GA
303XX
...
Consent provided
Web
5/8/2015
Closed with explanation
Yes
No
1366758
162091.69
100004.49
42993.26
1846
4/29/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
United Security Financial is the most deceptiv...
NaN
United Security Financial Corp
GA
351XX
...
Consent provided
Web
4/29/2015
Closed with non-monetary relief
Yes
Yes
1353732
118184.26
99955.54
137885.82
1847
4/29/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My mortgage company is refusing to work with m...
NaN
Specialized Loan Servicing LLC
GA
300XX
...
Consent provided
Web
4/29/2015
Closed with explanation
Yes
No
1351933
224643.54
69501.74
22359.82
1959
4/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
I have a mortgage loan with XXXX XXXX in which...
NaN
Seterus, Inc.
GA
300XX
...
Consent provided
Web
4/23/2015
Closed with explanation
Yes
No
1344667
152630.63
132054.59
135188.18
2035
5/8/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My family income rate decreased which lead us ...
NaN
Nationstar Mortgage
GA
315XX
...
Consent provided
Web
5/8/2015
Closed with explanation
Yes
No
1367642
99620.56
75026.29
99339.33
2044
5/14/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Mortgagor has asked for and received excessive...
NaN
Ditech Financial LLC
GA
303XX
...
Consent provided
Web
5/14/2015
Closed with explanation
Yes
No
1375831
187352.06
196702.73
81399.49
2122
4/29/2015
Mortgage
VA mortgage
Settlement process and costs
NaN
The very first day that I spoke with Wells Far...
Company chooses not to provide a public response
Wells Fargo & Company
GA
309XX
...
Consent provided
Web
4/29/2015
Closed with monetary relief
Yes
No
1353196
156905.42
118892.54
201563.97
2350
4/30/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My house is being foreclosed on by a mortgage ...
NaN
Ditech Financial LLC
GA
301XX
...
Consent provided
Web
4/30/2015
Closed with explanation
Yes
No
1354014
145348.02
77170.94
92721.00
2370
5/12/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I bought my house in XXXX, my first lender was...
NaN
Bank of America
GA
302XX
...
Consent provided
Web
5/12/2015
Closed with explanation
Yes
No
1371019
102585.44
128109.57
168376.32
2443
5/20/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Ocwen Loan Servicing , LLC sent an Annual Escr...
NaN
Ocwen
GA
300XX
...
Consent provided
Web
5/20/2015
Closed with explanation
Yes
No
1384435
174817.48
142009.18
95164.16
2497
5/26/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I own my home through Freedom Mortgage XXXX XX...
Company chooses not to provide a public response
Freedom Mortgage
GA
306XX
...
Consent provided
Web
5/29/2015
Closed with explanation
Yes
No
1391837
175966.52
58289.72
60346.60
2652
5/15/2015
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
I am requesting your assistance with a Deed In...
NaN
Bank of America
GA
306XX
...
Consent provided
Web
5/15/2015
Closed with explanation
Yes
No
1377850
210699.47
140108.39
157655.04
2737
5/20/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
According to our PSA 's from the United States...
NaN
JPMorgan Chase & Co.
GA
302XX
...
Consent provided
Web
5/28/2015
Closed with explanation
Yes
Yes
1385493
152960.40
199737.58
87236.60
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
122460
3/21/2016
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
Southeast Mortgage, XXXX, GA was the lender on...
NaN
Southeast Mortgage of Georgia, Inc.
GA
301XX
...
Consent provided
Web
3/21/2016
Closed with explanation
No
NaN
1842188
180136.89
149072.05
70039.79
122470
10/3/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was with a company Called Green Tree Mortgag...
Company believes it acted appropriately as aut...
Ditech Financial LLC
GA
314XX
...
Consent provided
Web
10/3/2016
Closed with explanation
Yes
No
2141071
111107.97
105241.38
30999.34
122646
11/22/2016
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
Approved for a XXXX with Wells Fargo Bank and ...
Company has responded to the consumer and the ...
Wells Fargo & Company
GA
302XX
...
Consent provided
Web
11/22/2016
Closed with explanation
Yes
NaN
2217161
162188.57
90647.60
109593.09
122693
12/7/2016
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I went under contract for a home in XXXX 2016 ...
Company has responded to the consumer and the ...
Wells Fargo & Company
GA
301XX
...
Consent provided
Web
12/7/2016
Closed with explanation
Yes
NaN
2237365
121964.51
69816.56
74774.63
122814
9/19/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am very concern about the shortage of our es...
Company believes it acted appropriately as aut...
Primary Residential Mortgage
GA
300XX
...
Consent provided
Web
9/19/2016
Closed with explanation
Yes
No
2119761
111292.98
200558.15
56697.41
122835
11/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have been sending extra money to Ocwen to be...
NaN
Ocwen
GA
308XX
...
Consent provided
Web
11/13/2016
Closed with explanation
Yes
NaN
2205581
177464.32
61611.87
9067.13
122954
12/6/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I have a FHA loan and I called Wells Fargo to ...
Company has responded to the consumer and the ...
Wells Fargo & Company
GA
301XX
...
Consent provided
Web
12/6/2016
Closed with explanation
Yes
NaN
2238624
198846.95
18588.77
65911.63
122999
10/22/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We have been trying to refinance a XXXX loan w...
NaN
Seterus, Inc.
GA
303XX
...
Consent provided
Web
10/31/2016
Closed with explanation
Yes
No
2173281
140697.62
59803.30
101345.87
123239
11/5/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
Dear XXXX iam writing this note to you telling...
Company believes it acted appropriately as aut...
Rushmore Loan Management Services LLC
GA
302XX
...
Consent provided
Web
11/5/2016
Closed with explanation
Yes
No
2197100
92465.34
39208.33
120469.00
123395
11/15/2016
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I sent in my payment for XXXX 10 days ago and ...
NaN
Ocwen
GA
303XX
...
Consent provided
Web
11/15/2016
Closed with explanation
Yes
NaN
2210056
231392.64
72112.79
80776.94
123507
11/4/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
Service 1st mortgage claims to help veterans b...
Company disputes the facts presented in the co...
Service 1st Mortgage, Inc.
GA
233XX
...
Consent provided
Web
11/4/2016
Closed
Yes
No
2195173
142893.63
52472.05
35924.53
123642
10/31/2016
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
My husband and I bought a home with a typical ...
Company has responded to the consumer and the ...
BB&T Financial
GA
303XX
...
Consent provided
Web
10/31/2016
Closed with explanation
Yes
No
2186788
112256.25
230457.22
138063.71
123915
10/14/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
CitiMortgage Inc. is the mortgage company I ha...
Company has responded to the consumer and the ...
Citibank
GA
300XX
...
Consent provided
Web
10/18/2016
Closed with explanation
Yes
No
2160190
152983.60
117799.13
165549.63
123968
11/18/2016
Mortgage
Other mortgage
Loan modification,collection,foreclosure
NaN
I fell behind in my mortgage due to some finan...
NaN
Nationstar Mortgage
GA
303XX
...
Consent provided
Web
11/18/2016
Closed
Yes
NaN
2212683
152081.68
93149.30
196304.85
124204
11/17/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have my mortgage with 21st mortgage. So far ...
NaN
21st Mortgage Corporation
GA
310XX
...
Consent provided
Web
11/17/2016
Closed with explanation
Yes
NaN
2213124
124183.45
149248.95
76440.68
124262
11/1/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Our loan was acquired by LoanCare on XXXX/XXXX...
Company has responded to the consumer and the ...
Loan Care
GA
300XX
...
Consent provided
Web
11/2/2016
Closed with explanation
Yes
No
2188530
170995.44
123101.97
91708.06
124431
12/9/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I started a short sale process with Select Por...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
GA
301XX
...
Consent provided
Web
12/9/2016
Closed with explanation
Yes
NaN
2243987
117766.59
166203.18
94733.25
124787
11/17/2016
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
We have been approved for a Loan and three wee...
NaN
Home Servicing LLC
GA
301XX
...
Consent provided
Web
11/17/2016
Closed with explanation
Yes
No
2212907
149056.70
173649.71
132007.58
124799
12/9/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I received a foreclosure letter from Select Po...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
GA
300XX
...
Consent provided
Web
12/9/2016
Closed with explanation
Yes
NaN
2243154
141881.31
142814.07
140269.99
125028
11/17/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a former XXXX Mortgage holder, whose loan...
NaN
Seterus, Inc.
GA
300XX
...
Consent provided
Web
11/17/2016
Closed with explanation
Yes
NaN
2213865
107377.32
240290.71
22657.51
125030
12/8/2016
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We were recently denied a settlement counter-o...
Company believes it acted appropriately as aut...
USAA Savings
GA
301XX
...
Consent provided
Web
12/8/2016
Closed with explanation
Yes
NaN
2242023
126176.37
121678.26
136253.34
125093
12/8/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I had to have XXXX in XX/XX/2016, XXXX months ...
Company has responded to the consumer and the ...
U.S. Bancorp
GA
302XX
...
Consent provided
Web
12/9/2016
Closed with explanation
Yes
NaN
2242317
164359.23
47870.72
120262.89
125283
12/13/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX XXXX XXXX XXXX XXXX, GA XXXX Direct...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
GA
303XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
NaN
2245563
214274.37
37899.57
53982.70
125327
11/18/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My mortage loan with XXXX was sold to Ocwen. W...
NaN
Ocwen
GA
302XX
...
Consent provided
Web
11/18/2016
Closed
Yes
Yes
2213561
151735.11
137970.86
93771.72
125437
12/13/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
In XXXX of XXXX I lost my job and became worri...
Company has responded to the consumer and the ...
Wells Fargo & Company
GA
300XX
...
Consent provided
Web
12/13/2016
Closed with explanation
Yes
Yes
2247676
161591.63
22851.64
44769.32
125469
11/18/2016
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
Realtime Resolutions out of XXXX TX took over ...
NaN
Real Time Resolutions
GA
314XX
...
Consent provided
Web
11/18/2016
Closed with explanation
Yes
Yes
2216184
193971.82
83765.61
68540.53
125492
12/14/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
Suntrust violated the Equal Credit Opportunity...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
300XX
...
Consent provided
Web
12/14/2016
Closed with explanation
Yes
NaN
2249249
100111.89
100326.73
156761.48
125582
12/13/2016
Mortgage
VA mortgage
Settlement process and costs
NaN
I contracted with USAA Federal Savings Bank to...
Company believes complaint is the result of an...
USAA Savings
GA
303XX
...
Consent provided
Web
12/13/2016
Closed with monetary relief
Yes
NaN
2247493
114277.49
158659.18
85375.31
125593
11/11/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get a principal reduction for m...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
302XX
...
Consent provided
Web
11/11/2016
Closed with explanation
Yes
No
2205208
237211.09
47003.87
190013.21
125620
10/10/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
Monday, XX/XX/XXXX " From : XXXX XXXX XXXX XXX...
Company has responded to the consumer and the ...
Round Point Mortgage
GA
300XX
...
Consent provided
Web
10/14/2016
Closed with explanation
Yes
No
2153211
61244.98
99590.82
99820.75
1375 rows × 21 columns
In [36]:
# 10. Drop a row from your df.
df = df.drop(12)
df.head(5)
Out[36]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Submitted via
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
Web
3/23/2015
Closed with explanation
Yes
No
1296831
101340.54
182761.24
122579.47
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
Web
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103381.81
186432.77
110905.24
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297626
219860.35
153908.22
99746.42
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1297644
153377.06
169317.86
79792.59
33
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
...
Consent provided
Web
3/24/2015
Closed with explanation
Yes
No
1299207
105940.81
123409.96
89578.55
5 rows × 21 columns
In [37]:
# 11. Drop a column from your df.
df = df.drop('Submitted via', axis=1)
df
Out[37]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
Tags
Consumer consent provided?
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
NaN
Consent provided
3/23/2015
Closed with explanation
Yes
No
1296831
101340.54
182761.24
122579.47
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
NaN
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103381.81
186432.77
110905.24
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
NaN
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297626
219860.35
153908.22
99746.42
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
Servicemember
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297644
153377.06
169317.86
79792.59
33
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
NaN
Consent provided
3/24/2015
Closed with explanation
Yes
No
1299207
105940.81
123409.96
89578.55
43
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was emailed that my online account had been ...
NaN
Wells Fargo & Company
MT
598XX
NaN
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297874
234463.04
133847.95
104833.17
44
3/19/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX was submitted XX/XX/XXXX. At the time I s...
NaN
Rushmore Loan Management Services LLC
CA
956XX
Older American
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292137
177586.11
57294.34
89278.77
46
3/19/2015
Mortgage
Reverse mortgage
Application, originator, mortgage broker
NaN
I am very disappointed that the CFPB did not h...
NaN
CIT Bank National Association
NJ
080XX
Older American
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290543
71574.50
24275.87
65055.48
47
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We fell behind in our payments back in 2014 fo...
NaN
Nationstar Mortgage
VA
230XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292139
61228.78
80961.10
22089.39
48
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a Successor - in -interest to a property ...
NaN
Nationstar Mortgage
CA
925XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290545
180004.43
214540.82
29346.45
49
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am writing this letter because my mortgage a...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
NJ
080XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292065
136855.25
-7012.71
70034.66
50
3/19/2015
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I had a mortgage with from XXXX of XXXX to XXX...
NaN
Citizens Financial Group, Inc.
MA
021XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290564
110769.16
85293.98
140950.99
57
3/19/2015
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I made a payment on a {$69000.00} loan of $ XX...
NaN
Specialized Loan Servicing LLC
NJ
074XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290644
171647.18
167269.02
115595.66
58
3/24/2015
Mortgage
Other mortgage
Settlement process and costs
NaN
I applied for a loan modification with Suntrus...
Company chooses not to provide a public response
SunTrust Banks, Inc.
CO
804XX
NaN
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1298042
91360.36
161713.50
17758.65
64
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was {$48.00} behind on our mortgage because ...
NaN
Ditech Financial LLC
MA
020XX
NaN
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
Yes
1298116
186816.79
228400.77
134987.03
69
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I have been trying to get an audit of my accou...
NaN
Citibank
MD
207XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290765
174171.64
79753.02
101711.41
72
3/27/2015
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We had a Line of Credit with US Bank that was ...
Company chooses not to provide a public response
U.S. Bancorp
CO
801XX
NaN
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304648
183467.48
130950.91
141618.46
81
3/27/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Ocwen financial services claims simultaneously...
NaN
Ocwen
MA
017XX
NaN
Consent provided
4/1/2015
Closed with explanation
Yes
No
1304057
94292.76
136124.02
123227.27
87
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I had a mortgage with XXXX XXXX XXXX from XXXX...
NaN
Nationstar Mortgage
TX
775XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290871
213279.65
157675.58
79534.17
88
3/24/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
NaN
Consent provided
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029.12
74100.13
40478.75
101
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My wife and I just went through 7 months of ap...
Company chooses not to provide a public response
U.S. Bancorp
KS
664XX
NaN
Consent provided
3/27/2015
Closed with explanation
Yes
Yes
1304971
182034.47
114693.36
67510.76
102
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We have been working or a Short Sale for Selec...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
FL
333XX
NaN
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304692
150718.63
165691.38
136517.37
104
3/19/2015
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
I got behind in payments and worked with B of ...
Company chooses not to provide a public response
Bank of America
CA
926XX
NaN
Consent provided
3/19/2015
Closed with monetary relief
Yes
No
1291084
127616.28
66064.08
77037.93
107
3/24/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Yesterday, I called my mortgage company, Ocwen...
NaN
Ocwen
TX
770XX
NaN
Consent provided
3/24/2015
Closed with explanation
Yes
No
1298656
150701.05
167926.46
53600.10
121
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Wells Fargo Mortgage began foreclosure action ...
NaN
Wells Fargo & Company
AZ
853XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1291277
166114.09
81243.71
26314.16
122
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Caliber Home loans has claimed to have made pa...
NaN
Caliber Home Loans, Inc
IN
463XX
NaN
Consent provided
3/25/2015
Closed with explanation
Yes
No
1298770
198868.56
127222.11
104428.20
127
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Our Mortgage was sold to Carrington Mortgage S...
NaN
Carrington Mortgage Holdings, LLC.
TX
755XX
NaN
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292613
249757.98
136786.81
71294.46
131
3/27/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
Servicemember
Consent provided
4/6/2015
Closed with explanation
Yes
Yes
1305325
169979.86
91967.15
12702.47
139
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We are a victim of Ocwen mortgage and their fr...
NaN
Ocwen
KS
666XX
Servicemember
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292075
200977.97
208273.54
140895.90
146
3/28/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
Please know I greatly appreciate your assistan...
NaN
Seterus, Inc.
FL
331XX
NaN
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305831
192775.55
176085.10
46461.77
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125541
10/2/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get approved for a loan modific...
Company has responded to the consumer and the ...
Wells Fargo & Company
CA
945XX
NaN
Consent provided
10/5/2016
Closed with explanation
Yes
No
2141468
121095.06
7620.71
-1882.12
125543
12/13/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have asked Nationstar for assistance for a f...
Company believes it acted appropriately as aut...
Nationstar Mortgage
CA
920XX
Older American
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2247658
202258.79
123664.33
92247.20
125546
12/13/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
In XX/XX/2016, I received a solicitation from ...
Company has responded to the consumer and the ...
Freedom Mortgage
SC
295XX
Older American
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2248476
141880.00
148011.31
-15018.41
125553
6/30/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX Immediate concern: Stop the forec...
Company chooses not to provide a public response
Wells Fargo & Company
CA
943XX
NaN
Consent provided
6/30/2015
Closed with explanation
Yes
No
1444123
152880.49
102193.95
173177.07
125557
11/16/2016
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I was advised by XXXX XXXX at omni mortgage th...
NaN
OMNI MORTGAGE CORPORATION
NY
117XX
NaN
Consent provided
11/16/2016
Closed with explanation
No
NaN
2209300
147430.37
114010.33
47345.30
125564
10/26/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am so devastated and so very disappointed wi...
Company believes it acted appropriately as aut...
North Dakota Housing Finance Agency
ND
586XX
NaN
Consent provided
11/18/2016
Closed with explanation
Yes
No
2180679
177723.48
216986.74
125397.78
125582
12/13/2016
Mortgage
VA mortgage
Settlement process and costs
NaN
I contracted with USAA Federal Savings Bank to...
Company believes complaint is the result of an...
USAA Savings
GA
303XX
NaN
Consent provided
12/13/2016
Closed with monetary relief
Yes
NaN
2247493
114277.49
158659.18
85375.31
125583
10/7/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Since the purchase of my house throughout the ...
NaN
Nationstar Mortgage
UT
846XX
NaN
Consent provided
10/7/2016
Closed with explanation
Yes
No
2152061
129114.44
98844.55
56791.42
125585
12/10/2016
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
Over a period a six months, my XXXX mother app...
Company has responded to the consumer and the ...
BB&T Financial
TX
752XX
NaN
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2244513
65426.99
140152.91
99335.38
125591
12/9/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
RE : Complaint # XXXX Subject : XXXX / Foreclo...
Company believes it acted appropriately as aut...
Shellpoint Partners, LLC
CA
949XX
Older American
Consent provided
12/13/2016
Closed with explanation
Yes
Yes
2243820
169197.05
66552.62
85769.96
125593
11/11/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get a principal reduction for m...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
302XX
Servicemember
Consent provided
11/11/2016
Closed with explanation
Yes
No
2205208
237211.09
47003.87
190013.21
125596
11/3/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
US Bank has not released the lien and sent pro...
Company has responded to the consumer and the ...
U.S. Bancorp
FL
329XX
NaN
Consent provided
11/3/2016
Closed with explanation
Yes
No
2192518
97710.88
64392.79
74558.88
125601
10/19/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
I filed a rescission to my mortgage lender yea...
NaN
Ocwen
NJ
078XX
NaN
Consent provided
11/2/2016
Closed with explanation
Yes
No
2169166
140341.51
138125.27
83521.07
125610
12/13/2016
Mortgage
FHA mortgage
Credit decision / Underwriting
NaN
Sales Manager keeps asking for same info repea...
Company believes it acted appropriately as aut...
Nations Lending Coporation
OH
430XX
NaN
Consent provided
12/14/2016
Closed with explanation
Yes
NaN
2248733
117591.02
103684.51
43800.98
125616
11/19/2016
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
OWCEN made an error on my XXXX XXXX, 2016 and ...
NaN
Ocwen
NY
102XX
NaN
Consent provided
11/19/2016
Closed with explanation
Yes
Yes
2214614
142775.89
191873.76
101699.37
125618
9/23/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
My loan was transferred to DiTech for servicin...
Company believes complaint represents an oppor...
Ditech Financial LLC
PA
190XX
NaN
Consent provided
9/23/2016
Closed with explanation
Yes
No
2128559
182275.93
67170.52
92324.06
125619
11/18/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I just refinanced my mortgage to a 15 yr fixed...
NaN
Arvest Bank
IN
463XX
NaN
Consent provided
11/18/2016
Closed with explanation
Yes
NaN
2214834
170016.45
65751.65
1991.28
125620
10/10/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
Monday, XX/XX/XXXX " From : XXXX XXXX XXXX XXX...
Company has responded to the consumer and the ...
Round Point Mortgage
GA
300XX
NaN
Consent provided
10/14/2016
Closed with explanation
Yes
No
2153211
61244.98
99590.82
99820.75
125621
10/31/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My mortgage company ( Ditech ) changed their c...
Company believes complaint represents an oppor...
Ditech Financial LLC
TX
750XX
Older American
Consent provided
11/2/2016
Closed with explanation
Yes
No
2186239
194123.95
63202.10
47589.77
125622
11/2/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Please see CFPB case # XXXX - I am submitting ...
NaN
Dovenmuehle Mortgage Inc.
PA
191XX
NaN
Consent provided
11/4/2016
Closed with explanation
Yes
No
2191249
143222.59
16049.53
112755.79
125623
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
SLS purchased the servicing of my mortgage fro...
Company has responded to the consumer and the ...
Specialized Loan Servicing LLC
NY
100XX
Older American
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2248373
161307.06
119452.98
56043.00
125632
11/18/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We had a loan modification done with Nationsta...
NaN
Nationstar Mortgage
TN
377XX
NaN
Consent provided
11/18/2016
Closed
Yes
NaN
2215986
134966.28
163581.65
59377.15
125634
10/26/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have doubled my income in the last 2 months ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
NaN
Consent provided
10/26/2016
Closed with explanation
Yes
No
2177009
85949.83
165111.24
84770.01
125636
11/5/2016
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
Nova financial, you are better off finding ano...
NaN
NOVA Financial & Investment Corporation
AZ
856XX
Servicemember
Consent provided
11/5/2016
Closed with explanation
Yes
No
2197004
236151.02
119853.39
123155.57
125638
11/18/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have been working with my lender for a loan ...
NaN
Caliber Home Loans, Inc
CA
925XX
NaN
Consent provided
11/18/2016
Closed
Yes
NaN
2216156
126366.03
67134.38
133643.76
125645
11/18/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I obtain a mortgage loan from Finance of Ameri...
NaN
Finance of America Mortgage LLC
NJ
083XX
NaN
Consent provided
11/18/2016
Closed with explanation
Yes
NaN
2215655
185077.71
92015.61
69618.41
125647
9/20/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have had my mortgage loan through Bank of Am...
Company has responded to the consumer and the ...
Bank of America
WI
531XX
NaN
Consent provided
9/20/2016
Closed with monetary relief
Yes
No
2122648
207892.82
180364.18
35887.38
125650
10/27/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My original mortgage was with XXXX. In XXXX 20...
NaN
Nationstar Mortgage
NY
103XX
NaN
Consent provided
10/27/2016
Closed with explanation
Yes
No
2182081
236687.68
221160.59
64958.93
125654
11/18/2016
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
XXXX XXXX has had complaints filed against him...
NaN
Integrity First Financial Group, Inc.
MO
631XX
NaN
Consent provided
11/18/2016
Closed with explanation
No
NaN
2215900
74632.68
57102.99
182860.61
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
NaN
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2247724
136798.52
114342.28
106343.36
26810 rows × 20 columns
In [38]:
# 12. Use your df's loc[] attribute to get specific rows and columns using loc[NUMBER, NUMBER] notation.
df.loc[22, 'Product']
Out[38]:
'Mortgage'
In [39]:
# 13. User your dataframe's set_index() method to use a ['Product', 'Sub-product']. Then sort_index().
df.set_index(['Product', 'Sub-product']).sort_index().head(5)
Out[39]:
Date received
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
Tags
Consumer consent provided?
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
Product
Sub-product
Mortgage
Conventional adjustable mortgage (ARM)
3/24/2015
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
NaN
Consent provided
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029.12
74100.13
40478.75
Conventional adjustable mortgage (ARM)
3/28/2015
Loan modification,collection,foreclosure
NaN
Please know I greatly appreciate your assistan...
NaN
Seterus, Inc.
FL
331XX
NaN
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305831
192775.55
176085.10
46461.77
Conventional adjustable mortgage (ARM)
3/28/2015
Loan servicing, payments, escrow account
NaN
This complaint relates to my mortgage, service...
NaN
JPMorgan Chase & Co.
GA
303XX
NaN
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305793
184625.19
1226.74
10242.66
Conventional adjustable mortgage (ARM)
3/28/2015
Loan modification,collection,foreclosure
NaN
I first started with country wide and was in t...
NaN
Nationstar Mortgage
CA
956XX
NaN
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305965
111894.32
115955.23
81744.55
Conventional adjustable mortgage (ARM)
3/28/2015
Loan modification,collection,foreclosure
NaN
I had a 5 year loan modification with XXXX XXX...
NaN
Nationstar Mortgage
CA
925XX
NaN
Consent provided
3/28/2015
Closed with explanation
Yes
No
1306024
203858.68
138588.95
32298.28
In [40]:
# 14. Use loc[] with a number like 1000000, and add a row to the dataframe.
df.loc[10000000] = 'WUT'
df.tail(2)
Out[40]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
Tags
Consumer consent provided?
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
NaN
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2247724
136799
114342
106343
10000000
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
In [41]:
# 15. Add a column to the dataframe named "Custom" that copies the values in another column.
df['Custom'] = df['Consumer consent provided?']
df
Out[41]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
Custom
13
3/23/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
3/23/2015
Closed with explanation
Yes
No
1296831
101341
182761
122579
Consent provided
19
3/24/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103382
186433
110905
Consent provided
22
3/24/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297626
219860
153908
99746.4
Consent provided
25
3/24/2015
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297644
153377
169318
79792.6
Consent provided
33
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1299207
105941
123410
89578.6
Consent provided
43
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was emailed that my online account had been ...
NaN
Wells Fargo & Company
MT
598XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297874
234463
133848
104833
Consent provided
44
3/19/2015
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX was submitted XX/XX/XXXX. At the time I s...
NaN
Rushmore Loan Management Services LLC
CA
956XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292137
177586
57294.3
89278.8
Consent provided
46
3/19/2015
Mortgage
Reverse mortgage
Application, originator, mortgage broker
NaN
I am very disappointed that the CFPB did not h...
NaN
CIT Bank National Association
NJ
080XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290543
71574.5
24275.9
65055.5
Consent provided
47
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We fell behind in our payments back in 2014 fo...
NaN
Nationstar Mortgage
VA
230XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292139
61228.8
80961.1
22089.4
Consent provided
48
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a Successor - in -interest to a property ...
NaN
Nationstar Mortgage
CA
925XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290545
180004
214541
29346.5
Consent provided
49
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am writing this letter because my mortgage a...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
NJ
080XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292065
136855
-7012.71
70034.7
Consent provided
50
3/19/2015
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I had a mortgage with from XXXX of XXXX to XXX...
NaN
Citizens Financial Group, Inc.
MA
021XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290564
110769
85294
140951
Consent provided
57
3/19/2015
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I made a payment on a {$69000.00} loan of $ XX...
NaN
Specialized Loan Servicing LLC
NJ
074XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290644
171647
167269
115596
Consent provided
58
3/24/2015
Mortgage
Other mortgage
Settlement process and costs
NaN
I applied for a loan modification with Suntrus...
Company chooses not to provide a public response
SunTrust Banks, Inc.
CO
804XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1298042
91360.4
161714
17758.7
Consent provided
64
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was {$48.00} behind on our mortgage because ...
NaN
Ditech Financial LLC
MA
020XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
Yes
1298116
186817
228401
134987
Consent provided
69
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I have been trying to get an audit of my accou...
NaN
Citibank
MD
207XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290765
174172
79753
101711
Consent provided
72
3/27/2015
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We had a Line of Credit with US Bank that was ...
Company chooses not to provide a public response
U.S. Bancorp
CO
801XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304648
183467
130951
141618
Consent provided
81
3/27/2015
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Ocwen financial services claims simultaneously...
NaN
Ocwen
MA
017XX
...
Consent provided
4/1/2015
Closed with explanation
Yes
No
1304057
94292.8
136124
123227
Consent provided
87
3/19/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I had a mortgage with XXXX XXXX XXXX from XXXX...
NaN
Nationstar Mortgage
TX
775XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290871
213280
157676
79534.2
Consent provided
88
3/24/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029
74100.1
40478.8
Consent provided
101
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My wife and I just went through 7 months of ap...
Company chooses not to provide a public response
U.S. Bancorp
KS
664XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
Yes
1304971
182034
114693
67510.8
Consent provided
102
3/27/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We have been working or a Short Sale for Selec...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
FL
333XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304692
150719
165691
136517
Consent provided
104
3/19/2015
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
I got behind in payments and worked with B of ...
Company chooses not to provide a public response
Bank of America
CA
926XX
...
Consent provided
3/19/2015
Closed with monetary relief
Yes
No
1291084
127616
66064.1
77037.9
Consent provided
107
3/24/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Yesterday, I called my mortgage company, Ocwen...
NaN
Ocwen
TX
770XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1298656
150701
167926
53600.1
Consent provided
121
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Wells Fargo Mortgage began foreclosure action ...
NaN
Wells Fargo & Company
AZ
853XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1291277
166114
81243.7
26314.2
Consent provided
122
3/24/2015
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Caliber Home loans has claimed to have made pa...
NaN
Caliber Home Loans, Inc
IN
463XX
...
Consent provided
3/25/2015
Closed with explanation
Yes
No
1298770
198869
127222
104428
Consent provided
127
3/19/2015
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Our Mortgage was sold to Carrington Mortgage S...
NaN
Carrington Mortgage Holdings, LLC.
TX
755XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292613
249758
136787
71294.5
Consent provided
131
3/27/2015
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
...
Consent provided
4/6/2015
Closed with explanation
Yes
Yes
1305325
169980
91967.1
12702.5
Consent provided
139
3/19/2015
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We are a victim of Ocwen mortgage and their fr...
NaN
Ocwen
KS
666XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292075
200978
208274
140896
Consent provided
146
3/28/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
Please know I greatly appreciate your assistan...
NaN
Seterus, Inc.
FL
331XX
...
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305831
192776
176085
46461.8
Consent provided
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
125543
12/13/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have asked Nationstar for assistance for a f...
Company believes it acted appropriately as aut...
Nationstar Mortgage
CA
920XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2247658
202259
123664
92247.2
Consent provided
125546
12/13/2016
Mortgage
VA mortgage
Application, originator, mortgage broker
NaN
In XX/XX/2016, I received a solicitation from ...
Company has responded to the consumer and the ...
Freedom Mortgage
SC
295XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2248476
141880
148011
-15018.4
Consent provided
125553
6/30/2015
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX Immediate concern: Stop the forec...
Company chooses not to provide a public response
Wells Fargo & Company
CA
943XX
...
Consent provided
6/30/2015
Closed with explanation
Yes
No
1444123
152880
102194
173177
Consent provided
125557
11/16/2016
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I was advised by XXXX XXXX at omni mortgage th...
NaN
OMNI MORTGAGE CORPORATION
NY
117XX
...
Consent provided
11/16/2016
Closed with explanation
No
NaN
2209300
147430
114010
47345.3
Consent provided
125564
10/26/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am so devastated and so very disappointed wi...
Company believes it acted appropriately as aut...
North Dakota Housing Finance Agency
ND
586XX
...
Consent provided
11/18/2016
Closed with explanation
Yes
No
2180679
177723
216987
125398
Consent provided
125582
12/13/2016
Mortgage
VA mortgage
Settlement process and costs
NaN
I contracted with USAA Federal Savings Bank to...
Company believes complaint is the result of an...
USAA Savings
GA
303XX
...
Consent provided
12/13/2016
Closed with monetary relief
Yes
NaN
2247493
114277
158659
85375.3
Consent provided
125583
10/7/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Since the purchase of my house throughout the ...
NaN
Nationstar Mortgage
UT
846XX
...
Consent provided
10/7/2016
Closed with explanation
Yes
No
2152061
129114
98844.6
56791.4
Consent provided
125585
12/10/2016
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
Over a period a six months, my XXXX mother app...
Company has responded to the consumer and the ...
BB&T Financial
TX
752XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2244513
65427
140153
99335.4
Consent provided
125591
12/9/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
RE : Complaint # XXXX Subject : XXXX / Foreclo...
Company believes it acted appropriately as aut...
Shellpoint Partners, LLC
CA
949XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
Yes
2243820
169197
66552.6
85770
Consent provided
125593
11/11/2016
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I am trying to get a principal reduction for m...
Company has responded to the consumer and the ...
SunTrust Banks, Inc.
GA
302XX
...
Consent provided
11/11/2016
Closed with explanation
Yes
No
2205208
237211
47003.9
190013
Consent provided
125596
11/3/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
US Bank has not released the lien and sent pro...
Company has responded to the consumer and the ...
U.S. Bancorp
FL
329XX
...
Consent provided
11/3/2016
Closed with explanation
Yes
No
2192518
97710.9
64392.8
74558.9
Consent provided
125601
10/19/2016
Mortgage
Conventional adjustable mortgage (ARM)
Settlement process and costs
NaN
I filed a rescission to my mortgage lender yea...
NaN
Ocwen
NJ
078XX
...
Consent provided
11/2/2016
Closed with explanation
Yes
No
2169166
140342
138125
83521.1
Consent provided
125610
12/13/2016
Mortgage
FHA mortgage
Credit decision / Underwriting
NaN
Sales Manager keeps asking for same info repea...
Company believes it acted appropriately as aut...
Nations Lending Coporation
OH
430XX
...
Consent provided
12/14/2016
Closed with explanation
Yes
NaN
2248733
117591
103685
43801
Consent provided
125616
11/19/2016
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
OWCEN made an error on my XXXX XXXX, 2016 and ...
NaN
Ocwen
NY
102XX
...
Consent provided
11/19/2016
Closed with explanation
Yes
Yes
2214614
142776
191874
101699
Consent provided
125618
9/23/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
My loan was transferred to DiTech for servicin...
Company believes complaint represents an oppor...
Ditech Financial LLC
PA
190XX
...
Consent provided
9/23/2016
Closed with explanation
Yes
No
2128559
182276
67170.5
92324.1
Consent provided
125619
11/18/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I just refinanced my mortgage to a 15 yr fixed...
NaN
Arvest Bank
IN
463XX
...
Consent provided
11/18/2016
Closed with explanation
Yes
NaN
2214834
170016
65751.6
1991.28
Consent provided
125620
10/10/2016
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
Monday, XX/XX/XXXX " From : XXXX XXXX XXXX XXX...
Company has responded to the consumer and the ...
Round Point Mortgage
GA
300XX
...
Consent provided
10/14/2016
Closed with explanation
Yes
No
2153211
61245
99590.8
99820.8
Consent provided
125621
10/31/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My mortgage company ( Ditech ) changed their c...
Company believes complaint represents an oppor...
Ditech Financial LLC
TX
750XX
...
Consent provided
11/2/2016
Closed with explanation
Yes
No
2186239
194124
63202.1
47589.8
Consent provided
125622
11/2/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Please see CFPB case # XXXX - I am submitting ...
NaN
Dovenmuehle Mortgage Inc.
PA
191XX
...
Consent provided
11/4/2016
Closed with explanation
Yes
No
2191249
143223
16049.5
112756
Consent provided
125623
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
SLS purchased the servicing of my mortgage fro...
Company has responded to the consumer and the ...
Specialized Loan Servicing LLC
NY
100XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2248373
161307
119453
56043
Consent provided
125632
11/18/2016
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We had a loan modification done with Nationsta...
NaN
Nationstar Mortgage
TN
377XX
...
Consent provided
11/18/2016
Closed
Yes
NaN
2215986
134966
163582
59377.2
Consent provided
125634
10/26/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have doubled my income in the last 2 months ...
Company has responded to the consumer and the ...
Bank of America
CA
900XX
...
Consent provided
10/26/2016
Closed with explanation
Yes
No
2177009
85949.8
165111
84770
Consent provided
125636
11/5/2016
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
Nova financial, you are better off finding ano...
NaN
NOVA Financial & Investment Corporation
AZ
856XX
...
Consent provided
11/5/2016
Closed with explanation
Yes
No
2197004
236151
119853
123156
Consent provided
125638
11/18/2016
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I have been working with my lender for a loan ...
NaN
Caliber Home Loans, Inc
CA
925XX
...
Consent provided
11/18/2016
Closed
Yes
NaN
2216156
126366
67134.4
133644
Consent provided
125645
11/18/2016
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
I obtain a mortgage loan from Finance of Ameri...
NaN
Finance of America Mortgage LLC
NJ
083XX
...
Consent provided
11/18/2016
Closed with explanation
Yes
NaN
2215655
185078
92015.6
69618.4
Consent provided
125647
9/20/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I have had my mortgage loan through Bank of Am...
Company has responded to the consumer and the ...
Bank of America
WI
531XX
...
Consent provided
9/20/2016
Closed with monetary relief
Yes
No
2122648
207893
180364
35887.4
Consent provided
125650
10/27/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
My original mortgage was with XXXX. In XXXX 20...
NaN
Nationstar Mortgage
NY
103XX
...
Consent provided
10/27/2016
Closed with explanation
Yes
No
2182081
236688
221161
64958.9
Consent provided
125654
11/18/2016
Mortgage
Other mortgage
Application, originator, mortgage broker
NaN
XXXX XXXX has had complaints filed against him...
NaN
Integrity First Financial Group, Inc.
MO
631XX
...
Consent provided
11/18/2016
Closed with explanation
No
NaN
2215900
74632.7
57103
182861
Consent provided
125674
12/13/2016
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
On XX/XX/2016, I used online bill pay through ...
Company believes it acted appropriately as aut...
Ditech Financial LLC
WI
535XX
...
Consent provided
12/13/2016
Closed with explanation
Yes
NaN
2247724
136799
114342
106343
Consent provided
10000000
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
...
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
WUT
26811 rows × 21 columns
In [42]:
# 16. Select based on a condition using the loc[CONDITION, COLUMN_NAME] notation.
df.loc[df['Product'] == 'Credit card', 'Consumer complaint narrative'].head(5)
Out[42]:
Series([], Name: Consumer complaint narrative, dtype: object)
In [43]:
# 17. Select using loc[] and a list of index values.
df.loc[(13, 19, 22), 'Consumer complaint narrative']
Out[43]:
13 i submitted a payment on XXXX XXXX 2015 for my...
19 Green Tree Financial somehow got XXXX Loan AFT...
22 To whom it may concern, To those that follow t...
Name: Consumer complaint narrative, dtype: object
In [44]:
# 18. Use the [CONDITIONAL] selection to get all complaints from 2015.
df['Date received'] = pd.to_datetime(df['Date received'], errors='coerce')
df.loc[df['Date received'].dt.year == 2015, :] # , : not necessary.
Out[44]:
Date received
Product
Sub-product
Issue
Sub-issue
Consumer complaint narrative
Company public response
Company
State
ZIP code
...
Consumer consent provided?
Date sent to company
Company response to consumer
Timely response?
Consumer disputed?
Complaint ID
Consumer Claim
Company Offer
Amount Received
Custom
13
2015-03-23
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
i submitted a payment on XXXX XXXX 2015 for my...
NaN
Ocwen
IL
627XX
...
Consent provided
3/23/2015
Closed with explanation
Yes
No
1296831
101341
182761
122579
Consent provided
19
2015-03-24
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Green Tree Financial somehow got XXXX Loan AFT...
NaN
Ditech Financial LLC
CA
926XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297594
103382
186433
110905
Consent provided
22
2015-03-24
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
To whom it may concern, To those that follow t...
NaN
Morgan Stanley
CA
944XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297626
219860
153908
99746.4
Consent provided
25
2015-03-24
Mortgage
VA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage servicer, Wells Fargo, did not giv...
NaN
Wells Fargo & Company
TX
770XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1297644
153377
169318
79792.6
Consent provided
33
2015-03-24
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I paid off my mortgage with XXXX Mortgage Serv...
NaN
HSBC North America Holdings Inc.
NY
141XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1299207
105941
123410
89578.6
Consent provided
43
2015-03-24
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was emailed that my online account had been ...
NaN
Wells Fargo & Company
MT
598XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1297874
234463
133848
104833
Consent provided
44
2015-03-19
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX was submitted XX/XX/XXXX. At the time I s...
NaN
Rushmore Loan Management Services LLC
CA
956XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292137
177586
57294.3
89278.8
Consent provided
46
2015-03-19
Mortgage
Reverse mortgage
Application, originator, mortgage broker
NaN
I am very disappointed that the CFPB did not h...
NaN
CIT Bank National Association
NJ
080XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290543
71574.5
24275.9
65055.5
Consent provided
47
2015-03-19
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
We fell behind in our payments back in 2014 fo...
NaN
Nationstar Mortgage
VA
230XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292139
61228.8
80961.1
22089.4
Consent provided
48
2015-03-19
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am a Successor - in -interest to a property ...
NaN
Nationstar Mortgage
CA
925XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290545
180004
214541
29346.5
Consent provided
49
2015-03-19
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I am writing this letter because my mortgage a...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
NJ
080XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292065
136855
-7012.71
70034.7
Consent provided
50
2015-03-19
Mortgage
FHA mortgage
Application, originator, mortgage broker
NaN
I had a mortgage with from XXXX of XXXX to XXX...
NaN
Citizens Financial Group, Inc.
MA
021XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290564
110769
85294
140951
Consent provided
57
2015-03-19
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I made a payment on a {$69000.00} loan of $ XX...
NaN
Specialized Loan Servicing LLC
NJ
074XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290644
171647
167269
115596
Consent provided
58
2015-03-24
Mortgage
Other mortgage
Settlement process and costs
NaN
I applied for a loan modification with Suntrus...
Company chooses not to provide a public response
SunTrust Banks, Inc.
CO
804XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
No
1298042
91360.4
161714
17758.7
Consent provided
64
2015-03-24
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I was {$48.00} behind on our mortgage because ...
NaN
Ditech Financial LLC
MA
020XX
...
Consent provided
3/24/2015
Closed with non-monetary relief
Yes
Yes
1298116
186817
228401
134987
Consent provided
69
2015-03-19
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I have been trying to get an audit of my accou...
NaN
Citibank
MD
207XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1290765
174172
79753
101711
Consent provided
72
2015-03-27
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
We had a Line of Credit with US Bank that was ...
Company chooses not to provide a public response
U.S. Bancorp
CO
801XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304648
183467
130951
141618
Consent provided
81
2015-03-27
Mortgage
Other mortgage
Loan servicing, payments, escrow account
NaN
Ocwen financial services claims simultaneously...
NaN
Ocwen
MA
017XX
...
Consent provided
4/1/2015
Closed with explanation
Yes
No
1304057
94292.8
136124
123227
Consent provided
87
2015-03-19
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
I had a mortgage with XXXX XXXX XXXX from XXXX...
NaN
Nationstar Mortgage
TX
775XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1290871
213280
157676
79534.2
Consent provided
88
2015-03-24
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I schedule my mortgage payment, using the mort...
Company believes it acted appropriately as aut...
Nationstar Mortgage
GA
300XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
Yes
1298322
109029
74100.1
40478.8
Consent provided
101
2015-03-27
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
My wife and I just went through 7 months of ap...
Company chooses not to provide a public response
U.S. Bancorp
KS
664XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
Yes
1304971
182034
114693
67510.8
Consent provided
102
2015-03-27
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We have been working or a Short Sale for Selec...
Company believes it acted appropriately as aut...
Select Portfolio Servicing, Inc
FL
333XX
...
Consent provided
3/27/2015
Closed with explanation
Yes
No
1304692
150719
165691
136517
Consent provided
104
2015-03-19
Mortgage
Conventional fixed mortgage
Settlement process and costs
NaN
I got behind in payments and worked with B of ...
Company chooses not to provide a public response
Bank of America
CA
926XX
...
Consent provided
3/19/2015
Closed with monetary relief
Yes
No
1291084
127616
66064.1
77037.9
Consent provided
107
2015-03-24
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Yesterday, I called my mortgage company, Ocwen...
NaN
Ocwen
TX
770XX
...
Consent provided
3/24/2015
Closed with explanation
Yes
No
1298656
150701
167926
53600.1
Consent provided
121
2015-03-19
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Wells Fargo Mortgage began foreclosure action ...
NaN
Wells Fargo & Company
AZ
853XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1291277
166114
81243.7
26314.2
Consent provided
122
2015-03-24
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Caliber Home loans has claimed to have made pa...
NaN
Caliber Home Loans, Inc
IN
463XX
...
Consent provided
3/25/2015
Closed with explanation
Yes
No
1298770
198869
127222
104428
Consent provided
127
2015-03-19
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
Our Mortgage was sold to Carrington Mortgage S...
NaN
Carrington Mortgage Holdings, LLC.
TX
755XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
No
1292613
249758
136787
71294.5
Consent provided
131
2015-03-27
Mortgage
FHA mortgage
Loan modification,collection,foreclosure
NaN
I was part of the XXXX and received payment la...
Company chooses not to provide a public response
Bank of America
GA
309XX
...
Consent provided
4/6/2015
Closed with explanation
Yes
Yes
1305325
169980
91967.1
12702.5
Consent provided
139
2015-03-19
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
We are a victim of Ocwen mortgage and their fr...
NaN
Ocwen
KS
666XX
...
Consent provided
3/19/2015
Closed with explanation
Yes
Yes
1292075
200978
208274
140896
Consent provided
146
2015-03-28
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
Please know I greatly appreciate your assistan...
NaN
Seterus, Inc.
FL
331XX
...
Consent provided
3/28/2015
Closed with explanation
Yes
Yes
1305831
192776
176085
46461.8
Consent provided
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
88107
2015-03-31
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
Had XXXX mortgage loans w/XXXX bank paying rig...
NaN
Specialized Loan Servicing LLC
NC
283XX
...
Consent provided
3/31/2015
Closed with explanation
Yes
No
1309063
116107
145928
104116
Consent provided
88316
2015-07-17
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
I made a timely appeal request and no written ...
Company chooses not to provide a public response
Bank of America
CA
921XX
...
Consent provided
7/17/2015
Closed with explanation
Yes
Yes
1473742
244570
126394
64244.9
Consent provided
92597
2015-11-24
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
XXXX XXXX, XXXX I took out a mortgage XXXX. Le...
Company chooses not to provide a public response
Bank of America
MO
641XX
...
Consent provided
11/24/2015
Closed with explanation
Yes
Yes
1670459
235520
144844
-8402.13
Consent provided
94752
2015-07-30
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
On the day before we locked in a mortgage rate...
NaN
The J. G. Wentworth Company
TX
774XX
...
Consent provided
7/30/2015
Closed with explanation
Yes
No
1495583
116958
111223
93092.7
Consent provided
94760
2015-07-06
Mortgage
FHA mortgage
Loan servicing, payments, escrow account
NaN
My mortgage was due on XXXX XXXX with a grace ...
Company chooses not to provide a public response
The J. G. Wentworth Company
DC
200XX
...
Consent provided
7/6/2015
Closed with explanation
Yes
Yes
1451533
193369
169920
58956.4
Consent provided
99906
2015-09-22
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
I am a victim of the Wells Fargo modification ...
Company chooses not to provide a public response
Wells Fargo & Company
VA
234XX
...
Consent provided
9/23/2015
Closed with explanation
Yes
No
1574939
132885
145971
87272.2
Consent provided
101075
2015-05-21
Mortgage
Conventional adjustable mortgage (ARM)
Credit decision / Underwriting
NaN
i recently applied for a mortgage with key ban...
NaN
KeyCorp
NY
109XX
...
Consent provided
5/28/2015
Closed with explanation
Yes
No
1387582
97850.1
97956.2
128679
Consent provided
101087
2015-05-01
Mortgage
Other mortgage
Loan modification,collection,foreclosure
NaN
I had a house in XXXX OR. I paid the mortgage ...
NaN
KeyCorp
OR
970XX
...
Consent provided
5/1/2015
Closed with explanation
Yes
No
1356103
144119
70607.8
95825.6
Consent provided
101099
2015-06-08
Mortgage
Other mortgage
Credit decision / Underwriting
NaN
I noticed a hard inquiry on my credit from XXX...
NaN
KeyCorp
OH
445XX
...
Consent provided
6/25/2015
Closed with explanation
Yes
No
1411163
174936
68985
133895
Consent provided
101108
2015-06-23
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
a ) KeyBank stopped using the existing ACH deb...
NaN
KeyCorp
UT
843XX
...
Consent provided
6/23/2015
Closed with monetary relief
Yes
No
1433280
111890
177223
43462.5
Consent provided
101124
2015-11-11
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
I am attempting to sell my current home and to...
NaN
KeyCorp
PA
180XX
...
Consent provided
11/16/2015
Closed with explanation
Yes
No
1650592
118159
189332
68575.1
Consent provided
101133
2015-05-12
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I WAS ASSESSED ATTORNEY FEES ON XXXX/XXXX/15 {...
NaN
KeyCorp
TX
752XX
...
Consent provided
5/12/2015
Closed with monetary relief
Yes
No
1371897
161013
59633.3
35246.2
Consent provided
101135
2015-10-21
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
Subject : Loan Modification RMA was Denied. Ho...
NaN
KeyCorp
UT
840XX
...
Consent provided
10/21/2015
Closed with explanation
Yes
No
1617229
177345
117303
57205.2
Consent provided
101157
2015-08-27
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
Attachment for Keybank : Foreclosure Fraud Rev...
NaN
KeyCorp
NY
140XX
...
Consent provided
8/27/2015
Closed with explanation
Yes
No
1539524
239930
79838.3
6881.11
Consent provided
101162
2015-10-13
Mortgage
Home equity loan or line of credit
Loan servicing, payments, escrow account
NaN
I have a XXXX on my house in XXXX Ca. with Key...
NaN
KeyCorp
CA
923XX
...
Consent provided
10/13/2015
Closed with explanation
Yes
No
1604404
196873
105557
132959
Consent provided
101165
2015-03-28
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
I had a Home Equity about to go into repayment...
NaN
KeyCorp
ME
042XX
...
Consent provided
4/2/2015
Closed with explanation
Yes
No
1306077
221706
118488
69762.8
Consent provided
101190
2015-04-30
Mortgage
Home equity loan or line of credit
Loan modification,collection,foreclosure
NaN
What Happened? \r\r\n\r\r\nSubject : Key Bank ...
NaN
KeyCorp
UT
840XX
...
Consent provided
4/30/2015
Closed with explanation
Yes
No
1354175
190724
116709
113335
Consent provided
101196
2015-12-15
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
I bought a house in XXXX XXXX, 2014. We extens...
NaN
KeyCorp
OH
453XX
...
Consent provided
12/15/2015
Closed with explanation
Yes
No
1697825
110456
225628
140131
Consent provided
105493
2015-09-16
Mortgage
Conventional adjustable mortgage (ARM)
Application, originator, mortgage broker
NaN
I wish to remain anonymous. Recently, I found ...
NaN
Pacific Financial Group (Closed)
CA
945XX
...
Consent provided
9/24/2015
Untimely response
No
NaN
1567606
118853
160066
161484
Consent provided
106142
2015-07-07
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
This is a situation of being ignored by Chase ...
NaN
JPMorgan Chase & Co.
MA
020XX
...
Consent provided
7/7/2015
Closed with explanation
Yes
Yes
1453980
193864
109148
20322.8
Consent provided
106453
2015-07-29
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
this is a complaint I also filed with the XXXX...
NaN
JPMorgan Chase & Co.
MA
020XX
...
Consent provided
7/29/2015
Closed with explanation
Yes
Yes
1493323
167511
87399.3
73377.1
Consent provided
106590
2015-08-19
Mortgage
Conventional adjustable mortgage (ARM)
Loan servicing, payments, escrow account
NaN
I just days ago got from XXXX a credit report ...
NaN
JPMorgan Chase & Co.
MA
020XX
...
Consent provided
8/19/2015
Closed with explanation
Yes
Yes
1525497
165432
133992
33335.6
Consent provided
109394
2015-09-23
Mortgage
Conventional fixed mortgage
Loan servicing, payments, escrow account
NaN
This complaint is in reference to First Niagar...
NaN
First Niagara Bank
PA
180XX
...
Consent provided
9/25/2015
Closed with explanation
Yes
Yes
1575699
99264.6
163700
133659
Consent provided
109465
2015-10-14
Mortgage
Conventional fixed mortgage
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX I had been hurt at work and was una...
NaN
First Niagara Bank
NY
109XX
...
Consent provided
10/14/2015
Closed with explanation
Yes
No
1605919
166691
107072
87320.8
Consent provided
115638
2015-08-03
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I refinanced my home with MLD mortgage. They w...
NaN
MLD Mortgage, Inc.
FL
329XX
...
Consent provided
8/3/2015
Closed with explanation
No
No
1500004
105920
163155
85054.3
Consent provided
116479
2015-04-24
Mortgage
Home equity loan or line of credit
Application, originator, mortgage broker
NaN
I declared Bankruptcy in XXXX XXXX and it was ...
NaN
Capital One
GA
300XX
...
Consent provided
4/24/2015
Closed with explanation
Yes
Yes
1345410
83190.1
85096.3
75395.9
Consent provided
116618
2015-04-14
Mortgage
Conventional fixed mortgage
Credit decision / Underwriting
NaN
We applied for a mortgage from Mortgage Master...
Company believes it acted appropriately as aut...
LoanDepot
MA
024XX
...
Consent provided
12/12/2016
Closed with explanation
Yes
Yes
1328746
32705.8
109451
73227.9
Consent provided
120778
2015-08-13
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
I made a mortgage application with I3 lending ...
NaN
i3 Lending, Inc
MI
495XX
...
Consent provided
9/10/2015
Closed with non-monetary relief
No
NaN
1517500
235166
111091
149341
Consent provided
121251
2015-07-11
Mortgage
Conventional fixed mortgage
Application, originator, mortgage broker
NaN
In XXXX, 2015 We were refinancing our mortgage...
Company chooses not to provide a public response
Bank of America
NY
117XX
...
Consent provided
7/11/2015
Closed with explanation
Yes
No
1463527
176649
104050
74178.2
Consent provided
125553
2015-06-30
Mortgage
Conventional adjustable mortgage (ARM)
Loan modification,collection,foreclosure
NaN
XX/XX/XXXX Immediate concern: Stop the forec...
Company chooses not to provide a public response
Wells Fargo & Company
CA
943XX
...
Consent provided
6/30/2015
Closed with explanation
Yes
No
1444123
152880
102194
173177
Consent provided
12327 rows × 21 columns
Content source: theonaun/notebooks
Similar notebooks: