Page 79 - ECLECTIC MARCH-2022 INSIDE PAGES_p2.indd
P. 79
as per and performant Not appropriate
The optimal number of clusters for large
2. Hierarchical can be obtained by the model datasets
Clustering itself, practical visualization
with the dendrogram
a points We will approach the clustering problem by implementing the
e groups
up than k-means algorithm. K-means is a distance-based method that
egregate
iteratively updates the location of k cluster centroids until
ould be
convergence. The main user-defined ingredients of the k-means
ping can
g it into aalngdoDrtihtEehmSnuCamrRebetIhrPeoTfdiIcsOltuansNtceerOsfukFn.cTtDihoiAns T(poaAfrtaemnSeEEteuTrclnideeeadns distance) b) Docketed consumer numbers: After the initial
to be set investigation of the call at consumer premises by our
able to team, feedback is entered in the database for low /
e data of akc-mcoDeradanitnsaggtSrooeuthptesfaothpreplCidcalauttaisobntyeormripninrgoimbliezmingdotmheaisnu.mIn a nutshell, fluctuating voltage calls. The main database for our
of squared study is the docketed calls with consumer numbers
Arbitrary with tag of low voltage complaints.
ithm of dceisntttCarineoocinadesls.lutbmheetewroentheunemrtbhdeeartdaiasstteahtepwopiirtnihmtstaharneydldotawhteavirtohrltaeatsgpweeiclcltiobvmee upcsllaeoisdnettsost.
apes can For consumer number-05320294076, it is from
Different faIcVto. rsDcEaSnCRbIPeTIaOnNaOlyFzeDdATfoArSdEaTta analysis job. Commercial District number 5, Meter book no.320 of
Many page number 294 & by-number 7 with a check digit 6. For
thms of DatWa SeethfaovreClidusetnertiifinegd: few of them for our analysis are any new consumer appears adjacent to the consumer
egorical physically exists, new by-number just after the existing
discussed below: consumer or new page is added in the same book & new
of vector Consumer number is the primary data that will be used to tie all consumer number is allocated accordingly.
aims to ffthaecewtaooo)rtfshteDcchraeeanndmttbaaetefarsoaoronsueoartulryvcrwziesaeii:nttdhsIanflotyohgrsueiedrsnalaootearwffireaacndlv,iaiaosclllcyotusawnisgssseeuejbodmcsboibe.tmeeWrlspotelcwoahai:nlarlevtsage.tiisDdoteeiufnrrfteitCrfheiaeenldlit-r
h each Hence, we can consider two consumer numbers
(cluster complaints. Moreover, in this era of social media, with similar 1st 7-digits, which are not only listed
cluster. consecutively in the book but also are located physically
a) Datcaosnosuurmcee:rsInogfteennercaol,mcopnlasuinmtserisncvaallriaotuosusroCcaiall-mceendteira adjacent to each other. For example, two consumer
tatistics, or vpislaittsfoormurs,offilickiea,l wFeabcseitbeotook,regWistheartsthAepirp,comChpalatibnotst.- numbers 05288272000 & 05288271003 are both from
analysis cMoomr‘epebolavuiendrtd,syi’,ninetmhivasailre,iroTauwsoitftessoro,cciSaiMall Smmeeetddcii.aa,Locpwolnatsvfuoomrltmearsgs,eolcfitkaeelnl,s Commercial District number 5, Meter book no.288 of
build a Facefrboomoka,llWvahriaotsuAs pdpa,taCshoautrbcoets-‘aerbeucdadpyt’u, reemd athilr,oTuwghitttehre, pages number271 & 272 are also located nearby. Now,
ustering SMSsyestce.mLaoswshvowltangebecalollws .frPormeviaolul svlayrioonulsy,dcaotamspoularicnetss using this concept, if we can do geographical clustering
are cfraopmturtehdethCraolul gchenthtreesayrsetetmakaesnshinotwonabcecloouwn.tPwrehviiloeutshlye of the registered consumer numbers with low voltage
ch: each ownhliycl,eocmothmpelpalcianoitnmstspinlfarsoinomtcsitahlienmCesaodllciaicaeplnltamrtefeoadrrimea tsapkhleaantsfoianrmtcoassacchacadosuinnagt complaints, we can visualize the concentrated zones in
sters are casceaffdeincgt oefffdecetvoafludinevgatlhuiengbrtahnedbrimanadgiem. age. the graph to identify low voltage pockets.
ch: all 11-digit consumer number is itself an information
rformed about the location of the consumer as given below:
Figure 3F: iDga3t.aDsaotaurscoeurocfe oLfoLwowvovlotaltgaegeccaalllsls (Tableau ➤ 1st 2-digit-Commercial district
(Tableau Dashboard) ➤ Next 3-digit- Book Number 4
Dashboard) ➤ Next 3-digit- Page Number
➤ Next 2-digit – By Number
➤ Last Digit-check digit
e) RevenuFeigeuarren5in: gCtohnrsouumghereNnuermgbyebriClllsa:sTsihecatotitoanl summer
billing data (April-June; three months’ consumption) from
cI)T Fdraetqabuaesnecyis otfo cbaellsfeitnchetdhefoyreathre: Isnamtehedoacbkoevteed-
conmsuemnetirosnetod diadteanbtaifsye, ftrheequehingchyerhasrebveeennuem-geennteiroantiendg
VcceoIrnPtaisanvuCinamoinlenacurobssmunl.esmbuienemrrsreser:pWfnoourretmhftboahevremresaaswttaa.hmgicfeohr
f) d‘VoIcPkectoendsumcoern’saugmaienrsst
are of high priority in
dte)rmRsepoef toitfifveerincgalslservinicem. uWltiitphleVIyPeatargss: Mfroumltiptlhee yseaamrse’
g) Adanodacdydlkyeiaetsattiiaeors’dbs.naadslceoantilsaostuaomdob/feAertsCha, cecpAersispaosmpreildtieyc&adtsciohooocnmuk:elpdtaFerdrbeoedmctoognittvhsheueenmpMeirnerAsseSthntDoet
FFigigur4e.4D: a(Dt(TaTaaatsbabolluseeoraaucuuercDDoeaafossLhfhobLbwooowaavrrdovdol))tlataggeecacalllsls sysitdemen, taifdydliotinogn-apl elonaddinrgeqcuailrlesm. ent for the same docketed
b) Docketed Consumer numbers: After the initial ec)onRsuemveenrsuien neeaarrnhinisgtotryh,roifuagnhy, eisnteorgbey pbloiltltse:dTthoeactcoetsasl
lvooaldstauggmreo,mwwetehrc&abnmilllooinrseegrtehvdeeasntauame eg(.eAnperrial-tJiuonn.eW; itthhrseuestaimneodnltohws’
investigation of the call at consumer premises by our team, V. PROCEDURE OF THE ANALYSIS
feedback is entered in the database for low / fluctuating
79voltage calls. The main database for our study is the A. GENERATION OF THE REPORT OF LOW VOLTAGE CALLS
docketed calls with consumer numbers with tag of low
voltage complaints. The first step is to download a report of low voltage calls by
consumer number in a specific time period from call-centre
For consumer number-05320294076, it is from Commercial database to create the primary dataset.
The optimal number of clusters for large
2. Hierarchical can be obtained by the model datasets
Clustering itself, practical visualization
with the dendrogram
a points We will approach the clustering problem by implementing the
e groups
up than k-means algorithm. K-means is a distance-based method that
egregate
iteratively updates the location of k cluster centroids until
ould be
convergence. The main user-defined ingredients of the k-means
ping can
g it into aalngdoDrtihtEehmSnuCamrRebetIhrPeoTfdiIcsOltuansNtceerOsfukFn.cTtDihoiAns T(poaAfrtaemnSeEEteuTrclnideeeadns distance) b) Docketed consumer numbers: After the initial
to be set investigation of the call at consumer premises by our
able to team, feedback is entered in the database for low /
e data of akc-mcoDeradanitnsaggtSrooeuthptesfaothpreplCidcalauttaisobntyeormripninrgoimbliezmingdotmheaisnu.mIn a nutshell, fluctuating voltage calls. The main database for our
of squared study is the docketed calls with consumer numbers
Arbitrary with tag of low voltage complaints.
ithm of dceisntttCarineoocinadesls.lutbmheetewroentheunemrtbhdeeartdaiasstteahtepwopiirtnihmtstaharneydldotawhteavirtohrltaeatsgpweeiclcltiobvmee upcsllaeoisdnettsost.
apes can For consumer number-05320294076, it is from
Different faIcVto. rsDcEaSnCRbIPeTIaOnNaOlyFzeDdATfoArSdEaTta analysis job. Commercial District number 5, Meter book no.320 of
Many page number 294 & by-number 7 with a check digit 6. For
thms of DatWa SeethfaovreClidusetnertiifinegd: few of them for our analysis are any new consumer appears adjacent to the consumer
egorical physically exists, new by-number just after the existing
discussed below: consumer or new page is added in the same book & new
of vector Consumer number is the primary data that will be used to tie all consumer number is allocated accordingly.
aims to ffthaecewtaooo)rtfshteDcchraeeanndmttbaaetefarsoaoronsueoartulryvcrwziesaeii:nttdhsIanflotyohgrsueiedrsnalaootearwffireaacndlv,iaiaosclllcyotusawnisgssseeuejbodmcsboibe.tmeeWrlspotelcwoahai:nlarlevtsage.tiisDdoteeiufnrrfteitCrfheiaeenldlit-r
h each Hence, we can consider two consumer numbers
(cluster complaints. Moreover, in this era of social media, with similar 1st 7-digits, which are not only listed
cluster. consecutively in the book but also are located physically
a) Datcaosnosuurmcee:rsInogfteennercaol,mcopnlasuinmtserisncvaallriaotuosusroCcaiall-mceendteira adjacent to each other. For example, two consumer
tatistics, or vpislaittsfoormurs,offilickiea,l wFeabcseitbeotook,regWistheartsthAepirp,comChpalatibnotst.- numbers 05288272000 & 05288271003 are both from
analysis cMoomr‘epebolavuiendrtd,syi’,ninetmhivasailre,iroTauwsoitftessoro,cciSaiMall Smmeeetddcii.aa,Locpwolnatsvfuoomrltmearsgs,eolcfitkaeelnl,s Commercial District number 5, Meter book no.288 of
build a Facefrboomoka,llWvahriaotsuAs pdpa,taCshoautrbcoets-‘aerbeucdadpyt’u, reemd athilr,oTuwghitttehre, pages number271 & 272 are also located nearby. Now,
ustering SMSsyestce.mLaoswshvowltangebecalollws .frPormeviaolul svlayrioonulsy,dcaotamspoularicnetss using this concept, if we can do geographical clustering
are cfraopmturtehdethCraolul gchenthtreesayrsetetmakaesnshinotwonabcecloouwn.tPwrehviiloeutshlye of the registered consumer numbers with low voltage
ch: each ownhliycl,eocmothmpelpalcianoitnmstspinlfarsoinomtcsitahlienmCesaodllciaicaeplnltamrtefeoadrrimea tsapkhleaantsfoianrmtcoassacchacadosuinnagt complaints, we can visualize the concentrated zones in
sters are casceaffdeincgt oefffdecetvoafludinevgatlhuiengbrtahnedbrimanadgiem. age. the graph to identify low voltage pockets.
ch: all 11-digit consumer number is itself an information
rformed about the location of the consumer as given below:
Figure 3F: iDga3t.aDsaotaurscoeurocfe oLfoLwowvovlotaltgaegeccaalllsls (Tableau ➤ 1st 2-digit-Commercial district
(Tableau Dashboard) ➤ Next 3-digit- Book Number 4
Dashboard) ➤ Next 3-digit- Page Number
➤ Next 2-digit – By Number
➤ Last Digit-check digit
e) RevenuFeigeuarren5in: gCtohnrsouumghereNnuermgbyebriClllsa:sTsihecatotitoanl summer
billing data (April-June; three months’ consumption) from
cI)T Fdraetqabuaesnecyis otfo cbaellsfeitnchetdhefoyreathre: Isnamtehedoacbkoevteed-
conmsuemnetirosnetod diadteanbtaifsye, ftrheequehingchyerhasrebveeennuem-geennteiroantiendg
VcceoIrnPtaisanvuCinamoinlenacurobssmunl.esmbuienemrrsreser:pWfnoourretmhftboahevremresaaswttaa.hmgicfeohr
f) d‘VoIcPkectoendsumcoern’saugmaienrsst
are of high priority in
dte)rmRsepoef toitfifveerincgalslservinicem. uWltiitphleVIyPeatargss: Mfroumltiptlhee yseaamrse’
g) Adanodacdydlkyeiaetsattiiaeors’dbs.naadslceoantilsaostuaomdob/feAertsCha, cecpAersispaosmpreildtieyc&adtsciohooocnmuk:elpdtaFerdrbeoedmctoognittvhsheueenmpMeirnerAsseSthntDoet
FFigigur4e.4D: a(Dt(TaTaaatsbabolluseeoraaucuuercDDoeaafossLhfhobLbwooowaavrrdovdol))tlataggeecacalllsls sysitdemen, taifdydliotinogn-apl elonaddinrgeqcuailrlesm. ent for the same docketed
b) Docketed Consumer numbers: After the initial ec)onRsuemveenrsuien neeaarrnhinisgtotryh,roifuagnhy, eisnteorgbey pbloiltltse:dTthoeactcoetsasl
lvooaldstauggmreo,mwwetehrc&abnmilllooinrseegrtehvdeeasntauame eg(.eAnperrial-tJiuonn.eW; itthhrseuestaimneodnltohws’
investigation of the call at consumer premises by our team, V. PROCEDURE OF THE ANALYSIS
feedback is entered in the database for low / fluctuating
79voltage calls. The main database for our study is the A. GENERATION OF THE REPORT OF LOW VOLTAGE CALLS
docketed calls with consumer numbers with tag of low
voltage complaints. The first step is to download a report of low voltage calls by
consumer number in a specific time period from call-centre
For consumer number-05320294076, it is from Commercial database to create the primary dataset.
