Importing the accounts manager data
library(reshape2)
library(dplyr)
##
## Attaching package: 'dplyr'
##
## The following objects are masked from 'package:stats':
##
## filter, lag
##
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
AccountsManager <- read.csv("C:/Users/localadmin/Downloads/New folder/AccountsManager.csv")
View(AccountsManager)
Removing the duplicates
duplicated(AccountsManager)
## [1] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [12] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [23] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [34] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [45] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [56] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [67] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [78] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [89] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE
## [100] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [111] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [122] FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE TRUE FALSE FALSE
## [133] FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [144] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [155] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [166] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [177] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [188] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [199] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [210] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [221] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [232] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [243] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [254] FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [265] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [276] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [287] TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [298] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [309] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [320] FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE
## [331] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [342] FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE
## [353] FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE FALSE FALSE
## [364] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [375] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [386] FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [397] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE
## [408] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [419] FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE TRUE
## [430] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [441] FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE
## [452] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [463] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [474] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [485] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE
## [496] FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE FALSE
## [507] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE
## [518] TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
## [529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE
## [540] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE
## [551] FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
AccountsManager[duplicated(AccountsManager),]
## Customer_Id Firstname LastName Address1
## 77 1234567925 Solange Shinko Mosocco Ronald A
## 84 1234568025 Beatriz Corrington Prohab Rehabilitation Servs
## 94 1234568353 Tegan Arceo Ceramic Tile Sales Inc
## 98 1234568237 Roselle Estell Mcglynn Bliss Pc
## 126 1234568314 Rikki Nayar Targan & Kievit Pa
## 129 1234568062 Eun Coody Ray Carolyne Realty
## 130 1234568313 Keneth Borgman Centerline Engineering
## 135 1234567982 Danica Bruschke Stevens Charles T
## 144 1234568150 Jade Farrar Bonnet & Daughter
## 154 1234568227 Kate Keneipp Davis Maxon R Esq
## 165 1234568245 Audry Yaw Mike Uchrin Htg & Air Cond Inc
## 206 1234568052 Larae Gudroe Lehigh Furn Divsn Lehigh
## 256 1234568156 Johnna Engelberg Thrifty Oil Co
## 268 1234567895 Simona Morasca Chapman Ross E Esq
## 273 1234568187 Kayleigh Lace Dentalaw Divsn Hlth Care
## 283 1234568101 Willodean Konopacki Magnuson
## 287 1234568276 Gail Kitty Service Supply Co Inc
## 293 1234568047 Lizette Stem Edward S Katz
## 301 1234568222 Leonora Mauson Insty Prints
## 306 1234568143 Heike Berganza Cali Sportswear Cutting Dept
## 312 1234568284 Mireya Frerking Roberts Supply Co Inc
## 324 1234568169 Garry Keetch Italian Express Franchise Corp
## 326 1234568352 Izetta Dewar Lisatoni Jean Esq
## 344 1234568305 Ettie Hoopengardner Jackson Millwork Co
## 347 1234568029 Valentin Klimek Schmid Gayanne K Esq
## 351 1234567973 Dominque Dickerson E A I Electronic Assocs Inc
## 356 1234568065 Layla Springe Chadds Ford Winery
## 359 1234568322 Clorinda Heimann Haughey Charles Jr
## 361 1234567943 Marjory Mastella Vicon Corporation
## 370 1234567956 Penney Weight Hawaiian King Hotel
## 378 1234568139 Portia Stimmel Peace Christian Center
## 383 1234568094 Ronny Caiafa Remaco Inc
## 389 1234567933 Lavera Perin Abc Enterprises Inc
## 392 1234568221 Kirk Herritt Hasting H Duane Esq
## 403 1234567922 Ernie Stenseth Knwz Newsradio
## 405 1234567970 Devorah Chickering Garrison Ind
## 408 1234568366 Glory Schieler Mcgraths Seafood
## 423 1234568261 Izetta Funnell Baird Kurtz & Dobson
## 424 1234567907 Gladys Rim T M Byxbee Company Pc
## 429 1234568372 Gilma Liukko Sammys Steak Den
## 437 1234568258 Quentin Birkner Spoor Behrins Campbell & Young
## 445 1234568096 Norah Waymire Carmichael Jeffery L Esq
## 446 1234568317 Trinidad Mcrae Water Office
## 455 1234568207 Hermila Thyberg Chilton Malting Co
## 470 1234568300 Mitzie Hudnall Cangro Transmission Co
## 484 1234568130 Lashon Vizarro Sentry Signs
## 489 1234568033 Audra Kohnert Nelson Karolyn King Esq
## 493 1234568149 Skye Fillingim Rodeway Inn
## 501 1234568006 Shawna Palaspas Windsor James L Esq
## 503 1234568323 Dick Wenzinger Wheaton Plastic Products
## 511 1234568072 Junita Brideau Leonards Antiques Inc
## 515 1234568069 Nelida Sawchuk Anchorage Museum Of Hist & Art
## 518 1234568255 Linn Paa Valerie & Company
## 523 1234567959 Vallie Mondella Private Properties
## 536 1234568000 Edna Miceli Sampler
## 537 1234568036 Gearldine Gellinger Megibow & Edwards
## 540 1234568066 Joesph Degonia A R Packaging
## 548 1234567928 Valentine Gillian Fbs Business Finance
## 550 1234568007 Brandon Callaro Jackson Shields Yeiser
## 553 1234568257 Wynell Dorshorst Haehnel Craig W Esq
## 557 1234568210 Roosevelt Hoffis Denbrook Myron
## Address2 City County State
## 77 426 Wolf St Metairie Jefferson LA
## 84 481 W Lemon St Middleboro Plymouth MA
## 94 62260 Park Stre Monroe Township Middlesex NJ
## 98 8116 Mount Vernon Ave Bucyrus Crawford OH
## 126 1644 Clove Rd Miami Miami-Dade FL
## 129 84 Bloomfield Ave Spartanburg Spartanburg SC
## 130 86350 Roszel Rd Phoenix Maricopa AZ
## 135 840 15th Ave Waco McLennan TX
## 144 6882 Torresdale Ave Columbia Richland SC
## 154 33 N Michigan Ave Green Bay Brown WI
## 165 70295 Pioneer Ct Brandon Hillsborough FL
## 206 6651 Municipal Rd Houma Terrebonne LA
## 256 5 S Colorado Blvd #449 Bothell Snohomish WA
## 268 3 Mcauley Dr Ashland Ashland OH
## 273 43 Huey P Long Ave Lafayette Lafayette LA
## 283 55 Hawthorne Blvd Lafayette Lafayette LA
## 287 735 Crawford Dr Anchorage Anchorage AK
## 293 501 N 19th Ave Cherry Hill Camden NJ
## 301 3381 E 40th Ave Passaic Passaic NJ
## 306 3 Railway Ave #75 Little Falls Passaic NJ
## 312 8429 Miller Rd Pelham Westchester NY
## 324 5 Green Pond Rd #4 Southampton Bucks PA
## 326 2 W Scyene Rd #3 Baltimore Baltimore City MD
## 344 39 Franklin Ave Richland Benton WA
## 347 137 Pioneer Way Chicago Cook IL
## 351 69 Marquette Ave Hayward Alameda CA
## 356 229 N Forty Driv New York New York NY
## 359 105 Richmond Valley Rd Escondido San Diego CA
## 361 71 San Mateo Ave Wayne Delaware PA
## 370 18 Fountain St Anchorage Anchorage AK
## 378 3732 Sherman Ave Bridgewater Somerset NJ
## 383 73 Southern Blvd Philadelphia Philadelphia PA
## 389 678 3rd Ave Miami Miami-Dade FL
## 392 88 15th Ave Ne Vestal Broome NY
## 403 45 E Liberty St Ridgefield Park Bergen NJ
## 405 31 Douglas Blvd #950 Clovis Curry NM
## 408 5 E Truman Rd Abilene Taylor TX
## 423 82 Winsor St #54 Atlanta Dekalb GA
## 424 322 New Horizon Blvd Milwaukee Milwaukee WI
## 429 16452 Greenwich St Garden City Nassau NY
## 437 7061 N 2nd St Burnsville Dakota MN
## 445 6 Middlegate Rd #106 San Francisco San Francisco CA
## 446 10276 Brooks St San Francisco San Francisco CA
## 455 1 Rancho Del Mar Shopping C Providence Providence RI
## 470 17 Jersey Ave Englewood Arapahoe CO
## 484 433 Westminster Blvd #590 Roseville Placer CA
## 489 134 Lewis Rd Nashville Davidson TN
## 493 25 Minters Chapel Rd #9 Minneapolis Hennepin MN
## 501 5 N Cleveland Massillon Rd Thousand Oaks Ventura CA
## 503 22 Spruce St #595 Gardena Los Angeles CA
## 511 6 S Broadway St Cedar Grove Essex NJ
## 515 3 State Route 35 S Paramus Bergen NJ
## 518 1 S Pine St Memphis Shelby TN
## 523 74 W College St Boise Ada ID
## 536 555 Main St Erie Erie PA
## 537 4 Bloomfield Ave Irving Dallas TX
## 540 2887 Knowlton St #5435 Berkeley Alameda CA
## 548 775 W 17th St San Antonio Bexar TX
## 550 7 Benton Dr Honolulu Honolulu HI
## 553 94290 S Buchanan St Pacifica San Mateo CA
## 557 60 Old Dover Rd Hialeah Miami-Dade FL
## Zipcode Phone1 Phone1.1 Email
## 77 70002 504-979-9175 504-265-8174 solange@shinko.com
## 84 2346 508-584-4279 508-315-3867 beatriz@yahoo.com
## 94 8831 732-730-2692 732-705-6719 tegan.arceo@arceo.org
## 98 44820 419-571-5920 419-488-6648 roselle.estell@hotmail.com
## 126 33155 305-968-9487 305-978-2069 rikki@nayar.com
## 129 29301 864-256-3620 864-594-4578 eun@yahoo.com
## 130 85012 602-919-4211 602-442-3092 keneth@yahoo.com
## 135 76708 254-782-8569 254-205-1422 danica_bruschke@gmail.com
## 144 29201 803-352-5387 803-975-3405 jade.farrar@yahoo.com
## 154 54301 920-353-6377 920-355-1610 kate_keneipp@yahoo.com
## 165 33511 813-797-4816 813-744-7100 audry.yaw@yaw.org
## 206 70360 985-890-7262 985-261-5783 larae_gudroe@gmail.com
## 256 98021 425-986-7573 425-700-3751 jengelberg@engelberg.org
## 268 44805 419-503-2484 419-800-6759 simona@morasca.com
## 273 70508 337-740-9323 337-751-2326 kayleigh.lace@yahoo.com
## 283 70506 337-253-8384 337-774-7564 willodean_konopacki@konopacki.org
## 287 99501 907-435-9166 907-770-3542 gail@kitty.com
## 293 8002 856-487-5412 856-702-3676 lizette.stem@aol.com
## 301 7055 973-412-2995 973-355-2120 leonora@yahoo.com
## 306 7424 973-936-5095 973-822-8827 heike@gmail.com
## 312 10803 914-868-5965 914-883-3061 mireya.frerking@hotmail.com
## 324 18966 215-979-8776 215-846-9046 garry_keetch@hotmail.com
## 326 21217 410-473-1708 410-522-7621 idewar@dewar.com
## 344 99352 509-755-5393 509-847-3352 ettie.hoopengardner@hotmail.com
## 347 60604 312-303-5453 312-512-2338 vklimek@klimek.org
## 351 94545 510-993-3758 510-901-7640 dominque.dickerson@dickerson.org
## 356 10011 212-260-3151 212-253-7448 layla.springe@cox.net
## 359 92025 760-291-5497 760-261-4786 clorinda.heimann@hotmail.com
## 361 19087 610-814-5533 610-379-7125 mmastella@mastella.com
## 370 99515 907-797-9628 907-873-2882 penney_weight@aol.com
## 378 8807 908-722-7128 908-670-4712 portia.stimmel@aol.com
## 383 19103 215-605-7570 215-511-3531 ronny.caiafa@caiafa.org
## 389 33196 305-606-7291 305-995-2078 lperin@perin.org
## 392 13850 607-407-3716 607-350-7690 kirk.herritt@aol.com
## 403 7660 201-709-6245 201-387-9093 ernie_stenseth@aol.com
## 405 88101 505-975-8559 505-950-1763 devorah@hotmail.com
## 408 79602 325-869-2649 325-740-3778 glory@yahoo.com
## 423 30340 770-844-3447 770-584-4119 izetta.funnell@hotmail.com
## 424 53207 414-661-9598 414-377-2880 gladys.rim@rim.org
## 429 11530 516-393-9967 516-407-9573 gilma_liukko@gmail.com
## 437 55337 952-702-7993 952-314-5871 qbirkner@aol.com
## 445 94107 415-306-7897 415-874-2984 norah.waymire@gmail.com
## 446 94105 415-331-9634 415-419-1597 trinidad_mcrae@yahoo.com
## 455 2903 401-893-4882 401-885-7681 hermila_thyberg@hotmail.com
## 470 80110 303-402-1940 303-997-7760 mitzie_hudnall@yahoo.com
## 484 95661 916-741-7884 916-289-4526 lashon@aol.com
## 489 37211 615-406-7854 615-448-9249 audra@kohnert.com
## 493 55401 612-508-2655 612-664-6304 skye_fillingim@yahoo.com
## 501 91362 805-275-3566 805-638-6617 shawna_palaspas@palaspas.org
## 503 90248 310-510-9713 310-936-2258 dick@yahoo.com
## 511 7009 973-943-3423 973-582-5469 jbrideau@aol.com
## 515 7652 201-971-1638 201-247-8925 nelida@gmail.com
## 518 38112 901-412-4381 901-573-9024 linn_paa@paa.com
## 523 83707 208-862-5339 208-737-8439 vmondella@mondella.com
## 536 16502 814-460-2655 814-299-2877 emiceli@miceli.org
## 537 75061 972-934-6914 972-821-7118 gearldine_gellinger@gellinger.com
## 540 94710 510-677-9785 510-942-5916 joesph_degonia@degonia.org
## 548 78204 210-812-9597 210-300-6244 valentine_gillian@gmail.com
## 550 96819 808-215-6832 808-240-5168 brandon_callaro@hotmail.com
## 553 94044 650-473-1262 650-749-9879 wynell_dorshorst@dorshorst.org
## 557 33014 305-622-4739 305-302-1135 roosevelt.hoffis@aol.com
## Agegroup
## 77 20-25
## 84 25-35
## 94 35-45
## 98 25-35
## 126 <20
## 129 25-35
## 130 >45
## 135 35-45
## 144 20-25
## 154 25-35
## 165 25-35
## 206 35-45
## 256 <20
## 268 <20
## 273 25-35
## 283 <20
## 287 20-25
## 293 20-25
## 301 25-35
## 306 <20
## 312 >45
## 324 >45
## 326 25-35
## 344 25-35
## 347 20-25
## 351 <20
## 356 <20
## 359 20-25
## 361 >45
## 370 20-25
## 378 20-25
## 383 <20
## 389 >45
## 392 20-25
## 403 >45
## 405 25-35
## 408 25-35
## 423 25-35
## 424 25-35
## 429 35-45
## 437 >45
## 445 25-35
## 446 35-45
## 455 35-45
## 470 25-35
## 484 <20
## 489 <20
## 493 <20
## 501 20-25
## 503 25-35
## 511 25-35
## 515 >45
## 518 20-25
## 523 >45
## 536 <20
## 537 25-35
## 540 20-25
## 548 >45
## 550 25-35
## 553 35-45
## 557 20-25
AccntManger<-unique(AccountsManager)
Importing the clickstream output ofdata
ClickStream_output <- read.csv("C:/Users/localadmin/Downloads/New folder/ClickStream_output.csv")
View(ClickStream_output)
Sorting of the accounts manager data
AccntManger<-AccntManger[order(AccntManger$Agegroup),]
Importing the customer social score data
CustomerSocialScore <- read.csv("C:/Users/localadmin/Downloads/New folder/CustomerSocialScore.csv")
View(CustomerSocialScore)
Importing the custtrans_internal data
CustTrans_Internal <- read.csv("C:/Users/localadmin/Downloads/New folder/CustTrans_Internal.csv")
View(CustTrans_Internal)
Importing the equifaxdata_external data
equifaxdata_external <- read.csv("C:/Users/localadmin/Downloads/New folder/equifaxdata_external.csv")
View(equifaxdata_external)
Merging accounts manager data and clickstream
Merging1 <-merge(AccntManger,ClickStream_output,all = TRUE)
Merging 1 and customer social score data
Merging2<-merge(Merging1,CustomerSocialScore,all=TRUE)
Merging 2 and equifaxdata_external data
Merging3<-merge(Merging2,equifaxdata_external,all = TRUE)
Creating a new variable for email domain
Merging3["MY_NEW_COLUMN"] <- Merging3["Email"]
Frequency of email domain
domain<-colsplit(Merging3$Email,"@",c("emailname","emaildomain"))
domain$emaildomain<-as.factor(domain$emaildomain)
merge5<- cbind(Merging3,name=domain$emaildomain)
a<-data.frame(table(domain$emaildomain))
a
## Var1 Freq
## 1 angalich.com 1
## 2 ankeny.org 1
## 3 aol.com 64
## 4 aquas.com 1
## 5 arceo.org 1
## 6 arias.org 1
## 7 barfield.com 1
## 8 beech.com 1
## 9 berlanga.com 1
## 10 bowley.org 1
## 11 brachle.org 1
## 12 briddick.com 1
## 13 brossart.com 1
## 14 buemi.com 1
## 15 burnard.com 1
## 16 caiafa.org 1
## 17 canlas.com 1
## 18 caudy.org 1
## 19 centini.org 1
## 20 chaffins.org 1
## 21 chavous.org 1
## 22 chui.com 1
## 23 colaizzo.com 1
## 24 cookey.org 1
## 25 corrio.com 1
## 26 cousey.org 1
## 27 cox.net 70
## 28 craghead.org 1
## 29 cronauer.com 1
## 30 crupi.com 1
## 31 darakjy.org 1
## 32 daufeldt.com 1
## 33 degonia.org 1
## 34 degroot.org 1
## 35 deleo.com 1
## 36 denooyer.org 1
## 37 dewar.com 1
## 38 dickerson.org 1
## 39 dopico.org 1
## 40 dorshorst.org 1
## 41 emard.com 1
## 42 engelberg.org 1
## 43 felger.org 1
## 44 fishburne.com 1
## 45 fortino.com 1
## 46 frey.com 1
## 47 galam.org 1
## 48 gato.org 1
## 49 gellinger.com 1
## 50 gesick.org 1
## 51 gillaspie.com 1
## 52 glick.com 1
## 53 gmail.com 68
## 54 gobern.org 1
## 55 grenet.org 1
## 56 haroldson.org 1
## 57 hauenstein.org 1
## 58 hellickson.org 1
## 59 hixenbaugh.org 1
## 60 hoa.org 1
## 61 hollack.org 1
## 62 honeywell.com 1
## 63 hotmail.com 71
## 64 jacobos.com 1
## 65 julia.org 1
## 66 kampa.org 1
## 67 kitty.com 1
## 68 klimek.org 1
## 69 kohnert.com 1
## 70 konopacki.org 1
## 71 koppinger.com 1
## 72 kulzer.org 1
## 73 lapage.com 1
## 74 lietz.com 1
## 75 lindall.com 1
## 76 lipkin.com 1
## 77 loader.com 1
## 78 loder.org 1
## 79 lother.com 1
## 80 malvin.com 1
## 81 mastella.com 1
## 82 mccullan.com 1
## 83 mclaird.com 1
## 84 melnyk.com 1
## 85 meteer.com 1
## 86 miceli.org 1
## 87 mirafuentes.com 1
## 88 monarrez.org 1
## 89 mondella.com 1
## 90 morasca.com 1
## 91 mulqueen.org 1
## 92 nayar.com 1
## 93 newville.com 1
## 94 nicolozakes.org 1
## 95 nunlee.org 1
## 96 onofrio.com 1
## 97 ostrosky.com 1
## 98 paa.com 1
## 99 palaspas.org 1
## 100 parvis.com 1
## 101 patak.org 1
## 102 pelkowski.org 1
## 103 perez.org 1
## 104 perin.org 1
## 105 perruzza.com 1
## 106 pontoriero.com 1
## 107 poullion.com 1
## 108 regusters.com 1
## 109 reitler.com 1
## 110 restrepo.com 1
## 111 rhym.com 1
## 112 rim.org 1
## 113 royster.com 1
## 114 sarao.org 1
## 115 saulter.com 1
## 116 saylors.org 1
## 117 schmierer.org 1
## 118 schoeneck.org 1
## 119 scipione.com 1
## 120 semidey.com 1
## 121 setter.org 1
## 122 shin.com 1
## 123 shinko.com 1
## 124 shire.com 1
## 125 silvestrini.com 1
## 126 similton.com 1
## 127 slusarski.com 1
## 128 spickerman.com 1
## 129 staback.com 1
## 130 suffield.org 1
## 131 sweigard.com 1
## 132 tegarden.com 1
## 133 toyama.org 1
## 134 uyetake.org 1
## 135 vanausdal.org 1
## 136 venere.org 1
## 137 villanueva.com 1
## 138 vocelka.com 1
## 139 vonasek.org 1
## 140 walthall.org 1
## 141 worlds.com 1
## 142 yahoo.com 86
## 143 yaw.org 1
## 144 yglesias.com 1
## 145 zane.com 1
## 146 zurcher.org 1
n<- domain %>% mutate(emaildomain,domainfreq = frequency(emaildomain))
n
## emailname emaildomain domainfreq
## 1 jbutt gmail.com 1
## 2 josephine_darakjy darakjy.org 1
## 3 art venere.org 1
## 4 lpaprocki hotmail.com 1
## 5 donette.foller cox.net 1
## 6 simona morasca.com 1
## 7 mitsue_tollner yahoo.com 1
## 8 leota hotmail.com 1
## 9 sage_wieser cox.net 1
## 10 kris gmail.com 1
## 11 minna_amigon yahoo.com 1
## 12 amaclead gmail.com 1
## 13 kiley.caldarera aol.com 1
## 14 gruta cox.net 1
## 15 calbares gmail.com 1
## 16 mattie aol.com 1
## 17 meaghan hotmail.com 1
## 18 gladys.rim rim.org 1
## 19 yuki_whobrey aol.com 1
## 20 fletcher.flosi yahoo.com 1
## 21 bette_nicka cox.net 1
## 22 vinouye aol.com 1
## 23 willard hotmail.com 1
## 24 mroyster royster.com 1
## 25 alisha slusarski.com 1
## 26 allene_iturbide cox.net 1
## 27 chanel.caudy caudy.org 1
## 28 ezekiel chui.com 1
## 29 wkusko yahoo.com 1
## 30 bfigeroa aol.com 1
## 31 ammie corrio.com 1
## 32 francine_vocelka vocelka.com 1
## 33 ernie_stenseth aol.com 1
## 34 albina glick.com 1
## 35 asergi gmail.com 1
## 36 solange shinko.com 1
## 37 jose yahoo.com 1
## 38 rozella.ostrosky ostrosky.com 1
## 39 valentine_gillian gmail.com 1
## 40 kati.rulapaugh hotmail.com 1
## 41 youlanda aol.com 1
## 42 doldroyd aol.com 1
## 43 roxane hotmail.com 1
## 44 lperin perin.org 1
## 45 erick.ferencz aol.com 1
## 46 fsaylors saylors.org 1
## 47 jina_briddick briddick.com 1
## 48 kanisha_waycott yahoo.com 1
## 49 emerson.bowley bowley.org 1
## 50 bmalet yahoo.com 1
## 51 bbolognia yahoo.com 1
## 52 lnestle hotmail.com 1
## 53 sabra uyetake.org 1
## 54 mmastella mastella.com 1
## 55 karl_klonowski yahoo.com 1
## 56 twenner aol.com 1
## 57 amber_monarrez monarrez.org 1
## 58 shenika gmail.com 1
## 59 delmy.ahle hotmail.com 1
## 60 deeanna_juhas gmail.com 1
## 61 bpugh aol.com 1
## 62 jamal vanausdal.org 1
## 63 cecily hollack.org 1
## 64 carmelina_lindall lindall.com 1
## 65 maurine_yglesias yglesias.com 1
## 66 tawna gmail.com 1
## 67 penney_weight aol.com 1
## 68 elly_morocco gmail.com 1
## 69 ilene.eroman hotmail.com 1
## 70 vmondella mondella.com 1
## 71 kallie.blackwood gmail.com 1
## 72 johnetta_abdallah aol.com 1
## 73 brhym rhym.com 1
## 74 micaela_rhymes gmail.com 1
## 75 tamar hotmail.com 1
## 76 moon yahoo.com 1
## 77 laurel_reitler reitler.com 1
## 78 delisa.crupi crupi.com 1
## 79 viva.toelkes gmail.com 1
## 80 elza yahoo.com 1
## 81 devorah hotmail.com 1
## 82 timothy_mulqueen mulqueen.org 1
## 83 ahoneywell honeywell.com 1
## 84 dominque.dickerson dickerson.org 1
## 85 lettie_isenhower yahoo.com 1
## 86 mmunns cox.net 1
## 87 stephaine barfield.com 1
## 88 lai.gato gato.org 1
## 89 stephen_emigh hotmail.com 1
## 90 tshields gmail.com 1
## 91 twardrip cox.net 1
## 92 cory.gibes gmail.com 1
## 93 danica_bruschke gmail.com 1
## 94 wilda cox.net 1
## 95 elvera.benimadho cox.net 1
## 96 carma cox.net 1
## 97 malinda.hochard yahoo.com 1
## 98 natalie.fern hotmail.com 1
## 99 lisha centini.org 1
## 100 arlene_klusman gmail.com 1
## 101 alease buemi.com 1
## 102 louisa cronauer.com 1
## 103 angella.cetta hotmail.com 1
## 104 cgoldammer cox.net 1
## 105 rosio.cork gmail.com 1
## 106 ckorando hotmail.com 1
## 107 twana.felger felger.org 1
## 108 estrella aol.com 1
## 109 dkines hotmail.com 1
## 110 tiffiny_steffensmeier cox.net 1
## 111 emiceli miceli.org 1
## 112 sue aol.com 1
## 113 jshin shin.com 1
## 114 rolland cox.net 1
## 115 pamella.schmierer schmierer.org 1
## 116 gkulzer kulzer.org 1
## 117 shawna_palaspas palaspas.org 1
## 118 brandon_callaro hotmail.com 1
## 119 scarlet.cartan yahoo.com 1
## 120 oretha_menter yahoo.com 1
## 121 tsmith aol.com 1
## 122 xuan gmail.com 1
## 123 lindsey.dilello hotmail.com 1
## 124 devora_perez perez.org 1
## 125 hdemesa cox.net 1
## 126 rpapasergi cox.net 1
## 127 talia_riopelle aol.com 1
## 128 van.shire shire.com 1
## 129 lucina_lary cox.net 1
## 130 bok.isaacs aol.com 1
## 131 rolande.spickerman spickerman.com 1
## 132 hpaulas gmail.com 1
## 133 kimbery_madarang cox.net 1
## 134 thurman.manno yahoo.com 1
## 135 becky.mirafuentes mirafuentes.com 1
## 136 beatriz yahoo.com 1
## 137 marti.maybury yahoo.com 1
## 138 nieves_gotter gmail.com 1
## 139 lhagele cox.net 1
## 140 vklimek klimek.org 1
## 141 melissa cox.net 1
## 142 sheridan.zane zane.com 1
## 143 bulah_padilla hotmail.com 1
## 144 audra kohnert.com 1
## 145 dweirather aol.com 1
## 146 fjillson aol.com 1
## 147 gearldine_gellinger gellinger.com 1
## 148 chau gmail.com 1
## 149 theola_frey frey.com 1
## 150 cheryl haroldson.org 1
## 151 lmerced gmail.com 1
## 152 carissa.batman yahoo.com 1
## 153 lezlie.craghead craghead.org 1
## 154 oshealy hotmail.com 1
## 155 arminda parvis.com 1
## 156 reita.leto gmail.com 1
## 157 yolando cox.net 1
## 158 lizette.stem aol.com 1
## 159 gpawlowicz yahoo.com 1
## 160 cdeleo deleo.com 1
## 161 chantell yahoo.com 1
## 162 dyum yahoo.com 1
## 163 larae_gudroe gmail.com 1
## 164 latrice.tolfree hotmail.com 1
## 165 kerry.theodorov gmail.com 1
## 166 dhidvegi yahoo.com 1
## 167 fannie.lungren yahoo.com 1
## 168 evangelina aol.com 1
## 169 novella_degroot degroot.org 1
## 170 choa hoa.org 1
## 171 jfallick yahoo.com 1
## 172 irma.wolfgramm hotmail.com 1
## 173 eun yahoo.com 1
## 174 sylvia_cousey cousey.org 1
## 175 nana aol.com 1
## 176 layla.springe cox.net 1
## 177 joesph_degonia degonia.org 1
## 178 annabelle.boord cox.net 1
## 179 stephaine cox.net 1
## 180 nelida gmail.com 1
## 181 marguerita.hiatt gmail.com 1
## 182 ccookey cookey.org 1
## 183 jbrideau aol.com 1
## 184 claribel_varriano cox.net 1
## 185 benton.skursky aol.com 1
## 186 hillary.skulski aol.com 1
## 187 merilyn_bayless cox.net 1
## 188 tennaco gmail.com 1
## 189 merlyn_lawler hotmail.com 1
## 190 gmontezuma cox.net 1
## 191 jmconnell hotmail.com 1
## 192 lemuel.latzke gmail.com 1
## 193 mknipp gmail.com 1
## 194 candida_corbley hotmail.com 1
## 195 karan_karpin gmail.com 1
## 196 andra gmail.com 1
## 197 fpoullion poullion.com 1
## 198 belen_strassner aol.com 1
## 199 gracia melnyk.com 1
## 200 jhanafan gmail.com 1
## 201 barrett.toyama toyama.org 1
## 202 helga_fredicks yahoo.com 1
## 203 apinilla cox.net 1
## 204 fausto_agramonte yahoo.com 1
## 205 ronny.caiafa caiafa.org 1
## 206 marge gmail.com 1
## 207 norah.waymire gmail.com 1
## 208 aliza aol.com 1
## 209 mpelkowski pelkowski.org 1
## 210 viola gmail.com 1
## 211 femard emard.com 1
## 212 willodean_konopacki konopacki.org 1
## 213 beckie.silvestrini silvestrini.com 1
## 214 rgesick gesick.org 1
## 215 frederica_blunk gmail.com 1
## 216 glen_bartolet hotmail.com 1
## 217 freeman_gochal aol.com 1
## 218 vincent.meinerding hotmail.com 1
## 219 rima cox.net 1
## 220 gsarbacher gmail.com 1
## 221 avery cox.net 1
## 222 cristy lother.com 1
## 223 nicolette_brossart brossart.com 1
## 224 tracey hotmail.com 1
## 225 virgina_tegarden tegarden.com 1
## 226 tfrankel aol.com 1
## 227 alaine_bergesen cox.net 1
## 228 earleen_mai cox.net 1
## 229 leonida gobern.org 1
## 230 ressie.auffrey yahoo.com 1
## 231 jmugnolo yahoo.com 1
## 232 eladia saulter.com 1
## 233 chaya malvin.com 1
## 234 gwenn_suffield suffield.org 1
## 235 skarpel cox.net 1
## 236 yoko fishburne.com 1
## 237 taryn.moyd hotmail.com 1
## 238 katina_polidori aol.com 1
## 239 rickie.plumer aol.com 1
## 240 alex loader.com 1
## 241 lashon aol.com 1
## 242 lburnard burnard.com 1
## 243 ceola.setter setter.org 1
## 244 my hotmail.com 1
## 245 lorrine.worlds worlds.com 1
## 246 peggie cox.net 1
## 247 mraymo yahoo.com 1
## 248 daron_dinos cox.net 1
## 249 an_fritz hotmail.com 1
## 250 portia.stimmel aol.com 1
## 251 rhea_aredondo cox.net 1
## 252 bsama cox.net 1
## 253 alyce arias.org 1
## 254 heike gmail.com 1
## 255 carey_dopico dopico.org 1
## 256 dottie hellickson.org 1
## 257 deandrea yahoo.com 1
## 258 kimberlie_duenas yahoo.com 1
## 259 martina_staback staback.com 1
## 260 skye_fillingim yahoo.com 1
## 261 jade.farrar yahoo.com 1
## 262 charlene.hamilton hotmail.com 1
## 263 geoffrey gmail.com 1
## 264 stevie.westerbeck yahoo.com 1
## 265 pamella fortino.com 1
## 266 hhaufler hotmail.com 1
## 267 jengelberg engelberg.org 1
## 268 buddy.cloney yahoo.com 1
## 269 dalene.riden aol.com 1
## 270 jzurcher zurcher.org 1
## 271 hdenooyer denooyer.org 1
## 272 joseph_cryer cox.net 1
## 273 deonna_kippley hotmail.com 1
## 274 raymon.calvaresi gmail.com 1
## 275 alecia aol.com 1
## 276 mlayous hotmail.com 1
## 277 detra aol.com 1
## 278 terrilyn.rodeigues cox.net 1
## 279 slacovara gmail.com 1
## 280 garry_keetch hotmail.com 1
## 281 mneither yahoo.com 1
## 282 theodora.restrepo restrepo.com 1
## 283 noah.kalafatis aol.com 1
## 284 csweigard sweigard.com 1
## 285 lavonda cox.net 1
## 286 junita aol.com 1
## 287 herminia nicolozakes.org 1
## 288 casie.good aol.com 1
## 289 reena hotmail.com 1
## 290 mirta_mallett gmail.com 1
## 291 cathrine.pontoriero pontoriero.com 1
## 292 ftawil hotmail.com 1
## 293 rupthegrove yahoo.com 1
## 294 sarah.candlish gmail.com 1
## 295 lucy cox.net 1
## 296 jaquas aquas.com 1
## 297 yvonne.tjepkema hotmail.com 1
## 298 kayleigh.lace yahoo.com 1
## 299 felix_hirpara cox.net 1
## 300 tresa_sweely hotmail.com 1
## 301 kristeen gmail.com 1
## 302 jregusters regusters.com 1
## 303 renea hotmail.com 1
## 304 olive aol.com 1
## 305 lreiber cox.net 1
## 306 christiane.eschberger yahoo.com 1
## 307 goldie.schirpke yahoo.com 1
## 308 loreta.timenez hotmail.com 1
## 309 fabiola.hauenstein hauenstein.org 1
## 310 amie.perigo yahoo.com 1
## 311 raina.brachle brachle.org 1
## 312 erinn.canlas canlas.com 1
## 313 cherry lietz.com 1
## 314 kattie vonasek.org 1
## 315 lilli aol.com 1
## 316 whitley.tomasulo aol.com 1
## 317 badkin hotmail.com 1
## 318 hermila_thyberg hotmail.com 1
## 319 jesusita.flister hotmail.com 1
## 320 caitlin.julia julia.org 1
## 321 roosevelt.hoffis aol.com 1
## 322 hhalter yahoo.com 1
## 323 lorean.martabano hotmail.com 1
## 324 france.buzick yahoo.com 1
## 325 jferrario hotmail.com 1
## 326 adelina_nabours gmail.com 1
## 327 ddhamer cox.net 1
## 328 jerry.dallen yahoo.com 1
## 329 leota.ragel gmail.com 1
## 330 jamyot hotmail.com 1
## 331 aja_gehrett hotmail.com 1
## 332 kirk.herritt aol.com 1
## 333 leonora yahoo.com 1
## 334 winfred_brucato hotmail.com 1
## 335 tarra.nachor cox.net 1
## 336 corinne loder.org 1
## 337 dulce_labreche yahoo.com 1
## 338 kate_keneipp yahoo.com 1
## 339 kaitlyn.ogg gmail.com 1
## 340 sherita.saras cox.net 1
## 341 lstuer cox.net 1
## 342 ernest cox.net 1
## 343 nobuko.halsey yahoo.com 1
## 344 lavonna.wolny hotmail.com 1
## 345 llizama cox.net 1
## 346 mariann.bilden aol.com 1
## 347 helene aol.com 1
## 348 roselle.estell hotmail.com 1
## 349 sheintzman hotmail.com 1
## 350 margart_meisel yahoo.com 1
## 351 kristofer.bennick yahoo.com 1
## 352 wacuff gmail.com 1
## 353 shalon cox.net 1
## 354 denise patak.org 1
## 355 louvenia.beech beech.com 1
## 356 audry.yaw yaw.org 1
## 357 kristel.ehmann aol.com 1
## 358 vzepp gmail.com 1
## 359 egwalthney yahoo.com 1
## 360 venita_maillard gmail.com 1
## 361 kasandra_semidey semidey.com 1
## 362 xdiscipio gmail.com 1
## 363 mlinahan yahoo.com 1
## 364 krauser cox.net 1
## 365 pdubaldi hotmail.com 1
## 366 linn_paa paa.com 1
## 367 paris hotmail.com 1
## 368 wynell_dorshorst dorshorst.org 1
## 369 qbirkner aol.com 1
## 370 regenia.kannady cox.net 1
## 371 sheron aol.com 1
## 372 izetta.funnell hotmail.com 1
## 373 rodolfo hotmail.com 1
## 374 zona hotmail.com 1
## 375 szagen aol.com 1
## 376 paz_sahagun cox.net 1
## 377 markus yahoo.com 1
## 378 jaclyn aol.com 1
## 379 cyril_daufeldt daufeldt.com 1
## 380 gschnitzler gmail.com 1
## 381 erick_nievas aol.com 1
## 382 jennie cox.net 1
## 383 mscipione scipione.com 1
## 384 cventura yahoo.com 1
## 385 galen yahoo.com 1
## 386 tfeichtner yahoo.com 1
## 387 gail kitty.com 1
## 388 dalene schoeneck.org 1
## 389 gertude.witten gmail.com 1
## 390 lizbeth yahoo.com 1
## 391 gberray gmail.com 1
## 392 lashandra yahoo.com 1
## 393 lnewville newville.com 1
## 394 laurel yahoo.com 1
## 395 mireya.frerking hotmail.com 1
## 396 annelle yahoo.com 1
## 397 dean_ketelsen gmail.com 1
## 398 levi.munis gmail.com 1
## 399 sylvie aol.com 1
## 400 sharee_maile aol.com 1
## 401 cordelia_storment aol.com 1
## 402 mollie_mcdoniel yahoo.com 1
## 403 brett.mccullan mccullan.com 1
## 404 teddy_pedrozo aol.com 1
## 405 tasia_andreason yahoo.com 1
## 406 hubert walthall.org 1
## 407 arthur.farrow yahoo.com 1
## 408 vberlanga berlanga.com 1
## 409 billye_miro cox.net 1
## 410 glenna_slayton cox.net 1
## 411 mitzie_hudnall yahoo.com 1
## 412 bernardine_rodefer yahoo.com 1
## 413 staci_schmaltz aol.com 1
## 414 nichelle_meteer meteer.com 1
## 415 jrhoden yahoo.com 1
## 416 ettie.hoopengardner hotmail.com 1
## 417 eden_jayson yahoo.com 1
## 418 lynelle_auber gmail.com 1
## 419 merissa.tomblin gmail.com 1
## 420 golda_kaniecki yahoo.com 1
## 421 catarina_gleich hotmail.com 1
## 422 vkiel hotmail.com 1
## 423 jolene yahoo.com 1
## 424 keneth yahoo.com 1
## 425 rikki nayar.com 1
## 426 elke_sengbusch yahoo.com 1
## 427 hoa sarao.org 1
## 428 trinidad_mcrae yahoo.com 1
## 429 mari_lueckenbach yahoo.com 1
## 430 selma.husser cox.net 1
## 431 aonofrio onofrio.com 1
## 432 ljurney hotmail.com 1
## 433 clorinda.heimann hotmail.com 1
## 434 dick yahoo.com 1
## 435 ahmed.angalich angalich.com 1
## 436 iluminada.ohms yahoo.com 1
## 437 joanna_leinenbach hotmail.com 1
## 438 caprice aol.com 1
## 439 stephane_myricks cox.net 1
## 440 quentin_swayze yahoo.com 1
## 441 annmarie_castros gmail.com 1
## 442 shonda_greenbush cox.net 1
## 443 clapage lapage.com 1
## 444 jeanice.claucherty yahoo.com 1
## 445 josphine_villanueva villanueva.com 1
## 446 dperruzza perruzza.com 1
## 447 cassi.wildfong aol.com 1
## 448 britt galam.org 1
## 449 adell.lipkin lipkin.com 1
## 450 jacqueline.rowling yahoo.com 1
## 451 lonny_weglarz gmail.com 1
## 452 lonna_diestel gmail.com 1
## 453 cristal cox.net 1
## 454 kenneth.grenet grenet.org 1
## 455 emclaird mclaird.com 1
## 456 ajeanty gmail.com 1
## 457 sharika.eanes aol.com 1
## 458 nu gmail.com 1
## 459 dcomnick cox.net 1
## 460 cecilia_colaizzo colaizzo.com 1
## 461 leslie cox.net 1
## 462 nan koppinger.com 1
## 463 idewar dewar.com 1
## 464 tegan.arceo arceo.org 1
## 465 ruthann hotmail.com 1
## 466 joni_breland cox.net 1
## 467 vrentfro cox.net 1
## 468 colette.kardas yahoo.com 1
## 469 malcolm_tromblay cox.net 1
## 470 ryan cox.net 1
## 471 jess.chaffins chaffins.org 1
## 472 sbourbon yahoo.com 1
## 473 nickolas_juvera cox.net 1
## 474 gary_nunlee nunlee.org 1
## 475 diane cox.net 1
## 476 roslyn.chavous chavous.org 1
## 477 glory yahoo.com 1
## 478 rasheeda aol.com 1
## 479 alpha yahoo.com 1
## 480 refugia.jacobos jacobos.com 1
## 481 shawnda.yori yahoo.com 1
## 482 mdelasancha hotmail.com 1
## 483 gilma_liukko gmail.com 1
## 484 jgabisi hotmail.com 1
## 485 lili.paskin cox.net 1
## 486 loren.asar aol.com 1
## 487 dorothy cox.net 1
## 488 gail_similton similton.com 1
## 489 catalina hotmail.com 1
## 490 lawrence.lorens hotmail.com 1
## 491 carlee.boulter hotmail.com 1
## 492 tankeny ankeny.org 1
## 493 joles gmail.com 1
## 494 alesia_hixenbaugh hixenbaugh.org 1
## 495 lai gmail.com 1
## 496 bgillaspie gillaspie.com 1
## 497 rkampa kampa.org 1
## 498 flo.bookamer cox.net 1
## 499 jbiddy yahoo.com 1
## 500 chauncey_motley aol.com 1
summary(domain$emaildomainfreq)
## Length Class Mode
## 0 NULL NULL
Maximum and minimum number of page visits
summary(Merging3)
## Customer_Id Firstname LastName
## Min. :1.235e+09 Dalene : 2 Abdallah : 1
## 1st Qu.:1.235e+09 Erick : 2 Acey : 1
## Median :1.235e+09 Gail : 2 Acuff : 1
## Mean :1.235e+09 Glory : 2 Adkin : 1
## 3rd Qu.:1.235e+09 Izetta : 2 Agramonte: 1
## Max. :1.235e+09 Jerry : 2 Ahle : 1
## (Other):488 (Other) :494
## Address1 Address2
## 20 20 Printing Inc : 1 1 Central Ave : 1
## A All American Travel Inc : 1 1 Century Park E : 1
## A K Construction Co : 1 1 Commerce Way : 1
## A R Packaging : 1 1 Garfield Ave #7: 1
## Abc Enterprises Inc : 1 1 Huntwood Ave : 1
## Accurel Systems Intrntl Corp: 1 1 Midway Rd : 1
## (Other) :494 (Other) :494
## City County State Zipcode
## New York : 14 Los Angeles: 18 CA : 72 Min. : 1581
## Philadelphia: 8 New York : 14 NJ : 52 1st Qu.:16502
## Chicago : 7 Cook : 13 NY : 46 Median :44139
## Miami : 6 Orange : 11 TX : 32 Mean :47496
## Baltimore : 5 Essex : 9 PA : 29 3rd Qu.:79971
## Gardena : 5 Maricopa : 9 FL : 28 Max. :99712
## (Other) :455 (Other) :426 (Other):241
## Phone1 Phone1.1 Email
## 201-238-5688: 1 201-247-8925: 1 adelina_nabours@gmail.com : 1
## 201-431-2989: 1 201-365-8698: 1 adell.lipkin@lipkin.com : 1
## 201-474-4924: 1 201-387-9093: 1 ahmed.angalich@angalich.com: 1
## 201-588-7810: 1 201-412-3040: 1 ahoneywell@honeywell.com : 1
## 201-672-1553: 1 201-478-8540: 1 aja_gehrett@hotmail.com : 1
## 201-693-3967: 1 201-749-8866: 1 ajeanty@gmail.com : 1
## (Other) :494 (Other) :494 (Other) :494
## Agegroup date_on
## <20 :100 06-12-2014:500
## >45 : 82
## 20-25:118
## 25-35:100
## 35-45:100
##
##
## page_visit
## http://www.bbva.com/personal-banking/loans/home-improvement-loans.html : 79
## http://www.bbva.com/personal-banking/loans/home-loans.html :184
## http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation:106
## http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility : 52
## http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs : 79
##
##
## no_of_visits area_of_interest interest_score num_new_accounts
## Min. : 1.000 Mortgage:500 Min. : 1.0 Min. :1.000
## 1st Qu.: 1.000 1st Qu.: 377.8 1st Qu.:2.000
## Median : 7.000 Median : 752.0 Median :3.000
## Mean : 5.846 Mean : 752.0 Mean :2.594
## 3rd Qu.: 9.000 3rd Qu.:1126.2 3rd Qu.:3.000
## Max. :15.000 Max. :1500.5 Max. :4.000
##
## num_enquiries Credit_score Current_credit_limit Highest_Credit
## Min. : 2.00 Min. :600.0 Min. : 200 Min. : 34
## 1st Qu.: 5.00 1st Qu.:701.0 1st Qu.: 234 1st Qu.: 1234
## Median : 6.00 Median :722.0 Median : 343 Median : 1243
## Mean :10.84 Mean :711.1 Mean :1043 Mean : 3273
## 3rd Qu.: 7.00 3rd Qu.:750.0 3rd Qu.: 400 3rd Qu.: 2341
## Max. :34.00 Max. :789.0 Max. :4000 Max. :12344
##
## num_judge Single_Highest_Credit debt_month revolv_credit
## Min. :0.00 Min. : 56 Min. : 34.0 n:464
## 1st Qu.:0.00 1st Qu.: 324 1st Qu.: 213.0 y: 36
## Median :0.00 Median : 546 Median :1234.0
## Mean :0.36 Mean : 901 Mean : 978.8
## 3rd Qu.:0.00 3rd Qu.:1234 3rd Qu.:1234.0
## Max. :5.00 Max. :2314 Max. :2134.0
##
## open_mortg_loans MY_NEW_COLUMN
## n:234 adelina_nabours@gmail.com : 1
## y:266 adell.lipkin@lipkin.com : 1
## ahmed.angalich@angalich.com: 1
## ahoneywell@honeywell.com : 1
## aja_gehrett@hotmail.com : 1
## ajeanty@gmail.com : 1
## (Other) :494
Average “Interest Score” for by each “loan_type”
Merging4<-merge(Merging3,CustTrans_Internal,all=TRUE)
Merging4 %>%
group_by(loan_type) %>%
summarise(Merging5<-mean(Merging4$interest_score))
## Source: local data frame [4 x 2]
##
## loan_type Merging5 <- mean(Merging4$interest_sc...
## (fctr) (dbl)
## 1 Auto 752
## 2 Children 752
## 3 Mortgage 752
## 4 Personal 752
Frequency of Customers for different categories
count(Merging4)
## Source: local data frame [1 x 1]
##
## n
## (int)
## 1 500
Average of num_late_payment and num_miss_payments
mean(CustTrans_Internal$num_late_payments)
## [1] 2.538
mean(CustTrans_Internal$num_miss_payments)
## [1] 1.84
the average ‘Credit_score’ for each type of ’refinance’AND zipcode
Merging4 %>%
group_by(refinance,Zipcode) %>%
summarise(Merging6<-mean(Merging4$Credit_score))
## Source: local data frame [484 x 3]
## Groups: refinance [?]
##
## refinance Zipcode Merging6 <- mean(Merging4$Credit_score)
## (fctr) (int) (dbl)
## 1 For longer ternure 1602 711.086
## 2 For longer ternure 2138 711.086
## 3 For longer ternure 2346 711.086
## 4 For longer ternure 2745 711.086
## 5 For longer ternure 2909 711.086
## 6 For longer ternure 3865 711.086
## 7 For longer ternure 4864 711.086
## 8 For longer ternure 7009 711.086
## 9 For longer ternure 7032 711.086
## 10 For longer ternure 7050 711.086
## .. ... ... ...
Average ‘Credit_score’ by age group and pie chart
x<-Merging4 %>%
group_by(Agegroup) %>%
summarise(mean(Merging4$Credit_score))
x
## Source: local data frame [5 x 2]
##
## Agegroup mean(Merging4$Credit_score)
## (fctr) (dbl)
## 1 <20 711.086
## 2 >45 711.086
## 3 20-25 711.086
## 4 25-35 711.086
## 5 35-45 711.086
library(graphics)
pie(x$mean,x$Agegroup)
The correlation between ‘num_enquiries’, ‘Credit_score’ andinterpretation?
cor(Merging4$num_enquiries,Merging4$Credit_score)
## [1] -0.01114677
its r=-0.0111(week -ve linear relationship)
Exclude records that have Credit score < 700 and have Open Mortgage Loan and have revolving credit?
Merging4 %>% filter(Merging4$Credit_score < 700)
## Customer_Id Firstname LastName Address1
## 1 1234567890 James Butt Benton John B Jr
## 2 1234567897 Leota Dilliard Commercial Press
## 3 1234567902 Kiley Caldarera Feiner Bros
## 4 1234567903 Graciela Ruta Buckley Miller & Wright
## 5 1234567910 Bette Nicka Sport En Art
## 6 1234567915 Allene Iturbide Ledecky David Esq
## 7 1234567916 Chanel Caudy Professional Image Inc
## 8 1234567923 Albina Glick Giampetro Anthony D
## 9 1234567928 Valentine Gillian Fbs Business Finance
## 10 1234567929 Kati Rulapaugh Eder Assocs Consltng Engrs Pc
## 11 1234567936 Jina Briddick Grace Pastries Inc
## 12 1234567941 Lorrie Nestle Ballard Spahr Andrews
## 13 1234567942 Sabra Uyetake Lowy Limousine Service
## 14 1234567949 Deeanna Juhas Healy George W Iv
## 15 1234567950 Blondell Pugh Alpenlite Inc
## 16 1234567957 Elly Morocco Killion Industries
## 17 1234567962 Bobbye Rhym Smits Patricia Garity
## 18 1234567963 Micaela Rhymes H Lee Leonard Attorney At Law
## 19 1234567970 Devorah Chickering Garrison Ind
## 20 1234567975 Myra Munns Anker Law Office
## 21 1234567976 Stephaine Barfield Beutelschies & Company
## 22 1234567983 Wilda Giguere Mclaughlin Luther W Cpa
## 23 1234567988 Lisha Centini Industrial Paper Shredders Inc
## 24 1234567989 Arlene Klusman Beck Horizon Builders
## 25 1234567996 Twana Felger Opryland Hotel
## 26 1234568001 Sue Kownacki Juno Chefs Incorporated
## 27 1234568002 Jesusa Shin Carroccio A Thomas Esq
## 28 1234568009 Oretha Menter Custom Engineering Inc
## 29 1234568010 Ty Smith Bresler Eitel Framg Gllry Ltd
## 30 1234568017 Van Shire Cambridge Inn
## 31 1234568022 Kimbery Madarang Silberman Arthur L Esq
## 32 1234568023 Thurman Manno Honey Bee Breeding Genetics &
## 33 1234568030 Melissa Wiklund Moapa Valley Federal Credit Un
## 34 1234568035 Fernanda Jillson Shank Edward L Esq
## 35 1234568036 Gearldine Gellinger Megibow & Edwards
## 36 1234568043 Ozell Shealy Silver Bros Inc
## 37 1234568048 Gregoria Pawlowicz Oh My Goodknits Inc
## 38 1234568049 Carin Deleo Redeker Debbie
## 39 1234568056 Fannie Lungren Centro Inc
## 40 1234568061 Irma Wolfgramm Serendiquity Bed & Breakfast
## 41 1234568062 Eun Coody Ray Carolyne Realty
## 42 1234568069 Nelida Sawchuk Anchorage Museum Of Hist & Art
## 43 1234568076 Merilyn Bayless 20 20 Printing Inc
## 44 1234568081 Lemuel Latzke Computer Repair Service
## 45 1234568082 Melodie Knipp Fleetwood Building Block Inc
## 46 1234568089 Jolanda Hanafan Perez Joseph J Esq
## 47 1234568094 Ronny Caiafa Remaco Inc
## 48 1234568095 Marge Limmel Bjork Robert D Jr
## 49 1234568102 Beckie Silvestrini A All American Travel Inc
## 50 1234568107 Vincent Meinerding Arturi Peter D Esq
## 51 1234568108 Rima Bevelacqua Mcauley Mfg Co
## 52 1234568115 Tiera Frankel Roland Ashcroft
## 53 1234568120 Justine Mugnolo Evans Rule Company
## 54 1234568121 Eladia Saulter Tyee Productions Inc
## 55 1234568128 Rickie Plumer Merrill Lynch
## 56 1234568135 Peggie Sturiale Henry County Middle School
## 57 1234568140 Rhea Aredondo Double B Foods Inc
## 58 1234568141 Benedict Sama Alexander & Alexander Inc
## 59 1234568148 Martina Staback Ace Signs Inc
## 60 1234568153 Stevie Westerbeck Wise Dennis W Md
## 61 1234568154 Pamella Fortino Super 8 Motel
## 62 1234568161 Joseph Cryer Ames Stationers
## 63 1234568166 Detra Coyier Schott Fiber Optics Inc
## 64 1234568167 Terrilyn Rodeigues Stuart J Agins
## 65 1234568174 Lavonda Hengel Bradley Nameplate Corp
## 66 1234568179 Mirta Mallett Stephen Kennerly Archts Inc Pc
## 67 1234568180 Cathrine Pontoriero Business Systems Of Wis Inc
## 68 1234568187 Kayleigh Lace Dentalaw Divsn Hlth Care
## 69 1234568188 Felix Hirpara American Speedy Printing Ctrs
## 70 1234568195 Christiane Eschberger Casco Services Inc
## 71 1234568200 Raina Brachle Ikg Borden Divsn Harsco Corp
## 72 1234568201 Erinn Canlas Anchor Computer Inc
## 73 1234568208 Jesusita Flister Schoen Edward J Jr
## 74 1234568213 France Buzick In Travel Agency
## 75 1234568214 Justine Ferrario Newhart Foods Inc
## 76 1234568221 Kirk Herritt Hasting H Duane Esq
## 77 1234568226 Dulce Labreche Lee Kilkelly Paulson & Kabaker
## 78 1234568227 Kate Keneipp Davis Maxon R Esq
## 79 1234568234 Lashaunda Lizama Earnhardt Printing
## 80 1234568239 Margart Meisel Yeates Arthur L Aia
## 81 1234568240 Kristofer Bennick Logan Ronald J Esq
## 82 1234568247 Vincenza Zepp Kbor 1600 Am
## 83 1234568248 Elouise Gwalthney Quality Inn Northwest
## 84 1234568255 Linn Paa Valerie & Company
## 85 1234568260 Sheron Louissant Potter Brenda J Cpa
## 86 1234568261 Izetta Funnell Baird Kurtz & Dobson
## 87 1234568268 Cyril Daufeldt Galaxy International Inc
## 88 1234568273 Ciara Ventura Johnson Robert M Esq
## 89 1234568274 Galen Cantres Del Charro Apartments
## 90 1234568281 Lashandra Klang Acqua Group
## 91 1234568286 Dean Ketelsen J M Custom Design Millwork
## 92 1234568287 Levi Munis Farrell & Johnson Office Equip
## 93 1234568294 Tasia Andreason Campbell Robert A
## 94 1234568299 Glenna Slayton Toledo Iv Care
## 95 1234568300 Mitzie Hudnall Cangro Transmission Co
## 96 1234568307 Lynelle Auber United Cerebral Palsy Of Ne Pa
## 97 1234568308 Merissa Tomblin One Day Surgery Center Inc
## 98 1234568315 Elke Sengbusch Riley Riper Hollin & Colagreco
## 99 1234568320 Antione Onofrio Jacobs & Gerber Inc
## 100 1234568321 Luisa Jurney Forest Fire Laboratory
## 101 1234568328 Stephane Myricks Portland Central Thriftlodge
## 102 1234568333 Jeanice Claucherty Accurel Systems Intrntl Corp
## 103 1234568334 Josphine Villanueva Santa Cruz Community Internet
## 104 1234568341 Lonna Diestel Dimmock Thomas J Esq
## 105 1234568346 Sharika Eanes Maccani & Delp
## 106 1234568347 Nu Mcnease Amazonia Film Project
## 107 1234568354 Ruthann Keener Maiden Craft Inc
## 108 1234568359 Ryan Harnos Warner Electric Brk & Cltch Co
## 109 1234568360 Jess Chaffins New York Public Library
## 110 1234568367 Rasheeda Sayaphon Kummerer J Michael Esq
## 111 1234568374 Lili Paskin Morgan Custom Homes
## 112 1234568379 Lawrence Lorens New England Sec Equip Co Inc
## 113 1234568380 Carlee Boulter Tippett Troy M Ii
## 114 1234568387 Flo Bookamer Simonton Howe & Schneider Pc
## Address2 City County State
## 1 6649 N Blue Gum St New Orleans Orleans LA
## 2 7 W Jackson Blvd San Jose Santa Clara CA
## 3 25 E 75th St #69 Los Angeles Los Angeles CA
## 4 98 Connecticut Ave Nw Chagrin Falls Geauga OH
## 5 6 S 33rd St Aston Delaware PA
## 6 1 Central Ave Stevens Point Portage WI
## 7 86 Nw 66th St #8673 Shawnee Johnson KS
## 8 4 Ralph Ct Dunellen Middlesex NJ
## 9 775 W 17th St San Antonio Bexar TX
## 10 6980 Dorsett Rd Abilene Dickinson KS
## 11 38938 Park Blvd Boston Suffolk MA
## 12 39 S 7th St Tullahoma Coffee TN
## 13 98839 Hawthorne Blvd #6101 Columbia Richland SC
## 14 14302 Pennsylvania Ave Huntingdon Valley Montgomery PA
## 15 201 Hawk Ct Providence Providence RI
## 16 7 W 32nd St Erie Erie PA
## 17 30 W 80th St #1995 San Carlos San Mateo CA
## 18 20932 Hedley St Concord Contra Costa CA
## 19 31 Douglas Blvd #950 Clovis Curry NM
## 20 461 Prospect Pl #316 Euless Tarrant TX
## 21 47154 Whipple Ave Nw Gardena Los Angeles CA
## 22 1747 Calle Amanecer #2 Anchorage Anchorage AK
## 23 64 5th Ave #1153 Mc Lean Fairfax VA
## 24 3 Secor Rd New Orleans Orleans LA
## 25 1 Commerce Way Portland Washington OR
## 26 2 Se 3rd Ave Mesquite Dallas TX
## 27 2239 Shawnee Mission Pky Tullahoma Coffee TN
## 28 8 County Center Dr #647 Boston Suffolk MA
## 29 4646 Kaahumanu St Hackensack Bergen NJ
## 30 90131 J St Pittstown Hunterdon NJ
## 31 798 Lund Farm Way Rockaway Morris NJ
## 32 9387 Charcot Ave Absecon Atlantic NJ
## 33 61 13 Stoneridge #835 Findlay Hancock OH
## 34 60480 Old Us Highway 51 Preston Caroline MD
## 35 4 Bloomfield Ave Irving Dallas TX
## 36 8 Industry Ln New York New York NY
## 37 455 N Main Ave Garden City Nassau NY
## 38 1844 Southern Blvd Little Rock Pulaski AR
## 39 17 Us Highway 111 Round Rock Williamson TX
## 40 9745 W Main St Randolph Morris NJ
## 41 84 Bloomfield Ave Spartanburg Spartanburg SC
## 42 3 State Route 35 S Paramus Bergen NJ
## 43 195 13n N Santa Clara Santa Clara CA
## 44 70 Euclid Ave #722 Bohemia Suffolk NY
## 45 326 E Main St #6496 Thousand Oaks Ventura CA
## 46 37855 Nolan Rd Bangor Penobscot ME
## 47 73 Southern Blvd Philadelphia Philadelphia PA
## 48 189 Village Park Rd Crestview Okaloosa FL
## 49 7116 Western Ave Dearborn Wayne MI
## 50 4441 Point Term Mkt Philadelphia Philadelphia PA
## 51 2972 Lafayette Ave Gardena Los Angeles CA
## 52 87 Sierra Rd El Monte Los Angeles CA
## 53 38062 E Main St New York New York NY
## 54 3958 S Dupont Hwy #7 Ramsey Bergen NJ
## 55 3 N Groesbeck Hwy Toledo Lucas OH
## 56 9 N 14th St El Cajon San Diego CA
## 57 25657 Live Oak St Brooklyn Kings NY
## 58 4923 Carey Ave Saint Louis Saint Louis City MO
## 59 7 W Wabansia Ave #227 Orlando Orange FL
## 60 26659 N 13th St Costa Mesa Orange CA
## 61 669 Packerland Dr #1438 Denver Denver CO
## 62 60 Fillmore Ave Huntington Beach Orange CA
## 63 96950 Hidden Ln Aberdeen Harford MD
## 64 3718 S Main St New Orleans Orleans LA
## 65 87 Imperial Ct #79 Fargo Cass ND
## 66 7 S San Marcos Rd New York New York NY
## 67 812 S Haven St Amarillo Randall TX
## 68 43 Huey P Long Ave Lafayette Lafayette LA
## 69 7563 Cornwall Rd #4462 Denver Lancaster PA
## 70 96541 W Central Blvd Phoenix Maricopa AZ
## 71 3829 Ventura Blvd Butte Silver Bow MT
## 72 13 S Hacienda Dr Livingston Essex NJ
## 73 3943 N Highland Ave Lancaster Lancaster PA
## 74 64 Newman Springs Rd E Brooklyn Kings NY
## 75 48 Stratford Ave Pomona Los Angeles CA
## 76 88 15th Ave Ne Vestal Broome NY
## 77 9581 E Arapahoe Rd Rochester Oakland MI
## 78 33 N Michigan Ave Green Bay Brown WI
## 79 3387 Ryan Dr Hanover Anne Arundel MD
## 80 868 State St #38 Cincinnati Hamilton OH
## 81 772 W River Dr Bloomington Monroe IN
## 82 395 S 6th St #2 El Cajon San Diego CA
## 83 9506 Edgemore Ave Bladensburg Prince Georges MD
## 84 1 S Pine St Memphis Shelby TN
## 85 97 E 3rd St #9 Long Island City Queens NY
## 86 82 Winsor St #54 Atlanta Dekalb GA
## 87 3 Lawton St New York New York NY
## 88 53 W Carey St Port Jervis Orange NY
## 89 617 Nw 36th Ave Brook Park Cuyahoga OH
## 90 810 N La Brea Ave King of Prussia Montgomery PA
## 91 2 Flynn Rd Hicksville Nassau NY
## 92 2094 Ne 36th Ave Worcester Worcester MA
## 93 4 Cowesett Ave Kearny Hudson NJ
## 94 2759 Livingston Ave Memphis Shelby TN
## 95 17 Jersey Ave Englewood Arapahoe CO
## 96 32820 Corkwood Rd Newark Essex NJ
## 97 34 Raritan Center Pky Bellflower Los Angeles CA
## 98 9 W Central Ave Phoenix Maricopa AZ
## 99 4 S Washington Ave San Bernardino San Bernardino CA
## 100 25 Se 176th Pl Cambridge Middlesex MA
## 101 9 Tower Ave Burlington Boone KY
## 102 19 Amboy Ave Miami Miami-Dade FL
## 103 63 Smith Ln #8343 Moss Clay TN
## 104 1482 College Ave Fayetteville Cumberland NC
## 105 75698 N Fiesta Blvd Orlando Orange FL
## 106 88 Sw 28th Ter Harrison Hudson NJ
## 107 3424 29th St Se Kerrville Kerr TX
## 108 13 Gunnison St Plano Collin TX
## 109 18 3rd Ave New York New York NY
## 110 251 Park Ave #979 Saratoga Santa Clara CA
## 111 20113 4th Ave E Kearny Hudson NJ
## 112 9 Hwy Providence Providence RI
## 113 8284 Hart St Abilene Dickinson KS
## 114 89992 E 15th St Alliance Box Butte NE
## Zipcode Phone1 Phone1.1 Email
## 1 70116 504-621-8927 504-845-1427 jbutt@gmail.com
## 2 95111 408-752-3500 408-813-1105 leota@hotmail.com
## 3 90034 310-498-5651 310-254-3084 kiley.caldarera@aol.com
## 4 44023 440-780-8425 440-579-7763 gruta@cox.net
## 5 19014 610-545-3615 610-492-4643 bette_nicka@cox.net
## 6 54481 715-662-6764 715-530-9863 allene_iturbide@cox.net
## 7 66218 913-388-2079 913-899-1103 chanel.caudy@caudy.org
## 8 8812 732-924-7882 732-782-6701 albina@glick.com
## 9 78204 210-812-9597 210-300-6244 valentine_gillian@gmail.com
## 10 67410 785-463-7829 785-219-7724 kati.rulapaugh@hotmail.com
## 11 2128 617-399-5124 617-997-5771 jina_briddick@briddick.com
## 12 37388 931-875-6644 931-303-6041 lnestle@hotmail.com
## 13 29201 803-925-5213 803-681-3678 sabra@uyetake.org
## 14 19006 215-211-9589 215-417-9563 deeanna_juhas@gmail.com
## 15 2904 401-960-8259 401-300-8122 bpugh@aol.com
## 16 16502 814-393-5571 814-420-3553 elly_morocco@gmail.com
## 17 94070 650-528-5783 650-811-9032 brhym@rhym.com
## 18 94520 925-647-3298 925-522-7798 micaela_rhymes@gmail.com
## 19 88101 505-975-8559 505-950-1763 devorah@hotmail.com
## 20 76040 817-914-7518 817-451-3518 mmunns@cox.net
## 21 90247 310-774-7643 310-968-1219 stephaine@barfield.com
## 22 99501 907-870-5536 907-914-9482 wilda@cox.net
## 23 22102 703-235-3937 703-475-7568 lisha@centini.org
## 24 70112 504-710-5840 504-946-1807 arlene_klusman@gmail.com
## 25 97224 503-939-3153 503-909-7167 twana.felger@felger.org
## 26 75149 972-666-3413 972-742-4000 sue@aol.com
## 27 37388 931-273-8709 931-739-1551 jshin@shin.com
## 28 2210 617-418-5043 617-697-6024 oretha_menter@yahoo.com
## 29 7601 201-672-1553 201-995-3149 tsmith@aol.com
## 30 8867 908-409-2890 908-448-1209 van.shire@shire.com
## 31 7866 973-310-1634 973-225-6259 kimbery_madarang@cox.net
## 32 8201 609-524-3586 609-234-8376 thurman.manno@yahoo.com
## 33 45840 419-939-3613 419-254-4591 melissa@cox.net
## 34 21655 410-387-5260 410-724-6472 fjillson@aol.com
## 35 75061 972-934-6914 972-821-7118 gearldine_gellinger@gellinger.com
## 36 10002 212-332-8435 212-880-8865 oshealy@hotmail.com
## 37 11530 516-212-1915 516-376-4230 gpawlowicz@yahoo.com
## 38 72202 501-308-1040 501-409-6072 cdeleo@deleo.com
## 39 78664 512-587-5746 512-528-9933 fannie.lungren@yahoo.com
## 40 7869 973-545-7355 973-868-8660 irma.wolfgramm@hotmail.com
## 41 29301 864-256-3620 864-594-4578 eun@yahoo.com
## 42 7652 201-971-1638 201-247-8925 nelida@gmail.com
## 43 95054 408-758-5015 408-346-2180 merilyn_bayless@cox.net
## 44 11716 631-748-6479 631-291-4976 lemuel.latzke@gmail.com
## 45 91362 805-690-1682 805-810-8964 mknipp@gmail.com
## 46 4401 207-458-9196 207-233-6185 jhanafan@gmail.com
## 47 19103 215-605-7570 215-511-3531 ronny.caiafa@caiafa.org
## 48 32536 850-430-1663 850-330-8079 marge@gmail.com
## 49 48126 313-533-4884 313-390-7855 beckie.silvestrini@silvestrini.com
## 50 19143 215-372-1718 215-829-4221 vincent.meinerding@hotmail.com
## 51 90248 310-858-5079 310-499-4200 rima@cox.net
## 52 91731 626-636-4117 626-638-4241 tfrankel@aol.com
## 53 10048 212-304-9225 212-311-6377 jmugnolo@yahoo.com
## 54 7446 201-474-4924 201-365-8698 eladia@saulter.com
## 55 43613 419-693-1334 419-313-5571 rickie.plumer@aol.com
## 56 92020 619-608-1763 619-695-8086 peggie@cox.net
## 57 11226 718-560-9537 718-280-4183 rhea_aredondo@cox.net
## 58 63104 314-787-1588 314-858-4832 bsama@cox.net
## 59 32822 407-471-6908 407-429-2145 martina_staback@staback.com
## 60 92626 949-867-4077 949-903-3898 stevie.westerbeck@yahoo.com
## 61 80212 303-404-2210 303-794-1341 pamella@fortino.com
## 62 92647 714-584-2237 714-698-2170 joseph_cryer@cox.net
## 63 21001 410-739-9277 410-259-2118 detra@aol.com
## 64 70130 504-463-4384 504-635-8518 terrilyn.rodeigues@cox.net
## 65 58102 701-898-2154 701-421-7080 lavonda@cox.net
## 66 10004 212-870-1286 212-745-6948 mirta_mallett@gmail.com
## 67 79109 806-703-1435 806-558-5848 cathrine.pontoriero@pontoriero.com
## 68 70508 337-740-9323 337-751-2326 kayleigh.lace@yahoo.com
## 69 17517 717-491-5643 717-583-1497 felix_hirpara@cox.net
## 70 85034 602-390-4944 602-330-6894 christiane.eschberger@yahoo.com
## 71 59701 406-318-1515 406-374-7752 raina.brachle@brachle.org
## 72 7039 973-767-3008 973-563-9502 erinn.canlas@canlas.com
## 73 17601 717-885-9118 717-686-7564 jesusita.flister@hotmail.com
## 74 11219 718-478-8504 718-853-3740 france.buzick@yahoo.com
## 75 91768 909-993-3242 909-631-5703 jferrario@hotmail.com
## 76 13850 607-407-3716 607-350-7690 kirk.herritt@aol.com
## 77 48307 248-357-8718 248-811-5696 dulce_labreche@yahoo.com
## 78 54301 920-353-6377 920-355-1610 kate_keneipp@yahoo.com
## 79 21076 410-678-2473 410-912-6032 llizama@cox.net
## 80 45251 513-617-2362 513-747-9603 margart_meisel@yahoo.com
## 81 47404 812-368-1511 812-442-8544 kristofer.bennick@yahoo.com
## 82 92020 619-603-5125 619-935-6661 vzepp@gmail.com
## 83 20710 301-841-5012 301-591-3034 egwalthney@yahoo.com
## 84 38112 901-412-4381 901-573-9024 linn_paa@paa.com
## 85 11101 718-976-8610 718-613-9994 sheron@aol.com
## 86 30340 770-844-3447 770-584-4119 izetta.funnell@hotmail.com
## 87 10013 212-745-8484 212-422-5427 cyril_daufeldt@daufeldt.com
## 88 12771 845-823-8877 845-694-7919 cventura@yahoo.com
## 89 44142 216-600-6111 216-871-6876 galen@yahoo.com
## 90 19406 610-809-1818 610-378-7332 lashandra@yahoo.com
## 91 11801 516-847-4418 516-732-6649 dean_ketelsen@gmail.com
## 92 1603 508-456-4907 508-658-7802 levi.munis@gmail.com
## 93 7032 201-920-9002 201-969-7063 tasia_andreason@yahoo.com
## 94 38118 901-640-9178 901-869-4314 glenna_slayton@cox.net
## 95 80110 303-402-1940 303-997-7760 mitzie_hudnall@yahoo.com
## 96 7104 973-860-8610 973-605-6492 lynelle_auber@gmail.com
## 97 90706 562-579-6900 562-719-7922 merissa.tomblin@gmail.com
## 98 85013 602-896-2993 602-575-3457 elke_sengbusch@yahoo.com
## 99 92410 909-430-7765 909-665-3223 aonofrio@onofrio.com
## 100 2138 617-365-2134 617-544-2541 ljurney@hotmail.com
## 101 41005 859-717-7638 859-308-4286 stephane_myricks@cox.net
## 102 33142 305-988-4162 305-306-7834 jeanice.claucherty@yahoo.com
## 103 38575 931-553-9774 931-486-6946 josphine_villanueva@villanueva.com
## 104 28301 910-922-3672 910-200-7912 lonna_diestel@gmail.com
## 105 32806 407-312-1691 407-472-1332 sharika.eanes@aol.com
## 106 7029 973-751-9003 973-903-4175 nu@gmail.com
## 107 78028 830-258-2769 830-919-5991 ruthann@hotmail.com
## 108 75075 972-558-1665 972-961-4968 ryan@cox.net
## 109 10016 212-510-4633 212-428-9538 jess.chaffins@chaffins.org
## 110 95070 408-805-4309 408-997-7490 rasheeda@aol.com
## 111 7032 201-431-2989 201-478-8540 lili.paskin@cox.net
## 112 2906 401-465-6432 401-893-1820 lawrence.lorens@hotmail.com
## 113 67410 785-347-1805 785-253-7049 carlee.boulter@hotmail.com
## 114 69301 308-726-2182 308-250-6987 flo.bookamer@cox.net
## Agegroup date_on
## 1 <20 06-12-2014
## 2 25-35 06-12-2014
## 3 25-35 06-12-2014
## 4 35-45 06-12-2014
## 5 <20 06-12-2014
## 6 25-35 06-12-2014
## 7 35-45 06-12-2014
## 8 <20 06-12-2014
## 9 >45 06-12-2014
## 10 <20 06-12-2014
## 11 <20 06-12-2014
## 12 25-35 06-12-2014
## 13 35-45 06-12-2014
## 14 >45 06-12-2014
## 15 <20 06-12-2014
## 16 25-35 06-12-2014
## 17 25-35 06-12-2014
## 18 35-45 06-12-2014
## 19 25-35 06-12-2014
## 20 25-35 06-12-2014
## 21 35-45 06-12-2014
## 22 >45 06-12-2014
## 23 >45 06-12-2014
## 24 <20 06-12-2014
## 25 25-35 06-12-2014
## 26 20-25 06-12-2014
## 27 25-35 06-12-2014
## 28 >45 06-12-2014
## 29 <20 06-12-2014
## 30 25-35 06-12-2014
## 31 25-35 06-12-2014
## 32 35-45 06-12-2014
## 33 25-35 06-12-2014
## 34 20-25 06-12-2014
## 35 25-35 06-12-2014
## 36 >45 06-12-2014
## 37 25-35 06-12-2014
## 38 35-45 06-12-2014
## 39 20-25 06-12-2014
## 40 20-25 06-12-2014
## 41 25-35 06-12-2014
## 42 >45 06-12-2014
## 43 20-25 06-12-2014
## 44 35-45 06-12-2014
## 45 >45 06-12-2014
## 46 20-25 06-12-2014
## 47 <20 06-12-2014
## 48 20-25 06-12-2014
## 49 20-25 06-12-2014
## 50 35-45 06-12-2014
## 51 >45 06-12-2014
## 52 <20 06-12-2014
## 53 <20 06-12-2014
## 54 20-25 06-12-2014
## 55 35-45 06-12-2014
## 56 25-35 06-12-2014
## 57 25-35 06-12-2014
## 58 35-45 06-12-2014
## 59 >45 06-12-2014
## 60 >45 06-12-2014
## 61 <20 06-12-2014
## 62 25-35 06-12-2014
## 63 20-25 06-12-2014
## 64 25-35 06-12-2014
## 65 >45 06-12-2014
## 66 >45 06-12-2014
## 67 <20 06-12-2014
## 68 25-35 06-12-2014
## 69 35-45 06-12-2014
## 70 25-35 06-12-2014
## 71 20-25 06-12-2014
## 72 25-35 06-12-2014
## 73 >45 06-12-2014
## 74 25-35 06-12-2014
## 75 35-45 06-12-2014
## 76 20-25 06-12-2014
## 77 20-25 06-12-2014
## 78 25-35 06-12-2014
## 79 >45 06-12-2014
## 80 >45 06-12-2014
## 81 <20 06-12-2014
## 82 >45 06-12-2014
## 83 <20 06-12-2014
## 84 20-25 06-12-2014
## 85 20-25 06-12-2014
## 86 25-35 06-12-2014
## 87 25-35 06-12-2014
## 88 >45 06-12-2014
## 89 <20 06-12-2014
## 90 20-25 06-12-2014
## 91 20-25 06-12-2014
## 92 25-35 06-12-2014
## 93 >45 06-12-2014
## 94 20-25 06-12-2014
## 95 25-35 06-12-2014
## 96 >45 06-12-2014
## 97 <20 06-12-2014
## 98 20-25 06-12-2014
## 99 20-25 06-12-2014
## 100 <20 06-12-2014
## 101 >45 06-12-2014
## 102 35-45 06-12-2014
## 103 >45 06-12-2014
## 104 20-25 06-12-2014
## 105 20-25 06-12-2014
## 106 25-35 06-12-2014
## 107 20-25 06-12-2014
## 108 20-25 06-12-2014
## 109 25-35 06-12-2014
## 110 35-45 06-12-2014
## 111 <20 06-12-2014
## 112 35-45 06-12-2014
## 113 20-25 06-12-2014
## 114 25-35 06-12-2014
## page_visit
## 1 http://www.bbva.com/personal-banking/loans/home-loans.html
## 2 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 3 http://www.bbva.com/personal-banking/loans/home-loans.html
## 4 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 5 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 6 http://www.bbva.com/personal-banking/loans/home-loans.html
## 7 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 8 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 9 http://www.bbva.com/personal-banking/loans/home-loans.html
## 10 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 11 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 12 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 13 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 14 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 15 http://www.bbva.com/personal-banking/loans/home-loans.html
## 16 http://www.bbva.com/personal-banking/loans/home-loans.html
## 17 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 18 http://www.bbva.com/personal-banking/loans/home-loans.html
## 19 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 20 http://www.bbva.com/personal-banking/loans/home-loans.html
## 21 http://www.bbva.com/personal-banking/loans/home-loans.html
## 22 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 23 http://www.bbva.com/personal-banking/loans/home-loans.html
## 24 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 25 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 26 http://www.bbva.com/personal-banking/loans/home-loans.html
## 27 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 28 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 29 http://www.bbva.com/personal-banking/loans/home-loans.html
## 30 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 31 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 32 http://www.bbva.com/personal-banking/loans/home-loans.html
## 33 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 34 http://www.bbva.com/personal-banking/loans/home-loans.html
## 35 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 36 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 37 http://www.bbva.com/personal-banking/loans/home-loans.html
## 38 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 39 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 40 http://www.bbva.com/personal-banking/loans/home-loans.html
## 41 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 42 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 43 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 44 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 45 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 46 http://www.bbva.com/personal-banking/loans/home-loans.html
## 47 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 48 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 49 http://www.bbva.com/personal-banking/loans/home-loans.html
## 50 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 51 http://www.bbva.com/personal-banking/loans/home-loans.html
## 52 http://www.bbva.com/personal-banking/loans/home-loans.html
## 53 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 54 http://www.bbva.com/personal-banking/loans/home-loans.html
## 55 http://www.bbva.com/personal-banking/loans/home-loans.html
## 56 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 57 http://www.bbva.com/personal-banking/loans/home-loans.html
## 58 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 59 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 60 http://www.bbva.com/personal-banking/loans/home-loans.html
## 61 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 62 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 63 http://www.bbva.com/personal-banking/loans/home-loans.html
## 64 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 65 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 66 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 67 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 68 http://www.bbva.com/personal-banking/loans/home-loans.html
## 69 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 70 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 71 http://www.bbva.com/personal-banking/loans/home-loans.html
## 72 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 73 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 74 http://www.bbva.com/personal-banking/loans/home-loans.html
## 75 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 76 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 77 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 78 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 79 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 80 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 81 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 82 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 83 http://www.bbva.com/personal-banking/loans/home-loans.html
## 84 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 85 http://www.bbva.com/personal-banking/loans/home-loans.html
## 86 http://www.bbva.com/personal-banking/loans/home-loans.html
## 87 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 88 http://www.bbva.com/personal-banking/loans/home-loans.html
## 89 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 90 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 91 http://www.bbva.com/personal-banking/loans/home-loans.html
## 92 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 93 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 94 http://www.bbva.com/personal-banking/loans/home-loans.html
## 95 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 96 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 97 http://www.bbva.com/personal-banking/loans/home-loans.html
## 98 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 99 http://www.bbva.com/personal-banking/loans/home-loans.html
## 100 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 101 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 102 http://www.bbva.com/personal-banking/loans/home-loans.html
## 103 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 104 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 105 http://www.bbva.com/personal-banking/loans/home-loans.html
## 106 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 107 http://www.bbva.com/personal-banking/loans/home-loans.html#product_eligibility
## 108 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 109 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 110 http://www.bbva.com/personal-banking/loans/home-loans.html#product_documentation
## 111 http://www.bbva.com/personal-banking/loans/home-loans.html
## 112 http://www.bbva.com/personal-banking/loans/home-loans.html#product_faqs
## 113 http://www.bbva.com/personal-banking/loans/home-improvement-loans.html
## 114 http://www.bbva.com/personal-banking/loans/home-loans.html
## no_of_visits area_of_interest interest_score num_new_accounts
## 1 5 Mortgage 1.0 1
## 2 7 Mortgage 24.5 3
## 3 1 Mortgage 39.5 3
## 4 2 Mortgage 42.5 4
## 5 11 Mortgage 63.5 1
## 6 7 Mortgage 78.5 1
## 7 7 Mortgage 81.5 2
## 8 1 Mortgage 102.5 4
## 9 5 Mortgage 117.5 4
## 10 11 Mortgage 120.5 3
## 11 7 Mortgage 141.5 2
## 12 2 Mortgage 156.5 2
## 13 1 Mortgage 159.5 3
## 14 15 Mortgage 180.5 3
## 15 9 Mortgage 183.5 1
## 16 7 Mortgage 204.5 3
## 17 1 Mortgage 219.5 3
## 18 3 Mortgage 222.5 4
## 19 11 Mortgage 243.5 1
## 20 7 Mortgage 258.5 1
## 21 7 Mortgage 261.5 2
## 22 2 Mortgage 282.5 4
## 23 9 Mortgage 297.5 4
## 24 11 Mortgage 300.5 3
## 25 1 Mortgage 321.5 2
## 26 3 Mortgage 336.5 2
## 27 2 Mortgage 339.5 3
## 28 12 Mortgage 360.5 3
## 29 7 Mortgage 363.5 1
## 30 2 Mortgage 384.5 3
## 31 1 Mortgage 399.5 3
## 32 5 Mortgage 402.5 4
## 33 7 Mortgage 423.5 1
## 34 1 Mortgage 438.5 1
## 35 2 Mortgage 441.5 2
## 36 11 Mortgage 462.5 4
## 37 7 Mortgage 477.5 4
## 38 7 Mortgage 480.5 3
## 39 1 Mortgage 501.5 2
## 40 5 Mortgage 516.5 2
## 41 11 Mortgage 519.5 3
## 42 7 Mortgage 540.5 1
## 43 1 Mortgage 561.5 3
## 44 11 Mortgage 576.5 3
## 45 15 Mortgage 579.5 4
## 46 7 Mortgage 600.5 1
## 47 1 Mortgage 615.5 1
## 48 1 Mortgage 618.5 2
## 49 9 Mortgage 639.5 4
## 50 7 Mortgage 654.5 4
## 51 7 Mortgage 657.5 3
## 52 3 Mortgage 678.5 2
## 53 15 Mortgage 693.5 2
## 54 9 Mortgage 696.5 3
## 55 7 Mortgage 717.5 1
## 56 2 Mortgage 738.5 3
## 57 9 Mortgage 753.5 3
## 58 11 Mortgage 756.5 4
## 59 1 Mortgage 777.5 1
## 60 3 Mortgage 792.5 1
## 61 2 Mortgage 795.5 2
## 62 12 Mortgage 816.5 4
## 63 7 Mortgage 831.5 4
## 64 1 Mortgage 834.5 3
## 65 1 Mortgage 855.5 2
## 66 11 Mortgage 870.5 2
## 67 12 Mortgage 873.5 3
## 68 1 Mortgage 894.5 3
## 69 2 Mortgage 897.5 1
## 70 11 Mortgage 918.5 3
## 71 7 Mortgage 933.5 3
## 72 7 Mortgage 936.5 4
## 73 1 Mortgage 957.5 1
## 74 5 Mortgage 972.5 1
## 75 11 Mortgage 975.5 2
## 76 7 Mortgage 996.5 4
## 77 2 Mortgage 1011.5 4
## 78 1 Mortgage 1014.5 3
## 79 15 Mortgage 1035.5 2
## 80 7 Mortgage 1050.5 2
## 81 7 Mortgage 1053.5 3
## 82 1 Mortgage 1074.5 3
## 83 3 Mortgage 1077.5 1
## 84 11 Mortgage 1098.5 3
## 85 7 Mortgage 1113.5 3
## 86 7 Mortgage 1116.5 4
## 87 2 Mortgage 1137.5 1
## 88 9 Mortgage 1152.5 1
## 89 11 Mortgage 1155.5 2
## 90 1 Mortgage 1176.5 4
## 91 3 Mortgage 1191.5 4
## 92 2 Mortgage 1194.5 3
## 93 12 Mortgage 1215.5 2
## 94 7 Mortgage 1230.5 2
## 95 1 Mortgage 1233.5 3
## 96 1 Mortgage 1254.5 3
## 97 5 Mortgage 1257.5 1
## 98 7 Mortgage 1278.5 3
## 99 1 Mortgage 1293.5 3
## 100 2 Mortgage 1296.5 4
## 101 11 Mortgage 1317.5 1
## 102 7 Mortgage 1332.5 1
## 103 7 Mortgage 1335.5 2
## 104 1 Mortgage 1356.5 4
## 105 5 Mortgage 1371.5 4
## 106 11 Mortgage 1374.5 3
## 107 7 Mortgage 1395.5 2
## 108 2 Mortgage 1410.5 2
## 109 1 Mortgage 1413.5 3
## 110 15 Mortgage 1434.5 1
## 111 7 Mortgage 1455.5 3
## 112 1 Mortgage 1470.5 3
## 113 1 Mortgage 1473.5 4
## 114 9 Mortgage 1494.5 1
## num_enquiries Credit_score Current_credit_limit Highest_Credit
## 1 34 620 200 34
## 2 5 650 4000 12344
## 3 5 600 4000 12344
## 4 6 620 343 1234
## 5 34 650 200 34
## 6 34 600 200 34
## 7 2 620 400 2341
## 8 6 650 343 2341
## 9 6 600 343 2341
## 10 7 620 234 12344
## 11 2 650 400 1243
## 12 2 600 400 1243
## 13 5 620 4000 1234
## 14 7 650 234 34
## 15 34 620 200 34
## 16 5 650 4000 12344
## 17 5 600 4000 12344
## 18 6 620 343 1234
## 19 34 650 200 34
## 20 34 600 200 34
## 21 2 620 400 2341
## 22 6 650 343 2341
## 23 6 600 343 2341
## 24 7 620 234 12344
## 25 2 650 400 1243
## 26 2 600 400 1243
## 27 5 620 4000 1234
## 28 7 650 234 34
## 29 34 620 200 34
## 30 5 650 4000 12344
## 31 5 600 4000 12344
## 32 6 620 343 1234
## 33 34 650 200 34
## 34 34 600 200 34
## 35 2 620 400 2341
## 36 6 650 343 2341
## 37 6 600 343 2341
## 38 7 620 234 12344
## 39 2 650 400 1243
## 40 2 600 400 1243
## 41 5 620 4000 1234
## 42 34 620 200 34
## 43 5 650 4000 12344
## 44 5 600 4000 12344
## 45 6 620 343 1234
## 46 34 650 200 34
## 47 34 600 200 34
## 48 2 620 400 2341
## 49 6 650 343 2341
## 50 6 600 343 2341
## 51 7 620 234 12344
## 52 2 650 400 1243
## 53 2 600 400 1243
## 54 5 620 4000 1234
## 55 34 620 200 34
## 56 5 650 4000 12344
## 57 5 600 4000 12344
## 58 6 620 343 1234
## 59 34 650 200 34
## 60 34 600 200 34
## 61 2 620 400 2341
## 62 6 650 343 2341
## 63 6 600 343 2341
## 64 7 620 234 12344
## 65 2 650 400 1243
## 66 2 600 400 1243
## 67 5 620 4000 1234
## 68 7 650 234 34
## 69 34 620 200 34
## 70 5 650 4000 12344
## 71 5 600 4000 12344
## 72 6 620 343 1234
## 73 34 650 200 34
## 74 34 600 200 34
## 75 2 620 400 2341
## 76 6 650 343 2341
## 77 6 600 343 2341
## 78 7 620 234 12344
## 79 2 650 400 1243
## 80 2 600 400 1243
## 81 5 620 4000 1234
## 82 7 650 234 34
## 83 34 620 200 34
## 84 5 650 4000 12344
## 85 5 600 4000 12344
## 86 6 620 343 1234
## 87 34 650 200 34
## 88 34 600 200 34
## 89 2 620 400 2341
## 90 6 650 343 2341
## 91 6 600 343 2341
## 92 7 620 234 12344
## 93 2 650 400 1243
## 94 2 600 400 1243
## 95 5 620 4000 1234
## 96 7 650 234 34
## 97 34 620 200 34
## 98 5 650 4000 12344
## 99 5 600 4000 12344
## 100 6 620 343 1234
## 101 34 650 200 34
## 102 34 600 200 34
## 103 2 620 400 2341
## 104 6 650 343 2341
## 105 6 600 343 2341
## 106 7 620 234 12344
## 107 2 650 400 1243
## 108 2 600 400 1243
## 109 5 620 4000 1234
## 110 34 620 200 34
## 111 5 650 4000 12344
## 112 5 600 4000 12344
## 113 6 620 343 1234
## 114 34 650 200 34
## num_judge Single_Highest_Credit debt_month revolv_credit
## 1 0 2314 1234 y
## 2 0 546 1234 n
## 3 4 546 1234 y
## 4 5 56 213 y
## 5 0 2314 1234 n
## 6 0 2314 1234 n
## 7 0 1234 2134 n
## 8 0 56 213 n
## 9 0 56 213 n
## 10 0 324 34 n
## 11 0 1234 2134 n
## 12 0 1234 2134 n
## 13 0 546 1234 n
## 14 0 324 34 n
## 15 0 2314 1234 y
## 16 0 546 1234 n
## 17 4 546 1234 y
## 18 5 56 213 y
## 19 0 2314 1234 n
## 20 0 2314 1234 n
## 21 0 1234 2134 n
## 22 0 56 213 n
## 23 0 56 213 n
## 24 0 324 34 n
## 25 0 1234 2134 n
## 26 0 1234 2134 n
## 27 0 546 1234 n
## 28 0 324 34 n
## 29 0 2314 1234 y
## 30 0 546 1234 n
## 31 4 546 1234 y
## 32 5 56 213 y
## 33 0 2314 1234 n
## 34 0 2314 1234 n
## 35 0 1234 2134 n
## 36 0 56 213 n
## 37 0 56 213 n
## 38 0 324 34 n
## 39 0 1234 2134 n
## 40 0 1234 2134 n
## 41 0 546 1234 n
## 42 0 2314 1234 y
## 43 0 546 1234 n
## 44 4 546 1234 y
## 45 5 56 213 y
## 46 0 2314 1234 n
## 47 0 2314 1234 n
## 48 0 1234 2134 n
## 49 0 56 213 n
## 50 0 56 213 n
## 51 0 324 34 n
## 52 0 1234 2134 n
## 53 0 1234 2134 n
## 54 0 546 1234 n
## 55 0 2314 1234 y
## 56 0 546 1234 n
## 57 4 546 1234 y
## 58 5 56 213 y
## 59 0 2314 1234 n
## 60 0 2314 1234 n
## 61 0 1234 2134 n
## 62 0 56 213 n
## 63 0 56 213 n
## 64 0 324 34 n
## 65 0 1234 2134 n
## 66 0 1234 2134 n
## 67 0 546 1234 n
## 68 0 324 34 n
## 69 0 2314 1234 y
## 70 0 546 1234 n
## 71 4 546 1234 y
## 72 5 56 213 y
## 73 0 2314 1234 n
## 74 0 2314 1234 n
## 75 0 1234 2134 n
## 76 0 56 213 n
## 77 0 56 213 n
## 78 0 324 34 n
## 79 0 1234 2134 n
## 80 0 1234 2134 n
## 81 0 546 1234 n
## 82 0 324 34 n
## 83 0 2314 1234 y
## 84 0 546 1234 n
## 85 4 546 1234 y
## 86 5 56 213 y
## 87 0 2314 1234 n
## 88 0 2314 1234 n
## 89 0 1234 2134 n
## 90 0 56 213 n
## 91 0 56 213 n
## 92 0 324 34 n
## 93 0 1234 2134 n
## 94 0 1234 2134 n
## 95 0 546 1234 n
## 96 0 324 34 n
## 97 0 2314 1234 y
## 98 0 546 1234 n
## 99 4 546 1234 y
## 100 5 56 213 y
## 101 0 2314 1234 n
## 102 0 2314 1234 n
## 103 0 1234 2134 n
## 104 0 56 213 n
## 105 0 56 213 n
## 106 0 324 34 n
## 107 0 1234 2134 n
## 108 0 1234 2134 n
## 109 0 546 1234 n
## 110 0 2314 1234 y
## 111 0 546 1234 n
## 112 4 546 1234 y
## 113 5 56 213 y
## 114 0 2314 1234 n
## open_mortg_loans MY_NEW_COLUMN Value_Segmentation
## 1 y jbutt@gmail.com High value
## 2 n leota@hotmail.com Med value
## 3 y kiley.caldarera@aol.com High value
## 4 n gruta@cox.net Med value
## 5 n bette_nicka@cox.net Low value
## 6 y allene_iturbide@cox.net Med value
## 7 y chanel.caudy@caudy.org Low value
## 8 n albina@glick.com High value
## 9 y valentine_gillian@gmail.com Low value
## 10 y kati.rulapaugh@hotmail.com High value
## 11 y jina_briddick@briddick.com Med value
## 12 n lnestle@hotmail.com High value
## 13 n sabra@uyetake.org Med value
## 14 n deeanna_juhas@gmail.com High value
## 15 y bpugh@aol.com Med value
## 16 n elly_morocco@gmail.com Low value
## 17 y brhym@rhym.com Med value
## 18 n micaela_rhymes@gmail.com Low value
## 19 n devorah@hotmail.com High value
## 20 y mmunns@cox.net Low value
## 21 y stephaine@barfield.com High value
## 22 n wilda@cox.net Med value
## 23 y lisha@centini.org High value
## 24 y arlene_klusman@gmail.com Med value
## 25 y twana.felger@felger.org High value
## 26 n sue@aol.com Low value
## 27 n jshin@shin.com High value
## 28 n oretha_menter@yahoo.com Med value
## 29 y tsmith@aol.com Low value
## 30 n van.shire@shire.com High value
## 31 y kimbery_madarang@cox.net Low value
## 32 n thurman.manno@yahoo.com High value
## 33 n melissa@cox.net Med value
## 34 y fjillson@aol.com High value
## 35 y gearldine_gellinger@gellinger.com Med value
## 36 n oshealy@hotmail.com Low value
## 37 y gpawlowicz@yahoo.com Med value
## 38 y cdeleo@deleo.com High value
## 39 y fannie.lungren@yahoo.com Med value
## 40 n irma.wolfgramm@hotmail.com High value
## 41 n eun@yahoo.com Med value
## 42 y nelida@gmail.com Low value
## 43 n merilyn_bayless@cox.net High value
## 44 y lemuel.latzke@gmail.com Low value
## 45 n mknipp@gmail.com High value
## 46 n jhanafan@gmail.com Med value
## 47 y ronny.caiafa@caiafa.org High value
## 48 y marge@gmail.com Med value
## 49 n beckie.silvestrini@silvestrini.com Low value
## 50 y vincent.meinerding@hotmail.com Med value
## 51 y rima@cox.net Low value
## 52 y tfrankel@aol.com High value
## 53 n jmugnolo@yahoo.com Low value
## 54 n eladia@saulter.com High value
## 55 y rickie.plumer@aol.com Med value
## 56 n peggie@cox.net Low value
## 57 y rhea_aredondo@cox.net Med value
## 58 n bsama@cox.net Low value
## 59 n martina_staback@staback.com High value
## 60 y stevie.westerbeck@yahoo.com Low value
## 61 y pamella@fortino.com High value
## 62 n joseph_cryer@cox.net Low value
## 63 y detra@aol.com Med value
## 64 y terrilyn.rodeigues@cox.net Low value
## 65 y lavonda@cox.net High value
## 66 n mirta_mallett@gmail.com Low value
## 67 n cathrine.pontoriero@pontoriero.com High value
## 68 n kayleigh.lace@yahoo.com Med value
## 69 y felix_hirpara@cox.net Low value
## 70 n christiane.eschberger@yahoo.com High value
## 71 y raina.brachle@brachle.org Low value
## 72 n erinn.canlas@canlas.com High value
## 73 n jesusita.flister@hotmail.com Med value
## 74 y france.buzick@yahoo.com Med value
## 75 y jferrario@hotmail.com Low value
## 76 n kirk.herritt@aol.com High value
## 77 y dulce_labreche@yahoo.com Low value
## 78 y kate_keneipp@yahoo.com High value
## 79 y llizama@cox.net Med value
## 80 n margart_meisel@yahoo.com High value
## 81 n kristofer.bennick@yahoo.com Med value
## 82 n vzepp@gmail.com Low value
## 83 y egwalthney@yahoo.com High value
## 84 n linn_paa@paa.com Med value
## 85 y sheron@aol.com High value
## 86 n izetta.funnell@hotmail.com Med value
## 87 n cyril_daufeldt@daufeldt.com High value
## 88 y cventura@yahoo.com Low value
## 89 y galen@yahoo.com High value
## 90 n lashandra@yahoo.com Med value
## 91 y dean_ketelsen@gmail.com High value
## 92 y levi.munis@gmail.com Med value
## 93 y tasia_andreason@yahoo.com Low value
## 94 n glenna_slayton@cox.net Med value
## 95 n mitzie_hudnall@yahoo.com Low value
## 96 n lynelle_auber@gmail.com High value
## 97 y merissa.tomblin@gmail.com Med value
## 98 n elke_sengbusch@yahoo.com Low value
## 99 y aonofrio@onofrio.com Med value
## 100 n ljurney@hotmail.com Low value
## 101 n stephane_myricks@cox.net High value
## 102 y jeanice.claucherty@yahoo.com Low value
## 103 y josphine_villanueva@villanueva.com High value
## 104 n lonna_diestel@gmail.com Med value
## 105 y sharika.eanes@aol.com High value
## 106 y nu@gmail.com Med value
## 107 y ruthann@hotmail.com Low value
## 108 n ryan@cox.net Med value
## 109 n jess.chaffins@chaffins.org Low value
## 110 y rasheeda@aol.com High value
## 111 n lili.paskin@cox.net Low value
## 112 y lawrence.lorens@hotmail.com Med value
## 113 n carlee.boulter@hotmail.com Low value
## 114 n flo.bookamer@cox.net High value
## prev_loan_close_Date HasopenLoan num_late_payments num_miss_payments
## 1 6/13/2014 Y 1 4
## 2 6/13/2014 N 2 2
## 3 6/13/2014 Y 1 3
## 4 6/13/2014 N 1 3
## 5 6/13/2014 Y 2 1
## 6 6/13/2014 N 1 1
## 7 6/13/2014 Y 1 1
## 8 6/13/2014 Y 3 2
## 9 6/13/2014 Y 4 1
## 10 6/13/2014 Y 4 1
## 11 6/13/2014 N 3 2
## 12 6/13/2014 Y 2 1
## 13 6/13/2014 N 2 1
## 14 6/13/2014 Y 3 1
## 15 6/13/2014 N 2 2
## 16 6/13/2014 Y 2 3
## 17 6/13/2014 N 2 3
## 18 6/13/2014 Y 2 1
## 19 6/13/2014 Y 1 2
## 20 6/13/2014 Y 3 2
## 21 6/13/2014 Y 3 2
## 22 6/13/2014 N 4 1
## 23 6/13/2014 Y 3 2
## 24 6/13/2014 N 3 2
## 25 6/13/2014 Y 1 4
## 26 6/13/2014 Y 4 1
## 27 6/13/2014 Y 3 1
## 28 6/13/2014 N 1 3
## 29 6/13/2014 Y 2 3
## 30 6/13/2014 Y 3 1
## 31 6/13/2014 Y 1 1
## 32 6/13/2014 Y 1 2
## 33 6/13/2014 N 3 2
## 34 6/13/2014 Y 4 1
## 35 6/13/2014 N 4 1
## 36 6/13/2014 Y 3 1
## 37 6/13/2014 N 2 1
## 38 6/13/2014 Y 1 4
## 39 6/13/2014 N 2 2
## 40 6/13/2014 Y 1 3
## 41 6/13/2014 N 1 3
## 42 6/13/2014 Y 2 1
## 43 6/13/2014 Y 1 2
## 44 6/13/2014 Y 3 2
## 45 6/13/2014 Y 3 2
## 46 6/13/2014 N 4 1
## 47 6/13/2014 Y 3 2
## 48 6/13/2014 N 3 2
## 49 6/13/2014 N 3 1
## 50 6/13/2014 N 2 1
## 51 6/13/2014 Y 4 1
## 52 6/13/2014 Y 1 3
## 53 6/13/2014 Y 2 3
## 54 6/13/2014 Y 2 3
## 55 6/13/2014 N 1 1
## 56 6/13/2014 Y 3 2
## 57 6/13/2014 N 4 1
## 58 6/13/2014 Y 4 1
## 59 6/13/2014 Y 3 2
## 60 6/13/2014 Y 2 1
## 61 6/13/2014 Y 2 1
## 62 6/13/2014 Y 4 1
## 63 6/13/2014 N 1 2
## 64 6/13/2014 Y 1 2
## 65 6/13/2014 Y 2 3
## 66 6/13/2014 Y 3 1
## 67 6/13/2014 Y 4 1
## 68 6/13/2014 N 2 2
## 69 6/13/2014 Y 3 2
## 70 6/13/2014 Y 4 1
## 71 6/13/2014 Y 3 2
## 72 6/13/2014 Y 3 2
## 73 6/13/2014 N 2 1
## 74 6/13/2014 N 2 1
## 75 6/13/2014 Y 4 1
## 76 6/13/2014 Y 1 3
## 77 6/13/2014 Y 2 3
## 78 6/13/2014 Y 2 3
## 79 6/13/2014 N 1 1
## 80 6/13/2014 Y 2 2
## 81 6/13/2014 N 2 2
## 82 6/13/2014 Y 4 1
## 83 6/13/2014 Y 4 1
## 84 6/13/2014 N 3 2
## 85 6/13/2014 Y 2 1
## 86 6/13/2014 N 2 1
## 87 6/13/2014 Y 3 1
## 88 6/13/2014 Y 1 2
## 89 6/13/2014 Y 1 3
## 90 6/13/2014 N 2 3
## 91 6/13/2014 Y 4 1
## 92 6/13/2014 N 1 1
## 93 6/13/2014 Y 3 2
## 94 6/13/2014 N 4 1
## 95 6/13/2014 Y 4 1
## 96 6/13/2014 Y 3 2
## 97 6/13/2014 N 3 2
## 98 6/13/2014 Y 4 5
## 99 6/13/2014 N 2 1
## 100 6/13/2014 Y 4 1
## 101 6/13/2014 Y 1 3
## 102 6/13/2014 Y 2 3
## 103 6/13/2014 Y 2 3
## 104 6/13/2014 N 1 1
## 105 6/13/2014 Y 2 2
## 106 6/13/2014 N 2 2
## 107 6/13/2014 Y 4 1
## 108 6/13/2014 N 8 2
## 109 6/13/2014 Y 3 2
## 110 6/13/2014 Y 2 1
## 111 6/13/2014 Y 4 1
## 112 6/13/2014 N 1 2
## 113 6/13/2014 Y 1 2
## 114 6/13/2014 Y 2 3
## refinance loan_type
## 1 No Refinancing Mortgage
## 2 For Shortern tenure Personal
## 3 No Refinancing Personal
## 4 For Shortern tenure Personal
## 5 For longer ternure Mortgage
## 6 For Shortern tenure Mortgage
## 7 For longer ternure Mortgage
## 8 No Refinancing Mortgage
## 9 For longer ternure Mortgage
## 10 No Refinancing Children
## 11 For Shortern tenure Mortgage
## 12 No Refinancing Auto
## 13 For Shortern tenure Auto
## 14 No Refinancing Personal
## 15 For Shortern tenure Personal
## 16 For longer ternure Mortgage
## 17 For Shortern tenure Mortgage
## 18 For longer ternure Mortgage
## 19 No Refinancing Mortgage
## 20 For longer ternure Mortgage
## 21 No Refinancing Mortgage
## 22 For Shortern tenure Mortgage
## 23 No Refinancing Mortgage
## 24 For Shortern tenure Mortgage
## 25 No Refinancing Mortgage
## 26 For longer ternure Mortgage
## 27 No Refinancing Personal
## 28 For Shortern tenure Personal
## 29 For longer ternure Mortgage
## 30 No Refinancing Mortgage
## 31 For longer ternure Mortgage
## 32 No Refinancing Mortgage
## 33 For Shortern tenure Children
## 34 No Refinancing Children
## 35 For Shortern tenure Mortgage
## 36 For longer ternure Mortgage
## 37 For Shortern tenure Auto
## 38 No Refinancing Mortgage
## 39 For Shortern tenure Personal
## 40 No Refinancing Personal
## 41 For Shortern tenure Personal
## 42 For longer ternure Mortgage
## 43 No Refinancing Mortgage
## 44 For longer ternure Mortgage
## 45 No Refinancing Mortgage
## 46 For Shortern tenure Mortgage
## 47 No Refinancing Mortgage
## 48 For Shortern tenure Mortgage
## 49 No Refinancing Personal
## 50 For Shortern tenure Mortgage
## 51 For longer ternure Mortgage
## 52 No Refinancing Personal
## 53 For longer ternure Mortgage
## 54 No Refinancing Mortgage
## 55 For Shortern tenure Mortgage
## 56 For longer ternure Mortgage
## 57 For Shortern tenure Mortgage
## 58 For longer ternure Mortgage
## 59 No Refinancing Mortgage
## 60 For longer ternure Mortgage
## 61 No Refinancing Auto
## 62 For longer ternure Mortgage
## 63 For Shortern tenure Personal
## 64 For longer ternure Personal
## 65 No Refinancing Mortgage
## 66 For longer ternure Mortgage
## 67 No Refinancing Mortgage
## 68 For Shortern tenure Mortgage
## 69 For longer ternure Mortgage
## 70 No Refinancing Children
## 71 For longer ternure Mortgage
## 72 No Refinancing Mortgage
## 73 For Shortern tenure Auto
## 74 For Shortern tenure Mortgage
## 75 For longer ternure Mortgage
## 76 No Refinancing Personal
## 77 For longer ternure Mortgage
## 78 No Refinancing Mortgage
## 79 For Shortern tenure Mortgage
## 80 No Refinancing Mortgage
## 81 For Shortern tenure Mortgage
## 82 For longer ternure Mortgage
## 83 No Refinancing Children
## 84 For Shortern tenure Mortgage
## 85 No Refinancing Auto
## 86 For Shortern tenure Auto
## 87 No Refinancing Personal
## 88 For longer ternure Personal
## 89 No Refinancing Personal
## 90 For Shortern tenure Mortgage
## 91 No Refinancing Mortgage
## 92 For Shortern tenure Mortgage
## 93 For longer ternure Mortgage
## 94 For Shortern tenure Mortgage
## 95 For longer ternure Mortgage
## 96 No Refinancing Mortgage
## 97 For Shortern tenure Mortgage
## 98 For Shortern tenure Mortgage
## 99 For Shortern tenure Mortgage
## 100 For longer ternure Mortgage
## 101 No Refinancing Personal
## 102 For longer ternure Mortgage
## 103 No Refinancing Mortgage
## 104 For Shortern tenure Mortgage
## 105 No Refinancing Mortgage
## 106 For Shortern tenure Mortgage
## 107 For longer ternure Mortgage
## 108 For Shortern tenure Mortgage
## 109 For longer ternure Mortgage
## 110 No Refinancing Auto
## 111 For longer ternure Mortgage
## 112 For Shortern tenure Personal
## 113 For longer ternure Personal
## 114 No Refinancing Mortgage
From the AccountManager data, remove records with age group ‘<20’?
acunt<-subset(AccountsManager,AccountsManager$Agegroup != "<20")
From the CustTrans_Internal data, exclude records with 3 defaults in 12 months and 5 late payments in 12 months. ?
Acc<-filter(CustTrans_Internal,num_late_payments <5 ,num_miss_payments > 3)
View(Acc)