Sheet1 PeriodOperatorIn Out TravellingNetwork TypeRatingCall Drop CategoryLatitudeLongitudeState Name Jan-20RJioIndoor4G5Satisfactory-1-1NA...

1 answer below »
Need to perform predictive analytics - pattern mining in R to find trends and correlations in historical data to determine: 1) which categories are linked with negative and positive ratings; 2) the consistency of highly-rated and poorly-rated providers; and 3) whether seasonal experience plays a role in ratings.


Sheet1 PeriodOperatorIn Out TravellingNetwork TypeRatingCall Drop CategoryLatitudeLongitudeState Name Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioOutdoor4G1Call Dropped28.2379776.83223Rajasthan Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20VodafoneIndoorUnknown1Call Dropped-1-1NA Jan-20AirtelIndoor2G2Poor Voice Quality-1-1NA Jan-20RJioIndoor4G4Satisfactory22.6734888.49038West Bengal Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20VodafoneIndoorUnknown1Poor Voice Quality21.1619272.87936Gujarat Jan-20AirtelIndoorUnknown5Satisfactory12.8790877.72427Karnataka Jan-20AirtelIndoor4G5Satisfactory12.8790877.72427Karnataka Jan-20AirtelIndoorUnknown5Satisfactory12.8790877.72427Karnataka Jan-20AirtelIndoorUnknown4Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoorUnknown5Satisfactory-1-1NA Jan-20MTNLOutdoor3G5Satisfactory28.6323177.20138NCT Jan-20RJioIndoor4G5Satisfactory25.2816183.12342Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory25.2849483.12725Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory18.66173.89554Maharashtra Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory18.66173.89554Maharashtra Jan-20AirtelIndoorUnknown5Satisfactory-1-1NA Jan-20AirtelOutdoorUnknown3Poor Voice Quality28.6665177.21455NCT Jan-20AirtelIndoor2G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20VodafoneIndoorUnknown5Satisfactory14.4479378.88622Andhra Pradesh Jan-20AirtelIndoor4G2Call Dropped19.2654373.12978Maharashtra Jan-20RJioIndoor4G5Satisfactory18.660973.89556Maharashtra Jan-20AirtelOutdoorUnknown4Satisfactory28.6665177.21455NCT Jan-20VodafoneIndoor3G4Satisfactory-1-1NA Jan-20VodafoneIndoor3G4Satisfactory-1-1NA Jan-20BSNLIndoorUnknown5Satisfactory17.6720683.18378Andhra Pradesh Jan-20AirtelIndoor4G4Satisfactory18.0072679.54697Telangana Jan-20IdeaIndoor4G2Poor Voice Quality9.96640776.41936Kerala Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20BSNLOutdoorUnknown5Satisfactory17.6720683.18378Andhra Pradesh Jan-20AirtelIndoor4G1Call Dropped-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality25.4552878.5874Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20BSNLOutdoorUnknown5Satisfactory17.6720683.18378Andhra Pradesh Jan-20BSNLIndoorUnknown5Satisfactory17.6720683.18378Andhra Pradesh Jan-20BSNLIndoor2G3Call Dropped16.7931980.82775Andhra Pradesh Jan-20IdeaOutdoor3G2Poor Voice Quality-1-1NA Jan-20RJioIndoorUnknown4Satisfactory28.6859377.36224Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory12.898477.62417Karnataka Jan-20RJioIndoor4G2Poor Voice Quality28.5332277.21512NCT Jan-20IdeaIndoor3G4Satisfactory-1-1NA Jan-20VodafoneIndoor3G2Poor Voice Quality18.4464173.88877Maharashtra Jan-20VodafoneIndoor3G2Poor Voice Quality18.4464173.88877Maharashtra Jan-20RJioIndoor4G3Poor Voice Quality18.4530573.88656Maharashtra Jan-20VodafoneIndoor3G2Poor Voice Quality18.4464173.88877Maharashtra Jan-20RJioIndoor4G3Poor Voice Quality18.4530573.88656Maharashtra Jan-20RJioIndoor4G2Poor Voice Quality18.4537173.88583Maharashtra Jan-20MTNLIndoor3G5Satisfactory28.6326577.20243NCT Jan-20AirtelOutdoor4G4Satisfactory13.4357679.95594Tamil Nadu Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioTravelling4G2Poor Voice Quality-1-1NA Jan-20RJioTravelling4G1Poor Voice Quality-1-1NA Jan-20RJioTravelling4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory17.4810378.46123Telangana Jan-20RJioOutdoor4G4Satisfactory17.4812978.46139Telangana Jan-20RJioOutdoor4G1Poor Voice Quality24.7425587.82022West Bengal Jan-20AirtelIndoor4G4Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory18.4968473.82361Maharashtra Jan-20VodafoneIndoor4G1Poor Voice Quality9.40800878.36877Tamil Nadu Jan-20AirtelIndoor4G5Satisfactory23.2704777.45714Madhya Pradesh Jan-20VodafoneIndoor4G3Poor Voice Quality22.6356288.44005West Bengal Jan-20RJioIndoor4G2Poor Voice Quality25.0144488.13969West Bengal Jan-20AirtelIndoor4G2Poor Voice Quality25.0144488.13969West Bengal Jan-20RJioOutdoor4G1Call Dropped28.1958276.81263Haryana Jan-20RJioOutdoor4G3Poor Voice Quality24.7425587.82022West Bengal Jan-20RJioIndoor4G1Poor Voice Quality28.1958276.81263Haryana Jan-20AirtelIndoor4G4Satisfactory18.4993973.84218Maharashtra Jan-20RJioOutdoor4G4Satisfactory24.9861785.1013Bihar Jan-20RJioIndoor4G4Satisfactory24.9926585.13955Bihar Jan-20RJioOutdoor4G4Satisfactory24.9919585.13921Bihar Jan-20RJioOutdoor4G4Satisfactory24.9920685.13998Bihar Jan-20AirtelIndoor4G4Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20VodafoneOutdoor4G1Poor Voice Quality28.7358977.13737NCT Jan-20VodafoneOutdoor4G5Satisfactory22.558675.76277Madhya Pradesh Jan-20RJioOutdoor4G4Satisfactory24.9917985.13971Bihar Jan-20RJioIndoor4G4Satisfactory22.4804588.40541West Bengal Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20VodafoneIndoorUnknown1Call Dropped9.4079678.36879Tamil Nadu Jan-20IdeaOutdoor4G5Satisfactory9.2034276.6924Kerala Jan-20RJioIndoor4G4Satisfactory19.2093872.8717Maharashtra Jan-20AirtelIndoor4G4Satisfactory13.4356479.9561Tamil Nadu Jan-20RJioIndoorUnknown3Satisfactory30.1048578.28756Uttarakhand Jan-20RJioIndoor4G3Satisfactory-1-1NA Jan-20AirtelOutdoor4G4Satisfactory17.4449378.46549Telangana Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G4Satisfactory24.9918385.13965Bihar Jan-20VodafoneIndoor3G4Satisfactory31.0889577.17464Himachal Pradesh Jan-20AirtelIndoor4G1Call Dropped-1-1NA Jan-20AirtelIndoor4G1Call Dropped-1-1NA Jan-20VodafoneTravelling4G1Poor Voice Quality19.2835872.86979Maharashtra Jan-20VodafoneTravelling4G1Poor Voice Quality19.2815372.85611Maharashtra Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory28.878976.63112Haryana Jan-20IdeaIndoor4G3Poor Voice Quality16.9957573.29064Maharashtra Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality28.6651877.09206NCT Jan-20VodafoneOutdoor4G1Call Dropped22.7255371.62653Gujarat Jan-20VodafoneOutdoor4G1Poor Voice Quality22.7255371.62653Gujarat Jan-20AirtelOutdoor4G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory17.4877178.31456Telangana Jan-20AirtelIndoor4G4Satisfactory18.0049379.54909Telangana Jan-20RJioIndoor4G3Satisfactory26.9280275.79228Rajasthan Jan-20AirtelIndoor4G4Satisfactory18.0049379.54909Telangana Jan-20RJioOutdoor4G1Call Dropped-1-1NA Jan-20VodafoneOutdoor4G1Call Dropped-1-1NA Jan-20RJioOutdoor4G1Call Dropped-1-1NA Jan-20RJioOutdoor4G1Call Dropped-1-1NA Jan-20RJioOutdoorUnknown5Satisfactory10.3029376.22308Kerala Jan-20AirtelIndoor4G4Satisfactory-1-1NA Jan-20BSNLIndoor3G4Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory18.7657383.4296Andhra Pradesh Jan-20AirtelIndoor4G5Satisfactory27.2103377.97196Uttar Pradesh Jan-20RJioIndoor4G1Poor Voice Quality21.1619472.87954Gujarat Jan-20VodafoneIndoor4G5Satisfactory22.7255371.62653Gujarat Jan-20RJioIndoor4G1Poor Voice Quality28.6651877.09206NCT Jan-20AirtelIndoor4G4Satisfactory18.0049379.54909Telangana Jan-20AirtelTravelling4G5Satisfactory23.267277.45774Madhya Pradesh Jan-20RJioIndoor4G4Satisfactory19.2094972.87159Maharashtra Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory17.4876778.31457Telangana Jan-20RJioIndoor4G3Satisfactory-1-1NA Jan-20VodafoneTravelling4G1Poor Voice Quality19.1195772.84704Maharashtra Jan-20VodafoneIndoor4G3Poor Voice Quality22.6356288.44005West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.6356688.44007West Bengal Jan-20BSNLIndoor3G4Satisfactory23.3405686.37175West Bengal Jan-20BSNLIndoor3G5Satisfactory22.6288988.39135West Bengal Jan-20RJioOutdoor4G4Satisfactory24.9918585.13962Bihar Jan-20VodafoneIndoor3G5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory18.4997373.8422Maharashtra Jan-20AirtelIndoor4G4Satisfactory18.4997373.8422Maharashtra Jan-20VodafoneIndoor3G4Satisfactory31.0889577.17464Himachal Pradesh Jan-20AirtelIndoor4G4Satisfactory18.0049379.54909Telangana Jan-20AirtelIndoorUnknown3Poor Voice Quality28.6665177.21455NCT Jan-20AirtelOutdoorUnknown4Satisfactory28.6665177.21455NCT Jan-20IdeaTravelling3G4Satisfactory29.4742579.64597Uttarakhand Jan-20AirtelOutdoorUnknown4Satisfactory28.6665177.21455NCT Jan-20IdeaIndoor4G3Poor Voice Quality16.9959473.29098Maharashtra Jan-20AirtelOutdoor2G1Poor Voice Quality25.8489386.57102Bihar Jan-20AirtelIndoor2G2Poor Voice Quality-1-1NA Jan-20VodafoneTravelling4G1Poor Voice Quality19.0257972.84898Maharashtra Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20BSNLIndoorUnknown3Satisfactory-1-1NA Jan-20BSNLIndoorUnknown2Poor Voice Quality-1-1NA Jan-20BSNLIndoorUnknown2Call Dropped-1-1NA Jan-20BSNLIndoorUnknown3Satisfactory-1-1NA Jan-20VodafoneIndoor3G5Satisfactory19.1412572.80561Maharashtra Jan-20RJioTravelling4G4Satisfactory25.6723178.44126Madhya Pradesh Jan-20AirtelIndoor4G1Poor Voice Quality-1-1NA Jan-20RJioIndoor4G1Call Dropped30.7263376.78019Chandigarh Jan-20IdeaOutdoor4G2Poor Voice Quality9.96659176.41902Kerala Jan-20VodafoneTravelling4G1Poor Voice Quality19.0626472.87568Maharashtra Jan-20AirtelIndoor4G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G3Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory24.9920285.14012Bihar Jan-20AirtelOutdoorUnknown3Poor Voice Quality28.6665177.21455NCT Jan-20RJioIndoorUnknown4Satisfactory28.6859777.36211Uttar Pradesh Jan-20VodafoneTravelling4G1Poor Voice Quality19.0669972.88106Maharashtra Jan-20RJioOutdoor4G4Satisfactory24.9921285.14013Bihar Jan-20AirtelOutdoorUnknown4Satisfactory28.6665177.21455NCT Jan-20BSNLIndoorUnknown5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory-1-1NA Jan-20VodafoneTravelling4G1Poor Voice Quality19.0801272.89803Maharashtra Jan-20AirtelOutdoorUnknown4Satisfactory28.6665177.21455NCT Jan-20RJioIndoor4G1Call Dropped17.5254678.26407Telangana Jan-20BSNLIndoorUnknown4Satisfactory20.2632785.83365Odisha Jan-20BSNLOutdoorUnknown4Satisfactory20.2801185.83512Odisha Jan-20IdeaIndoor4G2Poor Voice Quality9.96659176.41902Kerala Jan-20VodafoneIndoorUnknown5Satisfactory17.3503878.40896Telangana Jan-20VodafoneTravelling4G1Poor Voice Quality19.1126272.92815Maharashtra Jan-20AirtelOutdoor4G4Satisfactory28.6846877.28511NCT Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20IdeaIndoor4G3Poor Voice Quality16.9959673.29094Maharashtra Jan-20RJioIndoor4G1Call Dropped-1-1NA Jan-20RJioTravelling4G4Satisfactory17.6559677.73993Telangana Jan-20RJioOutdoor4G1Call Dropped-1-1NA Jan-20IdeaOutdoorUnknown1Poor Voice Quality13.0114377.58126Karnataka Jan-20AirtelIndoorUnknown3Call Dropped28.6846877.28511NCT Jan-20VodafoneOutdoor4G5Satisfactory25.4623981.82723Uttar Pradesh Jan-20VodafoneOutdoor4G5Satisfactory25.4623981.82723Uttar Pradesh Jan-20AirtelOutdoor4G4Satisfactory28.6846877.28511NCT Jan-20RJioIndoor4G2Call Dropped30.7263376.78019Chandigarh Jan-20AirtelIndoorUnknown5Satisfactory12.8790877.72427Karnataka Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoor4G4Satisfactory28.6846877.28511NCT Jan-20AirtelIndoor4G5Satisfactory27.2102777.97174Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory26.4823880.29488Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory27.2102777.97174Uttar Pradesh Jan-20RJioOutdoor4G5Satisfactory10.3029976.22318Kerala Jan-20AirtelOutdoor4G5Satisfactory19.4089172.82579Maharashtra Jan-20AirtelOutdoor4G3Poor Voice Quality28.6846377.28517NCT Jan-20AirtelOutdoor4G3Poor Voice Quality28.6846377.28517NCT Jan-20AirtelOutdoor4G4Satisfactory28.6846377.28517NCT Jan-20RJioIndoor4G4Satisfactory22.6240688.45175West Bengal Jan-20RJioOutdoorUnknown5Satisfactory10.3029976.22318Kerala Jan-20AirtelOutdoorUnknown3Poor Voice Quality28.6846377.28517NCT Jan-20AirtelOutdoor4G4Satisfactory28.6846377.28517NCT Jan-20VodafoneIndoor3G5Satisfactory-1-1NA Jan-20RJioIndoor4G4Satisfactory-1-1NA Jan-20VodafoneOutdoor3G2Poor Voice Quality19.121172.83958Maharashtra Jan-20AirtelIndoor4G1Poor Voice Quality13.048977.62016Karnataka Jan-20RJioTravelling4G4Satisfactory25.9144778.34116Madhya Pradesh Jan-20BSNLTravelling3G4Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory27.2102777.97174Uttar Pradesh Jan-20BSNLTravelling3G4Satisfactory-1-1NA Jan-20AirtelOutdoor4G1Call Dropped-1-1NA Jan-20AirtelOutdoorUnknown4Satisfactory28.6846877.28511NCT Jan-20BSNLIndoorUnknown5Satisfactory-1-1NA Jan-20VodafoneIndoor4G2Call Dropped-1-1NA Jan-20VodafoneIndoorUnknown1Call Dropped-1-1NA Jan-20AirtelOutdoor4G2Poor Voice Quality-1-1NA Jan-20RJioIndoorUnknown5Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory27.2103777.97196Uttar Pradesh Jan-20AirtelOutdoor4G4Satisfactory28.6846877.28511NCT Jan-20RJioIndoor4G5Satisfactory18.7656683.42967Andhra Pradesh Jan-20RJioOutdoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoorUnknown4Satisfactory28.6846877.28511NCT Jan-20IdeaIndoor4G2Poor Voice Quality9.96659176.41902Kerala Jan-20AirtelIndoorUnknown1Poor Voice Quality-1-1NA Jan-20MTNLTravelling4G1Call Dropped19.0094472.83772Maharashtra Jan-20MTNLOutdoor4G5Satisfactory19.0094472.83772Maharashtra Jan-20MTNLOutdoor4G5Satisfactory19.0705872.87221Maharashtra Jan-20MTNLIndoorUnknown5Satisfactory19.0704972.8722Maharashtra Jan-20VodafoneIndoor3G5Satisfactory19.1412572.80561Maharashtra Jan-20VodafoneIndoor3G4Satisfactory12.9402979.16908Tamil Nadu Jan-20VodafoneOutdoor4G3Satisfactory22.4668888.40074West Bengal Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioOutdoor4G4Satisfactory25.0036385.14525Bihar Jan-20VodafoneIndoor3G5Satisfactory19.1412572.80561Maharashtra Jan-20RJioIndoor4G5Satisfactory26.4416380.29804Uttar Pradesh Jan-20AirtelOutdoorUnknown3Poor Voice Quality28.6846877.28511NCT Jan-20VodafoneIndoor3G5Satisfactory19.1412572.80561Maharashtra Jan-20AirtelOutdoorUnknown4Satisfactory28.6846877.28511NCT Jan-20AirtelIndoor4G5Satisfactory17.4876978.31455Telangana Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G2Call Dropped14.5961277.56035Andhra Pradesh Jan-20AirtelIndoor4G1Call Dropped14.6712777.59328Andhra Pradesh Jan-20AirtelIndoor4G2Call Dropped14.5961977.55999Andhra Pradesh Jan-20AirtelIndoor4G1Call Dropped14.5883777.5489Andhra Pradesh Jan-20AirtelIndoor4G2Call Dropped13.1134777.6351Karnataka Jan-20VodafoneTravelling4G3Poor Voice Quality22.6356388.44005West Bengal Jan-20AirtelIndoor4G5Satisfactory17.4877178.31452Telangana Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20VodafoneIndoorUnknown4Satisfactory-1-1NA Jan-20VodafoneIndoor4G5Satisfactory19.1412572.80561Maharashtra Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoorUnknown4Satisfactory22.7983186.18608Jharkhand Jan-20RJioTravelling4G4Satisfactory17.8290876.68832Maharashtra Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor3G4Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20VodafoneIndoor3G5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory28.878976.63112Haryana Jan-20RJioOutdoor4G1Call Dropped22.089487.73433West Bengal Jan-20RJioOutdoor4G1Call Dropped22.089487.73433West Bengal Jan-20RJioOutdoor4G1Call Dropped22.089487.73433West Bengal Jan-20RJioOutdoor4G1Call Dropped22.089487.73433West Bengal Jan-20RJioOutdoor4G1Call Dropped22.089487.73433West Bengal Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioTravelling4G4Satisfactory17.8568976.55612Maharashtra Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioOutdoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory26.4416380.29804Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory26.4416380.29804Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioOutdoor4G4Satisfactory-1-1NA Jan-20RJioIndoor4G1Call Dropped25.6676878.45658Madhya Pradesh Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20AirtelIndoorUnknown1Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20VodafoneOutdoor3G2Poor Voice Quality19.1270472.83537Maharashtra Jan-20AirtelIndoor4G1Poor Voice Quality27.1274281.94312Uttar Pradesh Jan-20VodafoneTravelling4G1Poor Voice Quality19.1291172.92829Maharashtra Jan-20VodafoneTravelling2G1Poor Voice Quality19.1291172.92829Maharashtra Jan-20VodafoneTravelling4G1Poor Voice Quality19.1291172.92829Maharashtra Jan-20VodafoneTravelling3G1Poor Voice Quality19.1291172.92829Maharashtra Jan-20VodafoneTravelling4G1Poor Voice Quality19.130172.92627Maharashtra Jan-20VodafoneTravelling4G1Poor Voice Quality19.130172.92627Maharashtra Jan-20IdeaIndoor4G5Satisfactory9.16019676.7185Kerala Jan-20AirtelOutdoor4G1Call Dropped25.782273.3206Rajasthan Jan-20VodafoneIndoor4G5Satisfactory14.4465578.88745Andhra Pradesh Jan-20VodafoneIndoor3G4Satisfactory-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality25.4545378.58695Uttar Pradesh Jan-20VodafoneIndoor3G2Call Dropped-1-1NA Jan-20IdeaIndoor3G4Satisfactory21.1624973.79606Gujarat Jan-20VodafoneIndoor3G1Call Dropped-1-1NA Jan-20RJioOutdoor4G3Poor Voice Quality25.0108685.14636Bihar Jan-20VodafoneIndoor4G5Satisfactory14.4465578.88745Andhra Pradesh Jan-20VodafoneIndoor2G5Satisfactory22.6958788.39751West Bengal Jan-20IdeaIndoor4G2Poor Voice Quality9.96659176.41902Kerala Jan-20AirtelIndoor4G4Satisfactory28.878976.63112Haryana Jan-20RJioIndoor4G1Poor Voice Quality25.4545378.58695Uttar Pradesh Jan-20RJioIndoor4G4Satisfactory18.5039873.92795Maharashtra Jan-20AirtelIndoor2G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioOutdoor4G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor4G4Satisfactory18.1905776.02541Maharashtra Jan-20RJioIndoor4G5Satisfactory22.5742188.35297West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.5754888.40119West Bengal Jan-20MTNLIndoor4G5Satisfactory19.0704772.87211Maharashtra Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20IdeaOutdoorUnknown5Satisfactory-1-1NA Jan-20VodafoneTravelling3G1Poor Voice Quality19.130172.92627Maharashtra Jan-20AirtelIndoor3G4Satisfactory-1-1NA Jan-20IdeaIndoorUnknown5Satisfactory-1-1NA Jan-20AirtelOutdoor2G1Call Dropped19.1013972.92018Maharashtra Jan-20AirtelOutdoor2G1Call Dropped19.1013972.92018Maharashtra Jan-20AirtelOutdoor2G1Call Dropped19.1013972.92018Maharashtra Jan-20AirtelOutdoor2G1Call Dropped19.1013972.92018Maharashtra Jan-20AirtelOutdoor2G1Call Dropped19.1013972.92018Maharashtra Jan-20AirtelIndoor2G1Poor Voice Quality19.1013972.92018Maharashtra Jan-20AirtelOutdoorUnknown3Poor Voice Quality28.6846877.28511NCT Jan-20AirtelIndoor2G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20AirtelOutdoorUnknown5Satisfactory-1-1NA Jan-20VodafoneIndoorUnknown5Satisfactory17.3503578.40902Telangana Jan-20BSNLIndoorUnknown5Satisfactory11.0410576.92582Tamil Nadu Jan-20AirtelIndoor4G5Satisfactory11.0410276.92583Tamil Nadu Jan-20BSNLIndoorUnknown5Satisfactory11.041176.92577Tamil Nadu Jan-20AirtelIndoor4G5Satisfactory11.0410276.92581Tamil Nadu Jan-20VodafoneIndoor4G2Poor Voice Quality19.2101273.00982Maharashtra Jan-20VodafoneIndoor3G2Poor Voice Quality19.2098573.01003Maharashtra Jan-20VodafoneIndoor3G1Poor Voice Quality19.2098573.01003Maharashtra Jan-20RJioIndoor4G4Satisfactory22.4805388.40528West Bengal Jan-20AirtelIndoor4G5Satisfactory17.7296183.29564Andhra Pradesh Jan-20AirtelIndoor4G5Satisfactory17.7296183.29564Andhra Pradesh Jan-20VodafoneIndoor4G1Poor Voice Quality-1-1NA Jan-20VodafoneIndoorUnknown1Call Dropped-1-1NA Jan-20AirtelIndoor4G1Poor Voice Quality28.6152877.08869NCT Jan-20AirtelIndoor4G1Poor Voice Quality28.6152877.08869NCT Jan-20BSNLTravelling4G4Satisfactory16.7932280.82761Andhra Pradesh Jan-20BSNLIndoor4G3Satisfactory16.7932880.82769Andhra Pradesh Jan-20AirtelOutdoorUnknown4Satisfactory28.6846877.28511NCT Jan-20RJioOutdoorUnknown4Satisfactory18.0124476.07088Maharashtra Jan-20IdeaIndoor3G1Call Dropped9.40594378.36464Tamil Nadu Jan-20RJioOutdoor4G2Poor Voice Quality-1-1NA Jan-20AirtelOutdoorUnknown1Poor Voice Quality28.6693777.28461NCT Jan-20AirtelOutdoor4G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory28.6859677.36191Uttar Pradesh Jan-20RJioOutdoorUnknown4Satisfactory28.6859777.36211Uttar Pradesh Jan-20RJioTravelling4G5Satisfactory26.4415680.29792Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioTravelling4G5Satisfactory26.4415680.29792Uttar Pradesh Jan-20AirtelIndoor2G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioOutdoor4G4Satisfactory-1-1NA Jan-20VodafoneOutdoorUnknown4Satisfactory-1-1NA Jan-20BSNLIndoor3G5Satisfactory22.2882870.75734Gujarat Jan-20RJioIndoor4G1Poor Voice Quality25.6585478.44934Madhya Pradesh Jan-20RJioIndoor4G1Call Dropped30.7024177.26225Himachal Pradesh Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory25.2745783.13016Uttar Pradesh Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20AirtelIndoor4G5Satisfactory27.2084177.94111Uttar Pradesh Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G1Poor Voice Quality17.4834278.37934Telangana Jan-20RJioIndoor4G4Satisfactory-1-1NA Jan-20AirtelIndoor4G5Satisfactory17.487878.31457Telangana Jan-20RJioIndoor4G1Poor Voice Quality12.9278877.69182Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20RJioIndoor4G4Satisfactory12.9529877.69996Karnataka Jan-20VodafoneIndoor4G3Poor Voice Quality22.5753688.40127West Bengal Jan-20IdeaIndoor4G4Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoorUnknown4Satisfactory-1-1NA Jan-20VodafoneIndoor4G4Satisfactory22.575488.4012West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.575488.4012West Bengal Jan-20RJioOutdoor4G4Satisfactory17.4501782.90955Andhra Pradesh Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20IdeaIndoor4G4Satisfactory18.5446473.90928Maharashtra Jan-20RJioOutdoor4G3Poor Voice Quality24.9970985.14261Bihar Jan-20RJioIndoor4G1Call Dropped30.7024177.26225Himachal Pradesh Jan-20AirtelTravellingUnknown1Call Dropped-1-1NA Jan-20BSNLTravelling3G2Poor Voice Quality-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20VodafoneIndoor4G3Poor Voice Quality22.575488.4012West Bengal Jan-20AirtelIndoor4G4Satisfactory28.878976.63112Haryana Jan-20VodafoneIndoor4G4Satisfactory22.5753488.40118West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.5753488.40118West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.5753488.40118West Bengal Jan-20BSNLIndoor3G4Satisfactory-1-1NA Jan-20IdeaIndoor4G4Satisfactory-1-1NA Jan-20IdeaIndoorUnknown1Poor Voice Quality22.5683772.9636Gujarat Jan-20IdeaTravellingUnknown1Poor Voice Quality22.5699572.96486Gujarat Jan-20IdeaOutdoorUnknown1Call Dropped22.5554172.96068Gujarat Jan-20AirtelIndoor2G1Call Dropped-1-1NA Jan-20AirtelOutdoor4G3Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G2Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G2Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G5Satisfactory19.5761472.91739Maharashtra Jan-20AirtelIndoor4G2Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G1Call Dropped-1-1NA Jan-20AirtelIndoor4G2Poor Voice Quality-1-1NA Jan-20VodafoneIndoor3G5Satisfactory19.1412572.80561Maharashtra Jan-20AirtelIndoor4G2Poor Voice Quality-1-1NA Jan-20AirtelOutdoor4G3Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G5Satisfactory19.5761472.91739Maharashtra Jan-20AirtelOutdoor4G1Call Dropped-1-1NA Jan-20AirtelIndoor4G4Satisfactory-1-1NA Jan-20RJioOutdoor4G3Poor Voice Quality24.7480187.82778West Bengal Jan-20RJioIndoor4G1Poor Voice Quality28.7278177.14602NCT Jan-20AirtelIndoor4G3Satisfactory28.5918277.23739NCT Jan-20RJioOutdoor4G1Call Dropped15.8377274.50149Karnataka Jan-20RJioIndoor4G5Satisfactory22.5764888.36081West Bengal Jan-20MTNLOutdoor4G5Satisfactory18.97872.83305Maharashtra Jan-20RJioIndoor4G1Poor Voice Quality-1-1NA Jan-20VodafoneIndoor4G1Call Dropped9.4080478.36879Tamil Nadu Jan-20BSNLIndoor4G3Satisfactory16.7932780.82776Andhra Pradesh Jan-20BSNLIndoor4G3Satisfactory16.7932780.82776Andhra Pradesh Jan-20RJioIndoor4G5Satisfactory22.5764888.36081West Bengal Jan-20VodafoneIndoorUnknown1Call Dropped-1-1NA Jan-20BSNLIndoor2G4Satisfactory16.7932380.82767Andhra Pradesh Jan-20RJioIndoor4G2Poor Voice Quality25.4552178.58738Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20BSNLIndoor2G2Poor Voice Quality16.7931880.82767Andhra Pradesh Jan-20RJioIndoor4G5Satisfactory22.5764388.36082West Bengal Jan-20RJioIndoor4G2Call Dropped30.6803577.21447Himachal Pradesh Jan-20VodafoneOutdoorUnknown1Call Dropped28.4299877.09763Haryana Jan-20MTNLOutdoorUnknown5Satisfactory18.9763472.83338Maharashtra Jan-20RJioIndoorUnknown4Satisfactory28.6860377.36216Uttar Pradesh Jan-20VodafoneIndoor4G2Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory24.9922985.14042Bihar Jan-20RJioIndoor4G1Call Dropped30.6803577.21447Himachal Pradesh Jan-20VodafoneIndoor4G4Satisfactory19.1412572.80561Maharashtra Jan-20RJioOutdoor4G4Satisfactory24.9921985.14018Bihar Jan-20VodafoneIndoor4G4Satisfactory22.5753888.40111West Bengal Jan-20VodafoneIndoor4G5Satisfactory19.1412572.80561Maharashtra Jan-20IdeaOutdoor4G1Call Dropped-1-1NA Jan-20RJioTravelling4G3Poor Voice Quality25.1596282.37106Uttar Pradesh Jan-20VodafoneOutdoorUnknown5Satisfactory26.7785382.14085Uttar Pradesh Jan-20RJioIndoor4G1Call Dropped21.049276.55075Maharashtra Jan-20RJioOutdoor4G4Satisfactory21.0482776.54944Maharashtra Jan-20BSNLIndoor4G3Satisfactory16.7932880.82774Andhra Pradesh Jan-20RJioIndoor4G5Satisfactory25.2745783.13016Uttar Pradesh Jan-20RJioIndoor4G1Poor Voice Quality21.1930472.84313Gujarat Jan-20IdeaIndoorUnknown5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory9.59046776.56518Kerala Jan-20RJioOutdoor4G5Satisfactory26.4797580.30728Uttar Pradesh Jan-20RJioOutdoor4G3Poor Voice Quality24.7480187.82778West Bengal Jan-20RJioIndoor4G1Call Dropped-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor4G4Satisfactory9.59046776.56518Kerala Jan-20AirtelIndoor4G1Call Dropped17.4877178.31456Telangana Jan-20AirtelOutdoor2G5Satisfactory28.6238877.36763Uttar Pradesh Jan-20AirtelIndoor3G4Satisfactory28.5674177.32062Uttar Pradesh Jan-20VodafoneIndoor4G4Satisfactory22.5750188.4016West Bengal Jan-20VodafoneIndoor4G4Satisfactory22.5751888.40152West Bengal Jan-20RJioIndoor4G1Call Dropped-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality25.4552178.58738Uttar Pradesh Jan-20VodafoneOutdoor4G4Satisfactory22.5751888.40152West Bengal Jan-20BSNLIndoorUnknown3Satisfactory-1-1NA Jan-20BSNLIndoorUnknown2Poor Voice Quality-1-1NA Jan-20BSNLIndoorUnknown3Call Dropped-1-1NA Jan-20BSNLIndoorUnknown2Poor Voice Quality-1-1NA Jan-20RJioTravellingUnknown4Satisfactory28.6719277.43154Uttar Pradesh Jan-20VodafoneIndoor3G4Satisfactory-1-1NA Jan-20RJioIndoor4G3Satisfactory-1-1NA Jan-20AirtelOutdoor4G3Poor Voice Quality28.6665677.21482NCT Jan-20AirtelTravelling4G4Satisfactory13.4356679.95592Tamil Nadu Jan-20VodafoneTravelling4G4Satisfactory22.5971988.40179West Bengal Jan-20RJioIndoor4G3Satisfactory22.0635175.39976Madhya Pradesh Jan-20VodafoneTravelling4G1Call Dropped22.5088188.40095West Bengal Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoorUnknown1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality10.8142879.84191Tamil Nadu Jan-20AirtelIndoor2G1Poor Voice Quality-1-1NA Jan-20AirtelIndoorUnknown1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory17.7467975.7942Maharashtra Jan-20VodafoneTravelling4G4Satisfactory22.603688.41417West Bengal Jan-20AirtelIndoorUnknown1Poor Voice Quality18.5020373.9355Maharashtra Jan-20VodafoneIndoor4G1Call Dropped18.9952973.12187Maharashtra Jan-20AirtelIndoor4G5Satisfactory19.5761472.91739Maharashtra Jan-20VodafoneIndoor4G4Satisfactory22.603688.41417West Bengal Jan-20RJioIndoor4G1Poor Voice Quality25.4552178.58738Uttar Pradesh Jan-20VodafoneIndoorUnknown1Poor Voice Quality21.1930472.84313Gujarat Jan-20AirtelIndoor4G5Satisfactory27.2063577.9982Uttar Pradesh Jan-20AirtelIndoor4G4Satisfactory22.7987686.18893Jharkhand Jan-20VodafoneIndoor4G4Satisfactory22.603688.41417West Bengal Jan-20AirtelIndoor4G5Satisfactory27.2063577.9982Uttar Pradesh Jan-20BSNLIndoorUnknown5Satisfactory17.688883.16374Andhra Pradesh Jan-20VodafoneIndoor3G4Satisfactory22.603688.41417West Bengal Jan-20IdeaIndoor4G4Satisfactory17.4370978.50165Telangana Jan-20IdeaTravelling3G4Satisfactory29.6868379.70022Uttarakhand Jan-20RJioIndoor4G4Satisfactory24.9922285.14028Bihar Jan-20RJioOutdoor4G4Satisfactory22.8269670.86225Gujarat Jan-20RJioIndoor4G4Satisfactory22.823770.84447Gujarat Jan-20RJioIndoor4G4Satisfactory22.823770.84447Gujarat Jan-20RJioOutdoor4G4Satisfactory22.9001670.87953Gujarat Jan-20RJioOutdoor4G4Satisfactory22.9001670.87953Gujarat Jan-20RJioIndoor4G2Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory17.7469475.79421Maharashtra Jan-20RJioOutdoor4G4Satisfactory17.7468775.79413Maharashtra Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoor4G5Satisfactory17.4494682.9096Andhra Pradesh Jan-20BSNLIndoor3G5Satisfactory22.2883570.75903Gujarat Jan-20AirtelIndoor4G1Call Dropped-1-1NA Jan-20IdeaOutdoor3G2Call Dropped28.9548777.76005Uttar Pradesh Jan-20RJioIndoor4G1Poor Voice Quality21.1930472.84313Gujarat Jan-20AirtelOutdoor4G5Satisfactory17.5120878.3018Telangana Jan-20AirtelIndoorUnknown4Satisfactory32.9885174.92547Kashmir Jan-20RJioTravelling4G3Poor Voice Quality24.7428787.8205West Bengal Jan-20VodafoneIndoor4G3Poor Voice Quality22.603688.41417West Bengal Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioIndoorUnknown5Satisfactory21.7440572.14707Gujarat Jan-20RJioIndoor4G4Satisfactory18.6048873.87514Maharashtra Jan-20AirtelOutdoor4G4Satisfactory18.007479.54699Telangana Jan-20AirtelIndoor4G4Satisfactory28.8883976.60744Haryana Jan-20AirtelIndoor4G4Satisfactory18.007479.54699Telangana Jan-20BSNLOutdoor3G1Call Dropped-1-1NA Jan-20VodafoneOutdoor3G3Satisfactory27.1291778.00507Uttar Pradesh Jan-20RJioIndoor4G3Satisfactory22.0629675.39959Madhya Pradesh Jan-20VodafoneIndoor4G1Call Dropped13.3215877.14007Karnataka Jan-20IdeaIndoor4G4Satisfactory-1-1NA Jan-20AirtelOutdoor4G4Satisfactory13.4356679.95599Tamil Nadu Jan-20VodafoneIndoor3G4Satisfactory22.7417388.37165West Bengal Jan-20RJioIndoor4G5Satisfactory19.2802272.87544Maharashtra Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory17.4456278.38007Telangana Jan-20RJioOutdoor4G5Satisfactory-1-1NA Jan-20AirtelIndoor4G4Satisfactory17.4694378.36608Telangana Jan-20RJioIndoor4G3Satisfactory22.063675.3997Madhya Pradesh Jan-20AirtelIndoor4G5Satisfactory23.2705177.45692Madhya Pradesh Jan-20AirtelIndoor4G4Satisfactory26.8547380.95163Uttar Pradesh Jan-20AirtelIndoor4G4Satisfactory26.8546880.95173Uttar Pradesh Jan-20AirtelIndoor4G4Satisfactory26.8539780.95135Uttar Pradesh Jan-20RJioIndoor4G5Satisfactory26.4813180.29041Uttar Pradesh Jan-20IdeaOutdoorUnknown2Poor Voice Quality13.0112377.58128Karnataka Jan-20RJioIndoor4G4Satisfactory-1-1NA Jan-20RJioOutdoor4G2Poor Voice Quality-1-1NA Jan-20RJioOutdoor4G4Satisfactory-1-1NA Jan-20VodafoneIndoorUnknown2Poor Voice Quality21.1930472.84313Gujarat Jan-20RJioIndoor4G5Satisfactory-1-1NA Jan-20AirtelOutdoorUnknown1Poor Voice Quality28.669377.28465NCT Jan-20AirtelOutdoorUnknown1Poor Voice Quality28.6692977.28463NCT Jan-20AirtelOutdoor2G1Poor Voice Quality-1-1NA Jan-20AirtelOutdoor4G1Poor Voice Quality28.6692977.28464NCT Jan-20AirtelOutdoor3G1Poor Voice Quality28.6692977.28463NCT Jan-20BSNLOutdoorUnknown5Satisfactory17.688883.16374Andhra Pradesh Jan-20AirtelIndoorUnknown5Satisfactory-1-1NA Jan-20RJioIndoor4G1Poor Voice Quality25.4594278.58166Uttar Pradesh Jan-20AirtelIndoor4G5Satisfactory-1-1NA Jan-20RJioOutdoor4G1Call Dropped-1-1NA Jan-20AirtelIndoor4G4Satisfactory18.007479.54699Telangana Jan-20AirtelOutdoor3G1Call Dropped28.6692977.28463NCT Jan-20AirtelOutdoorUnknown1Call Dropped28.6692977.28463NCT Jan-20AirtelOutdoor4G2Poor Voice Quality26.5975193.84489Assam Jan-20AirtelOutdoorUnknown1Poor Voice Quality28.669377.28464NCT Jan-20RJioIndoor4G2Poor Voice Quality25.456478.5862Uttar Pradesh Jan-20AirtelIndoor4G4Satisfactory18.007479
calldataset2020fullyear-ngwi2bgq.xlsx
Answered 1 days AfterMar 25, 2021

Answer To: Sheet1 PeriodOperatorIn Out TravellingNetwork TypeRatingCall Drop...

Shweta answered on Mar 26 2021
141 Votes
># Load Data
> data=read.csv("data2020.csv",sep=",",header=TRUE)
> dim(data)
[1] 168481 9
> head(data)
Period X.Operator In.Out.Travelling Network.Type Rating Call.Drop.Category Latitude Longitude State.Name
1 Jan-20 RJio Indoor 4G 5 Satisfactory -1.00000 -1.00000
2 Jan-20 RJio Indoor 4G 5 Satisfactory -1.00000 -1.00000
3 Jan-20 RJio Outdoor 4G 1 Call Dropped 28.23797 76.83223 Rajasthan
4 Jan-20 Airtel Indoor 4G 5 Satisfactory -1.00000 -1.00000
5 Jan-20 Vodafone Indoor Unknown 1 Call Dropped -1.00000 -1.00000
6 Jan-20 Airtel Indoor 2G 2 Poor Voice Quality -1.00000 -1.00000
> summary(data) #to get statistical insights of data
Period X.Operator In.Out.Travelling Network.Type Rating Call.Drop.Category
Length:168481 Length:168481 Length:168481 Length:168481 Min. :1.000 Length:168481
Class :character Class :character Class :character Class :character 1st Qu.:2.000 Class :character
Mode :character Mode :character Mode :character Mode :character Median :4.000 Mode :character
Mean :3.482
3rd Qu.:5.000
Max. :5.000
Latitude Longitude State.Name
Min. :-1.00 Min. : -1.00 Length:168481
1st Qu.:-1.00 1st Qu.: -1.00 Class :character
Median :18.47 Median : 75.91 Mode :character
Mean :14.33 Mean : 54.52
3rd Qu.:22.86 3rd Qu.: 79.17
Max. :34.37 Max. :103.79
# since there was missing value in state.name column so we remove it
> data=na.omit(data)
> dim(data)
[1] 116996 9
1. Sol— to check which categories are linked with positive or negative ratings
For this, firstly plotted chi. Sq test to check the independence of ratings with network type and opertaors
H0: Rating is independent variable
H1: Rating is dependent variable (assuming p-value=0.05)
Table_1=table(data$X.Operator,data$Rating); Table_1

1 2 3 4 5
Airtel 7538 1922 3457 6783 11383
BSNL 1732 346 819 1873 3185
Idea 1774 417 1133 574 14089
MTNL 306 41 48 28 2076
Other 13 6 0 17 16
RJio 8055 2110 3373 11600 10092
Tata 0 0 1 0 0
Telenor 0 0 0 1 0
Vodafone 4804 1212 1532 6703 7937
> chisq.test(Table_1)
    Pearson's Chi-squared test
data: Table_1
X-squared = 16569, df = 32, p-value < 2.2e-16
> Table_2=table(data$Network.Type,data$Rating); Table_2

1 2 3 4 5
2G 1377 304 550 1024 2236
3G 2317 701 945 3522 5060
4G 17374 4144 7585 18900 34691
Unknown 3154 905 1283 4133 6791
>chisq.test(Table_2)
    Pearson's Chi-squared test
data: Table_3
X-squared = 386.34, df = 12, p-value < 2.2e-16
> Table_3=table(data$X.Operator,data$Network.Type); Table_3

2G 3G 4G Unknown
Airtel 1516 876 23286 5405
BSNL 1374 2326 838 3417
Idea 1073 3874 11166 1874
MTNL 5 42 1662 790
Other 3 16 13 20
RJio 13 45 33379 1793
Tata 0 0 1 0
Telenor 0 0 0 1
Vodafone 1507 5366 12349 2966
> chisq.test(Table_3)
    Pearson's Chi-squared test
data: Table_3
X-squared = 34434, df = 24, p-value < 2.2e-16
# in all the above cases p-value is coming out to be less than 0.05 (α level of significance), so we may reject the null hypothesis and conclude that Rating is dependent on other variable.
> is.numeric(data$Network.Type) #to check data type of network_type and converting them to numeric
[1] FALSE
>table(data$Network.Type)
2G 3G 4G Unknown
5491 12545 82694 16266
> data$Network.Type1[data$Network.Type=="2G"]="1"
> data$Network.Type1[data$Network.Type=="3G"]="2"
> data$Network.Type1[data$Network.Type=="4G"]="3"
> data$Network.Type1[data$Network.Type=="Unknown"]="0"
> data$Network.Type1=as.numeric(data$Network.Type1)
> is.numeric(data$Network.Type1)
[1] TRUE
plot=cor(data$Rating,data$Network.Type1) #correaltion plot
> plot
[1] -0.005207735
# there is negative correlation between Ratings and network...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?