Healthcare Dataset

-

Hi guys, today  I was taken dataset from the Kaggle. Today I am analysed healthcare dataset. In this datyaset thay given patients name,age ,gender,hospitals, Doctor etc. Based on this dataset most of the patients are females. Here,we can see that chart I have created. In this dataset they have given data from the year 2018 t0 2023. Here, we can see this the total billing amount is decreased from 2022 to 2023. Most of the patients are joined in the hospital because they are suffring from Asthma and Cancer. 

Baed on these details they can take medicines accoring to medication types. If patients are high but doctors are less then they can take of this issue by hiring more doctors in particular category who treats Asthma and cancer etc. Here,they can also arrange/backup/store blood based how many patients came before who having different blood groups/types. So,based on this data mostly AB-  and AB+ patients are coming so they can backup AB- and AB+ blood types compared to other blood types.












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