Networks in India

-

Today I procured dataset from data.gov.in .The data is about telecom companies.  They given data points like Operator,Technology, download,speed_kbps, signal_strength,Isa. By overall analysing data I can observed that most of the people using JIO network in India.

They given operator/networks like as

  • AIRTEL
  • JIO
  • Vi India
  • CELLONE
By using this data I am analysed that in the better signal of the NORTH EAST is higher than others in the 3G technology.Lowest signal come in the Assam compared to others. Here ,In mumbai they are not any data so that we can understand may be Mumbai is no longer using this 3G network.

Here ,In the below table we can see that  Mumbai and Orissa has better signals comapared to remaining. Kerala and Himachal Pradesh has the lowest/weak signals comapred to others.



In Andhra Pradesh most of the people using JIO. Here we can observed that CELLONE is the only network which offers both 3G and 4G network in Andhra Pradesh.



Comments

Post a Comment

Popular posts from this blog

SQL Queries

-
 Hello guys! Today, I practiced SQL Queries in  SQLZoo . SELECT population FROM world WHERE name = 'Germany' SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway','Denmark') SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000; SELECT name FROM world WHERE population >= 200000000 SELECT name,(population/1000000) as population FROM world WHERE continent='South America' SELECT name,population FROM world WHERE name IN('France', 'Germany', 'Italy') SELECT name FROM world WHERE name LIKE 'United%' SELECT name, population, area FROM world WHERE area>3000000 AND population>250000000
Read more

SQL Queries

-
Image
use sql_store; Select * from customers; insert into customers values (default,'Janani','P',null,null,'RVS','MPL','AP',default); insert into customers values (default,'Lalitha','V',null,null,'MPL','MPL','AP',570), (default,'Vyshu','V',null,null,'Kadapa','Kadapa','AP',670), (default,'Sandhya','G',null,null,'GVP','MPL','AP',590); select * from products; insert into products values (default,'Appliances-Fans',30,5.30), (default,'Appliances-Kettles',35,4.63);
Read more

SQL Queries

-
Hello guys! Today, I practiced SQL Queries in  SQLZoo SELECT SUM(population) FROM world SELECT DISTINCT(continent) FROM world SELECT SUM(gdp) FROM world WHERE continent='Africa' SELECT COUNT(name) FROM world WHERE area>=1000000 SELECT SUM(population) FROM world WHERE name IN('Estonia', 'Latvia', 'Lithuania') SELECT continent,COUNT(name) FROM world GROUP BY continent SELECT continent,COUNT(name) FROM world WHERE population>=10000000 GROUP BY continent SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000
Read more