R_Work
Ravi
November 17, 2015
Importing the accounts manager data?
Accounts_manager_data<-read.csv("C:\\Users\\ravitej.kotipalli\\Desktop\\R_assignment\\AccountsManager.csv")
View(Accounts_manager_data)
p1<-Accounts_manager_data
nrow(p1)## [1] 561Removing the duplicates
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, unionA<-p1 %>% distinct
nrow(A)## [1] 500Importing the clickstream output ofdata
Click_stream_output<-read.csv("C:\\Users\\ravitej.kotipalli\\Desktop\\R_assignment\\ClickStream_output.csv")
View(Click_stream_output)Sorting of the accounts manager data
P2<-arrange(p1,Agegroup)
View(P2)Importing the custtrans_internal data
Custtrans<-read.csv("C:\\Users\\ravitej.kotipalli\\Desktop\\R_assignment\\CustTrans_Internal.csv")
View(Custtrans)Importing the equifaxdata_external data
Equifaxdata<-read.csv("C:\\Users\\ravitej.kotipalli\\Desktop\\R_assignment\\equifaxdata_external.csv")
View(Equifaxdata)Merging accounts manager data and clickstream output ofdata–>1
m=merge(Click_stream_output,p1)
View(m)Merging 2 and equifaxdata_external data–>3
m2=merge(m1,Equifaxdata)
View(m2)Merging 2 and CustTrans_Internal data –>4
m3=merge(m2,Custtrans)
View(m3)Creating a new variable for email domain
colnames(m3)[15]<- "E-Mail"
View(m3)Frequency of email domain
table(m3[[15]])##
## adelina_nabours@gmail.com adell.lipkin@lipkin.com
## 1 1
## ahmed.angalich@angalich.com ahoneywell@honeywell.com
## 1 1
## aja_gehrett@hotmail.com ajeanty@gmail.com
## 1 1
## alaine_bergesen@cox.net albina@glick.com
## 1 1
## alease@buemi.com alecia@aol.com
## 1 1
## alesia_hixenbaugh@hixenbaugh.org alex@loader.com
## 1 1
## alisha@slusarski.com aliza@aol.com
## 1 1
## allene_iturbide@cox.net alpha@yahoo.com
## 1 1
## alyce@arias.org amaclead@gmail.com
## 1 1
## amber_monarrez@monarrez.org amie.perigo@yahoo.com
## 1 1
## ammie@corrio.com an_fritz@hotmail.com
## 1 1
## andra@gmail.com angella.cetta@hotmail.com
## 1 1
## annabelle.boord@cox.net annelle@yahoo.com
## 1 1
## annmarie_castros@gmail.com aonofrio@onofrio.com
## 1 1
## apinilla@cox.net arlene_klusman@gmail.com
## 1 1
## arminda@parvis.com art@venere.org
## 1 1
## arthur.farrow@yahoo.com asergi@gmail.com
## 1 1
## audra@kohnert.com audry.yaw@yaw.org
## 2 2
## avery@cox.net badkin@hotmail.com
## 1 1
## barrett.toyama@toyama.org bbolognia@yahoo.com
## 1 1
## beatriz@yahoo.com beckie.silvestrini@silvestrini.com
## 2 1
## becky.mirafuentes@mirafuentes.com belen_strassner@aol.com
## 1 1
## benton.skursky@aol.com bernardine_rodefer@yahoo.com
## 1 1
## bette_nicka@cox.net bfigeroa@aol.com
## 1 1
## bgillaspie@gillaspie.com billye_miro@cox.net
## 1 1
## bmalet@yahoo.com bok.isaacs@aol.com
## 1 1
## bpugh@aol.com brandon_callaro@hotmail.com
## 1 2
## brett.mccullan@mccullan.com brhym@rhym.com
## 1 1
## britt@galam.org bsama@cox.net
## 1 1
## buddy.cloney@yahoo.com bulah_padilla@hotmail.com
## 1 1
## caitlin.julia@julia.org calbares@gmail.com
## 1 1
## candida_corbley@hotmail.com caprice@aol.com
## 1 1
## carey_dopico@dopico.org carissa.batman@yahoo.com
## 1 1
## carlee.boulter@hotmail.com carma@cox.net
## 1 1
## carmelina_lindall@lindall.com casie.good@aol.com
## 1 1
## cassi.wildfong@aol.com catalina@hotmail.com
## 1 1
## catarina_gleich@hotmail.com cathrine.pontoriero@pontoriero.com
## 1 1
## ccookey@cookey.org cdeleo@deleo.com
## 1 1
## cecilia_colaizzo@colaizzo.com cecily@hollack.org
## 1 1
## ceola.setter@setter.org cgoldammer@cox.net
## 1 1
## chanel.caudy@caudy.org chantell@yahoo.com
## 1 1
## charlene.hamilton@hotmail.com chau@gmail.com
## 1 1
## chauncey_motley@aol.com chaya@malvin.com
## 1 1
## cherry@lietz.com cheryl@haroldson.org
## 1 1
## choa@hoa.org christiane.eschberger@yahoo.com
## 1 1
## ckorando@hotmail.com clapage@lapage.com
## 1 1
## claribel_varriano@cox.net clorinda.heimann@hotmail.com
## 1 2
## colette.kardas@yahoo.com cordelia_storment@aol.com
## 1 1
## corinne@loder.org cory.gibes@gmail.com
## 1 1
## cristal@cox.net cristy@lother.com
## 1 1
## csweigard@sweigard.com cventura@yahoo.com
## 1 1
## cyril_daufeldt@daufeldt.com dalene.riden@aol.com
## 1 1
## dalene@schoeneck.org danica_bruschke@gmail.com
## 1 2
## daron_dinos@cox.net dcomnick@cox.net
## 1 1
## ddhamer@cox.net dean_ketelsen@gmail.com
## 1 1
## deandrea@yahoo.com deeanna_juhas@gmail.com
## 1 1
## delisa.crupi@crupi.com delmy.ahle@hotmail.com
## 1 1
## denise@patak.org deonna_kippley@hotmail.com
## 1 1
## detra@aol.com devora_perez@perez.org
## 1 1
## devorah@hotmail.com dhidvegi@yahoo.com
## 2 1
## diane@cox.net dick@yahoo.com
## 1 2
## dkines@hotmail.com doldroyd@aol.com
## 1 1
## dominque.dickerson@dickerson.org donette.foller@cox.net
## 2 1
## dorothy@cox.net dottie@hellickson.org
## 1 1
## dperruzza@perruzza.com dulce_labreche@yahoo.com
## 1 1
## dweirather@aol.com dyum@yahoo.com
## 1 1
## earleen_mai@cox.net eden_jayson@yahoo.com
## 1 1
## egwalthney@yahoo.com eladia@saulter.com
## 1 1
## elke_sengbusch@yahoo.com elly_morocco@gmail.com
## 1 1
## elvera.benimadho@cox.net elza@yahoo.com
## 1 1
## emclaird@mclaird.com emerson.bowley@bowley.org
## 1 1
## emiceli@miceli.org erick.ferencz@aol.com
## 2 1
## erick_nievas@aol.com erinn.canlas@canlas.com
## 1 1
## ernest@cox.net ernie_stenseth@aol.com
## 1 2
## estrella@aol.com ettie.hoopengardner@hotmail.com
## 1 2
## eun@yahoo.com evangelina@aol.com
## 2 1
## ezekiel@chui.com fabiola.hauenstein@hauenstein.org
## 1 1
## fannie.lungren@yahoo.com fausto_agramonte@yahoo.com
## 1 1
## felix_hirpara@cox.net femard@emard.com
## 1 1
## fjillson@aol.com fletcher.flosi@yahoo.com
## 1 1
## flo.bookamer@cox.net fpoullion@poullion.com
## 1 1
## france.buzick@yahoo.com francine_vocelka@vocelka.com
## 1 1
## frederica_blunk@gmail.com freeman_gochal@aol.com
## 1 1
## fsaylors@saylors.org ftawil@hotmail.com
## 1 1
## gail@kitty.com gail_similton@similton.com
## 2 1
## galen@yahoo.com garry_keetch@hotmail.com
## 1 2
## gary_nunlee@nunlee.org gberray@gmail.com
## 1 1
## gearldine_gellinger@gellinger.com geoffrey@gmail.com
## 2 1
## gertude.witten@gmail.com gilma_liukko@gmail.com
## 1 2
## gkulzer@kulzer.org gladys.rim@rim.org
## 1 2
## glen_bartolet@hotmail.com glenna_slayton@cox.net
## 1 1
## glory@yahoo.com gmontezuma@cox.net
## 2 1
## golda_kaniecki@yahoo.com goldie.schirpke@yahoo.com
## 1 1
## gpawlowicz@yahoo.com gracia@melnyk.com
## 1 1
## gruta@cox.net gsarbacher@gmail.com
## 1 1
## gschnitzler@gmail.com gwenn_suffield@suffield.org
## 1 1
## hdemesa@cox.net hdenooyer@denooyer.org
## 1 1
## heike@gmail.com helene@aol.com
## 2 1
## helga_fredicks@yahoo.com hermila_thyberg@hotmail.com
## 1 2
## herminia@nicolozakes.org hhalter@yahoo.com
## 1 1
## hhaufler@hotmail.com hillary.skulski@aol.com
## 1 1
## hoa@sarao.org hpaulas@gmail.com
## 1 1
## hubert@walthall.org idewar@dewar.com
## 1 2
## ilene.eroman@hotmail.com iluminada.ohms@yahoo.com
## 1 1
## irma.wolfgramm@hotmail.com izetta.funnell@hotmail.com
## 1 2
## jaclyn@aol.com jacqueline.rowling@yahoo.com
## 1 1
## jade.farrar@yahoo.com jamal@vanausdal.org
## 2 1
## jamyot@hotmail.com jaquas@aquas.com
## 1 1
## jbiddy@yahoo.com jbrideau@aol.com
## 1 2
## jbutt@gmail.com jeanice.claucherty@yahoo.com
## 1 1
## jengelberg@engelberg.org jennie@cox.net
## 2 1
## jerry.dallen@yahoo.com jess.chaffins@chaffins.org
## 1 1
## jesusita.flister@hotmail.com jfallick@yahoo.com
## 1 1
## jferrario@hotmail.com jgabisi@hotmail.com
## 1 1
## jhanafan@gmail.com jina_briddick@briddick.com
## 1 1
## jmconnell@hotmail.com jmugnolo@yahoo.com
## 1 1
## joanna_leinenbach@hotmail.com joesph_degonia@degonia.org
## 1 2
## johnetta_abdallah@aol.com jolene@yahoo.com
## 1 1
## joles@gmail.com joni_breland@cox.net
## 1 1
## jose@yahoo.com joseph_cryer@cox.net
## 1 1
## josephine_darakjy@darakjy.org josphine_villanueva@villanueva.com
## 1 1
## jregusters@regusters.com jrhoden@yahoo.com
## 1 1
## jshin@shin.com junita@aol.com
## 1 1
## jzurcher@zurcher.org kaitlyn.ogg@gmail.com
## 1 1
## kallie.blackwood@gmail.com kanisha_waycott@yahoo.com
## 1 1
## karan_karpin@gmail.com karl_klonowski@yahoo.com
## 1 1
## kasandra_semidey@semidey.com kate_keneipp@yahoo.com
## 1 2
## kati.rulapaugh@hotmail.com katina_polidori@aol.com
## 1 1
## kattie@vonasek.org kayleigh.lace@yahoo.com
## 1 2
## keneth@yahoo.com kenneth.grenet@grenet.org
## 2 1
## kerry.theodorov@gmail.com kiley.caldarera@aol.com
## 1 1
## kimberlie_duenas@yahoo.com kimbery_madarang@cox.net
## 1 1
## kirk.herritt@aol.com krauser@cox.net
## 2 1
## kris@gmail.com kristeen@gmail.com
## 1 1
## kristel.ehmann@aol.com kristofer.bennick@yahoo.com
## 1 1
## lai.gato@gato.org lai@gmail.com
## 1 1
## larae_gudroe@gmail.com lashandra@yahoo.com
## 2 1
## lashon@aol.com latrice.tolfree@hotmail.com
## 2 1
## laurel@yahoo.com laurel_reitler@reitler.com
## 1 1
## lavonda@cox.net lavonna.wolny@hotmail.com
## 1 1
## lawrence.lorens@hotmail.com layla.springe@cox.net
## 1 2
## lburnard@burnard.com lemuel.latzke@gmail.com
## 1 1
## leonida@gobern.org leonora@yahoo.com
## 1 2
## leota.ragel@gmail.com leota@hotmail.com
## 1 1
## leslie@cox.net lettie_isenhower@yahoo.com
## 1 1
## levi.munis@gmail.com lezlie.craghead@craghead.org
## 1 1
## lhagele@cox.net lili.paskin@cox.net
## 1 1
## lilli@aol.com lindsey.dilello@hotmail.com
## 1 1
## linn_paa@paa.com lisha@centini.org
## 2 1
## lizbeth@yahoo.com lizette.stem@aol.com
## 1 2
## ljurney@hotmail.com llizama@cox.net
## 1 1
## lmerced@gmail.com lnestle@hotmail.com
## 1 1
## lnewville@newville.com lonna_diestel@gmail.com
## 1 1
## lonny_weglarz@gmail.com lorean.martabano@hotmail.com
## 1 1
## loren.asar@aol.com loreta.timenez@hotmail.com
## 1 1
## lorrine.worlds@worlds.com louisa@cronauer.com
## 1 1
## louvenia.beech@beech.com lpaprocki@hotmail.com
## 1 1
## lperin@perin.org lreiber@cox.net
## 2 1
## lstuer@cox.net lucina_lary@cox.net
## 1 1
## lucy@cox.net lynelle_auber@gmail.com
## 1 1
## malcolm_tromblay@cox.net malinda.hochard@yahoo.com
## 1 1
## margart_meisel@yahoo.com marge@gmail.com
## 1 1
## marguerita.hiatt@gmail.com mari_lueckenbach@yahoo.com
## 1 1
## mariann.bilden@aol.com markus@yahoo.com
## 1 1
## marti.maybury@yahoo.com martina_staback@staback.com
## 1 1
## mattie@aol.com maurine_yglesias@yglesias.com
## 1 1
## mdelasancha@hotmail.com meaghan@hotmail.com
## 1 1
## melissa@cox.net merilyn_bayless@cox.net
## 1 1
## merissa.tomblin@gmail.com merlyn_lawler@hotmail.com
## 1 1
## micaela_rhymes@gmail.com minna_amigon@yahoo.com
## 1 1
## mireya.frerking@hotmail.com mirta_mallett@gmail.com
## 2 1
## mitsue_tollner@yahoo.com mitzie_hudnall@yahoo.com
## 1 2
## mknipp@gmail.com mlayous@hotmail.com
## 1 1
## mlinahan@yahoo.com mmastella@mastella.com
## 1 2
## mmunns@cox.net mneither@yahoo.com
## 1 1
## mollie_mcdoniel@yahoo.com moon@yahoo.com
## 1 1
## mpelkowski@pelkowski.org mraymo@yahoo.com
## 1 1
## mroyster@royster.com mscipione@scipione.com
## 1 1
## my@hotmail.com nan@koppinger.com
## 1 1
## nana@aol.com natalie.fern@hotmail.com
## 1 1
## nelida@gmail.com nichelle_meteer@meteer.com
## 2 1
## nickolas_juvera@cox.net nicolette_brossart@brossart.com
## 1 1
## nieves_gotter@gmail.com noah.kalafatis@aol.com
## 1 1
## nobuko.halsey@yahoo.com norah.waymire@gmail.com
## 1 2
## novella_degroot@degroot.org nu@gmail.com
## 1 1
## olive@aol.com oretha_menter@yahoo.com
## 1 1
## oshealy@hotmail.com pamella.schmierer@schmierer.org
## 1 1
## pamella@fortino.com paris@hotmail.com
## 1 1
## paz_sahagun@cox.net pdubaldi@hotmail.com
## 1 1
## peggie@cox.net penney_weight@aol.com
## 1 2
## portia.stimmel@aol.com qbirkner@aol.com
## 2 2
## quentin_swayze@yahoo.com raina.brachle@brachle.org
## 1 1
## rasheeda@aol.com raymon.calvaresi@gmail.com
## 1 1
## reena@hotmail.com refugia.jacobos@jacobos.com
## 1 1
## regenia.kannady@cox.net reita.leto@gmail.com
## 1 1
## renea@hotmail.com ressie.auffrey@yahoo.com
## 1 1
## rgesick@gesick.org rhea_aredondo@cox.net
## 1 1
## rickie.plumer@aol.com rikki@nayar.com
## 1 2
## rima@cox.net rkampa@kampa.org
## 1 1
## rodolfo@hotmail.com rolande.spickerman@spickerman.com
## 1 1
## rolland@cox.net ronny.caiafa@caiafa.org
## 1 2
## roosevelt.hoffis@aol.com roselle.estell@hotmail.com
## 2 2
## rosio.cork@gmail.com roslyn.chavous@chavous.org
## 1 1
## roxane@hotmail.com rozella.ostrosky@ostrosky.com
## 1 1
## rpapasergi@cox.net rupthegrove@yahoo.com
## 1 1
## ruthann@hotmail.com ryan@cox.net
## 1 1
## sabra@uyetake.org sage_wieser@cox.net
## 1 1
## sarah.candlish@gmail.com sbourbon@yahoo.com
## 1 1
## scarlet.cartan@yahoo.com selma.husser@cox.net
## 1 1
## shalon@cox.net sharee_maile@aol.com
## 1 1
## sharika.eanes@aol.com shawna_palaspas@palaspas.org
## 1 2
## shawnda.yori@yahoo.com sheintzman@hotmail.com
## 1 1
## shenika@gmail.com sheridan.zane@zane.com
## 1 1
## sherita.saras@cox.net sheron@aol.com
## 1 1
## shonda_greenbush@cox.net simona@morasca.com
## 1 2
## skarpel@cox.net skye_fillingim@yahoo.com
## 1 2
## slacovara@gmail.com solange@shinko.com
## 1 2
## staci_schmaltz@aol.com stephaine@barfield.com
## 1 1
## stephaine@cox.net stephane_myricks@cox.net
## 1 1
## stephen_emigh@hotmail.com stevie.westerbeck@yahoo.com
## 1 1
## sue@aol.com sylvia_cousey@cousey.org
## 1 1
## sylvie@aol.com szagen@aol.com
## 1 1
## talia_riopelle@aol.com tamar@hotmail.com
## 1 1
## tankeny@ankeny.org tarra.nachor@cox.net
## 1 1
## taryn.moyd@hotmail.com tasia_andreason@yahoo.com
## 1 1
## tawna@gmail.com teddy_pedrozo@aol.com
## 1 1
## tegan.arceo@arceo.org tennaco@gmail.com
## 2 1
## terrilyn.rodeigues@cox.net tfeichtner@yahoo.com
## 1 1
## tfrankel@aol.com theodora.restrepo@restrepo.com
## 1 1
## theola_frey@frey.com thurman.manno@yahoo.com
## 1 1
## tiffiny_steffensmeier@cox.net timothy_mulqueen@mulqueen.org
## 1 1
## tracey@hotmail.com tresa_sweely@hotmail.com
## 1 1
## trinidad_mcrae@yahoo.com tshields@gmail.com
## 2 1
## tsmith@aol.com twana.felger@felger.org
## 1 1
## twardrip@cox.net twenner@aol.com
## 1 1
## valentine_gillian@gmail.com van.shire@shire.com
## 2 1
## vberlanga@berlanga.com venita_maillard@gmail.com
## 1 1
## vincent.meinerding@hotmail.com vinouye@aol.com
## 1 1
## viola@gmail.com virgina_tegarden@tegarden.com
## 1 1
## viva.toelkes@gmail.com vkiel@hotmail.com
## 1 1
## vklimek@klimek.org vmondella@mondella.com
## 2 2
## vrentfro@cox.net vzepp@gmail.com
## 1 1
## wacuff@gmail.com whitley.tomasulo@aol.com
## 1 1
## wilda@cox.net willard@hotmail.com
## 1 1
## willodean_konopacki@konopacki.org winfred_brucato@hotmail.com
## 2 1
## wkusko@yahoo.com wynell_dorshorst@dorshorst.org
## 1 2
## xdiscipio@gmail.com xuan@gmail.com
## 1 1
## yoko@fishburne.com yolando@cox.net
## 1 1
## youlanda@aol.com yuki_whobrey@aol.com
## 1 1
## yvonne.tjepkema@hotmail.com zona@hotmail.com
## 1 1Maximum and minimum number of page visits
minimum<-min(m3$no_of_visits)
View(minimum)
maximum<-max(m3$no_of_visits)
View(maximum)Average “Interest Score” for each “loan_type”
m4<-transform(m3,loan_type=as.numeric((loan_type)))
group<-group_by(m4,loan_type)
m5<-summarise(group,mean(interest_score))
View(m5)Frequency of Customers for different categories
group5<-group_by(m3,loan_type)
result<-summarise(group5,n_distinct(Customer_Id))
View(result)Average of num_late_payment and num_miss_payments
Av<-mean(m3$num_late_payments)
View(Av)
Av1<-mean(m3$num_miss_payments)
View(Av1)Average ‘Credit_score’ for each type of ’refinance’AND zipcode
group2<-group_by(m3,refinance,Zipcode)
m7<-summarise(group2,mean(Credit_score))
View(m7)Average ‘Credit_score’ by age group and pie chart
group3<-group_by(m4,Agegroup)
m8<-summarise(group3,mean=mean(Credit_score))
View(m8)
library(graphics)
pie(m8$mean ,m8$Agegroup)
The correlation between ‘num_enquiries’, ‘Credit_score’ andinterpretation
correlation<-cor(m3$num_enquiries, m3$Credit_score)
View(correlation)exclude records that have Credit score < 700 and which have Open Mortgage Loan and which have revolving credit
acc2<-subset(m3,-(m3$Credit_score < 700) & m3$revolv_credit == "y" & m3$open_mortg_loans == "y")
View(acc2)From the AccountManager data, remove records with age group ‘<20’
t1<-subset(p1,p1$Agegroup != "<20")
View(t1)From the CustTrans_Internal data, exclude records with 3 defaults in 12 months and 5 late payments in 12 months
back <- filter(Custtrans,num_late_payments >5 ,num_miss_payments < 3)
View(back)