Dispensary

-

Hi guys, today I analysed a dataset on "Dispensary". In this dataset they have given 4 categories of treatments. They have given cities names and doctors count etc. Based on this visualization we can understand that Unani is only treated in the Delhi/NCR. In the city DELHI,all treatments are available there. We can see that most of the doctors are present in DELHI. Alopathic is commonly treated in all cities. Remaining treatments all not available in all cities except in DELHI.

In the below line graph shows that per city how many doctors and wellness centres are there? Based on this they can improve doctors ,wellness centers in particular areas/cities based on how much patients attending data and etc. They can also improve regarding tratment types in diff cities which are not available in particular cities.



Note:Here, in the line diagram I mistakenly typed. It's not Doctros. It's Doctors. 



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