Pandas Selection Exercises

See also: Indexing and Selecting Data



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