Healtcare Dataset.xlsx

	A	B	C	D	E	F	G	H	I	J	K
1	Patient_ID	Admit_Date	Discharge_Date	Diagnosis	Bed_Occupancy	Test	Doctor	Followup Date	Feedback	Billing Amount	Health Insurance Amount
2	23571	31/12/2022	12/1/2023	Viral Infection	General	MRI	Jay Sinha	20/1/2023	5	13234	11911
3	27781	4/1/2023	12/1/2023	Typhoid	ICU	MRI	Jaya Yaadav	16/1/2023	4	12241	11017
4	24413	5/1/2023	12/1/2023	Malaria	General	CT Scan	Jay Sinha	15/1/2023	5	35255	31730
5	27360	5/1/2023	12/1/2023	Flu	Private	X-Ray	Jaya Yaadav	19/1/2023	5	6582	5924
6	26097	6/1/2023	12/1/2023	Viral Infection	General	Blood Test	Jaya Yaadav	6/2/2023	4.9	4567	4110
7	28623	6/1/2023	12/1/2023	Flu	General	Blood Test	Naresh Goyenka	20/1/2023	5	6454	5809
8	23992	7/1/2023	12/1/2023	Malaria	General	X-Ray	Tejas Saxena	16/1/2023	5	2245	2021
9	25255	7/1/2023	12/1/2023	Pneumonia	Private	X-Ray	Mark Joy	15/1/2023	5	5637	5073
10	25676	7/1/2023	12/1/2023	Viral Infection	Private	Ultrasound	Jaya Yaadav	19/1/2023	5	65748	59173
11	26939	7/1/2023	12/1/2023	Malaria	ICU	Blood Test	Tejas Saxena	7/2/2023	5	2343	2109
12	29465	7/1/2023	12/1/2023	Viral Infection	General	Blood Test	Jaya Yaadav	20/1/2023	5	6346	5711
13	29886	7/1/2023	12/1/2023	Viral Infection	Private	CT Scan	Tejas Saxena	16/1/2023	3.5	23945	21551
14	28202	8/1/2023	12/1/2023	Typhoid	Private	Blood Test	Tejas Saxena	15/1/2023	5	3424	3082
15	24834	9/1/2023	12/1/2023	Flu	General	Blood Test	Tejas Saxena	19/1/2023	5	12990	11691
16	30307	9/1/2023	12/1/2023	Typhoid	Private	Ultrasound	Mark Joy	7/2/2023	5	78960	71064
17	26518	10/1/2023	12/1/2023	Flu	Private	X-Ray	Jaya Yaadav	20/1/2023	4	7583	6825
18	29044	11/1/2023	12/1/2023	Viral Infection	Private	CT Scan	Ravi D	16/1/2023	5	32484	29236
19	30308	11/12/2022	13/1/2023	Typhoid	General	CT Scan	Naresh Goyenka	16/1/2023	4.9	45837	41253
20	26098	5/1/2023	13/1/2023	Fracture	ICU	Ultrasound	Mark Joy	20/1/2023	5	56784	51106
21	25677	6/1/2023	13/1/2023	Viral Infection	Private	CT Scan	Mark Joy	7/2/2023	5	45899	41309
22	24414	7/1/2023	13/1/2023	Typhoid	Private	MRI	Ravi D	21/1/2023	3.5	74329	66896
23	26940	7/1/2023	13/1/2023	Fracture	Private	Blood Test	Naresh Goyenka	17/1/2023	5	3252	2927
24	23572	8/1/2023	13/1/2023	Flu	Private	CT Scan	Jay Sinha	16/1/2023	5	32484	29236
25	23993	8/1/2023	13/1/2023	Flu	ICU	Blood Test	Jaya Yaadav	20/1/2023	5	8394	7555
26	25256	8/1/2023	13/1/2023	Flu	General	Ultrasound	Tejas Saxena	7/2/2023	4.5	85778	77200
27	27782	8/1/2023	13/1/2023	Typhoid	Private	Blood Test	Jaya Yaadav	21/1/2023	4.9	1284	1156
28	28203	8/1/2023	13/1/2023	Pneumonia	Private	MRI	Naresh Goyenka	17/1/2023	5	43522	39170
29	26519	9/1/2023	13/1/2023	Flu	Private	CT Scan	Mark Joy	16/1/2023	4	34567	31110
30	29466	9/1/2023	13/1/2023	Typhoid	General	Blood Test	Ravi D	20/1/2023	5	4567	4110
31	28624	10/1/2023	13/1/2023	Malaria	ICU	MRI	Jay Sinha	8/2/2023	5	43205	38885
32	24835	11/1/2023	13/1/2023	Pneumonia	ICU	Ultrasound	Ravi D	21/1/2023	4	87895	79106
33	29045	11/1/2023	13/1/2023	Viral Infection	General	Blood Test	Jay Sinha	17/1/2023	5	1223	1101
34	29887	11/1/2023	13/1/2023	Viral Infection	ICU	MRI	Tejas Saxena	16/1/2023	4	74329	66896
35	27361	12/1/2023	13/1/2023	Pneumonia	Private	Blood Test	Naresh Goyenka	20/1/2023	3.5	3434	3091
36	28625	12/12/2022	14/1/2023	Viral Infection	Private	Blood Test	Jay Sinha	8/2/2023	4.9	8732	7859
37	30309	22/12/2022	14/1/2023	Typhoid	Private	CT Scan	Jay Sinha	22/1/2023	5	23945	21551
38	30660	2/1/2023	14/1/2023	Malaria	General	Ultrasound	Naresh Goyenka	18/1/2023	5	34784	31306
39	23857	5/1/2023	14/1/2023	Pneumonia	Private	MRI	Ravi D	17/1/2023	4.9	43205	38885
40	29467	5/1/2023	14/1/2023	Viral Infection	Private	MRI	Tejas Saxena	21/1/2023	5	22109	19898
41	30538	5/1/2023	14/1/2023	Viral Infection	Private	Blood Test	Naresh Goyenka	8/2/2023	5	3434	3091
42	24415	6/1/2023	14/1/2023	Viral Infection	ICU	Ultrasound	Jay Sinha	22/1/2023	4	24754	22279
43	23892	7/1/2023	14/1/2023	Malaria	Private	Ultrasound	Niki Sharma	18/1/2023	4	65879	59291
44	23994	7/1/2023	14/1/2023	Typhoid	ICU	CT Scan	Naresh Goyenka	17/1/2023	4.9	45834	41251
45	25257	8/1/2023	14/1/2023	Malaria	Private	CT Scan	Naresh Goyenka	21/1/2023	4	24943	22449
46	30585	8/1/2023	14/1/2023	Fracture	General	CT Scan	Jaya Yaadav	9/2/2023	4.5	56743	51069
47	23573	9/1/2023	14/1/2023	Flu	Private	MRI	Niki Sharma	22/1/2023	4	43255	38930
48	24145	9/1/2023	14/1/2023	Viral Infection	Private	CT Scan	Jay Sinha	18/1/2023	4.9	87654	78889
49	26099	9/1/2023	14/1/2023	Flu	Private	Blood Test	Ravi D	17/1/2023	5	3434	3091
50	26520	9/1/2023	14/1/2023	Malaria	Private	Ultrasound	Jaya Yaadav	21/1/2023	5	35756	32180
51	23820	10/1/2023	14/1/2023	Flu	Private	MRI	Jay Sinha	9/2/2023	3.5	43432	39089
52	24836	10/1/2023	14/1/2023	Viral Infection	Private	CT Scan	Ravi D	22/1/2023	5	45837	41253
53	27783	10/1/2023	14/1/2023	Flu	Private	Blood Test	Naresh Goyenka	18/1/2023	3.5	3252	2927
54	23697	11/1/2023	14/1/2023	Typhoid	Private	MRI	Tejas Saxena	17/1/2023	5	24210	21789
55	26941	11/1/2023	14/1/2023	Flu	General	X-Ray	Tejas Saxena	21/1/2023	5	8746	7871
56	29046	11/1/2023	14/1/2023	Viral Infection	Private	Blood Test	Mark Joy	9/2/2023	5	1284	1156
57	29888	11/1/2023	14/1/2023	Flu	Private	Blood Test	Naresh Goyenka	22/1/2023	5	8732	7859
58	30681	11/1/2023	14/1/2023	Malaria	ICU	CT Scan	Niki Sharma	18/1/2023	5	47564	42808
59	27362	12/1/2023	14/1/2023	Malaria	Private	MRI	Ravi D	17/1/2023	4.9	34531	31078
60	28204	12/1/2023	14/1/2023	Viral Infection	General	Ultrasound	Niki Sharma	21/1/2023	5	84764	76288
61	23963	13/1/2023	14/1/2023	Malaria	General	MRI	Mark Joy	9/2/2023	5	43255	38930
62	25678	13/1/2023	14/1/2023	Malaria	Private	Blood Test	Jaya Yaadav	22/1/2023	4.5	2343	2109
63	30337	13/1/2023	14/1/2023	Viral Infection	Private	Blood Test	Jay Sinha	18/1/2023	5	6346	5711
64	26942	13/12/2022	15/1/2023	Viral Infection	General	MRI	Mark Joy	18/1/2023	5	8472	7625
65	28626	23/12/2022	15/1/2023	Typhoid	General	Blood Test	Jaya Yaadav	22/1/2023	5	4567	4110
66	23964	25/12/2022	15/1/2023	Fracture	Private	MRI	Jay Sinha	10/2/2023	5	34352	30917
67	23858	6/1/2023	15/1/2023	Viral Infection	General	X-Ray	Ravi D	23/1/2023	4.5	8465	7619
68	27784	6/1/2023	15/1/2023	Flu	Private	MRI	Tejas Saxena	19/1/2023	4.9	24210	21789
69	29468	6/1/2023	15/1/2023	Flu	ICU	MRI	Ravi D	18/1/2023	5	23444	21100
70	30539	6/1/2023	15/1/2023	Malaria	General	MRI	Mark Joy	22/1/2023	5	8472	7625
71	29047	7/1/2023	15/1/2023	Viral Infection	Private	MRI	Mark Joy	10/2/2023	4	23443	21099
72	30586	7/1/2023	15/1/2023	Viral Infection	Private	X-Ray	Ravi D	23/1/2023	5	4738	4264
73	23574	9/1/2023	15/1/2023	Typhoid	Private	Blood Test	Tejas Saxena	19/1/2023	5	8732	7859
74	23698	9/1/2023	15/1/2023	Viral Infection	General	X-Ray	Naresh Goyenka	18/1/2023	4.9	4566	4109
75	30310	9/1/2023	15/1/2023	Pneumonia	General	CT Scan	Jaya Yaadav	22/1/2023	5	12348	11113
76	30682	9/1/2023	15/1/2023	Pneumonia	Private	Blood Test	Tejas Saxena	10/2/2023	4	6454	5809
77	24146	10/1/2023	15/1/2023	Viral Infection	Private	CT Scan	Niki Sharma	23/1/2023	5	45899	41309
78	24416	10/1/2023	15/1/2023	Viral Infection	General	Ultrasound	Tejas Saxena	19/1/2023	5	75684	68116
79	24837	10/1/2023	15/1/2023	Viral Infection	General	MRI	Jay Sinha	18/1/2023	5	10003	9003
80	30661	10/1/2023	15/1/2023	Typhoid	Private	Blood Test	Niki Sharma	22/1/2023	5	8394	7555
81	26100	11/1/2023	15/1/2023	Malaria	Private	MRI	Jaya Yaadav	11/2/2023	3.5	23444	21100
82	29889	11/1/2023	15/1/2023	Flu	General	MRI	Ravi D	23/1/2023	4.9	53422	48080
83	25258	12/1/2023	15/1/2023	Pneumonia	Private	Blood Test	Niki Sharma	19/1/2023	5	12990	11691
84	27363	12/1/2023	15/1/2023	Fracture	General	Blood Test	Jay Sinha	18/1/2023	5	4567	4110
85	28205	12/1/2023	15/1/2023	Viral Infection	Private	X-Ray	Tejas Saxena	22/1/2023	5	3475	3128
86	25679	13/1/2023	15/1/2023	Malaria	Private	MRI	Niki Sharma	11/2/2023	4	12342	11108
87	26521	13/1/2023	15/1/2023	Pneumonia	General	CT Scan	Jay Sinha	23/1/2023	4.9	83754	75379
88	23821	14/1/2023	15/1/2023	Viral Infection	General	MRI	Naresh Goyenka	19/1/2023	5	12342	11108
89	23893	14/1/2023	15/1/2023	Flu	Private	Ultrasound	Jay Sinha	18/1/2023	5	87436	78692
90	23995	14/1/2023	15/1/2023	Malaria	General	Blood Test	Tejas Saxena	22/1/2023	4	1223	1101
91	30338	14/1/2023	15/1/2023	Viral Infection	General	MRI	Naresh Goyenka	11/2/2023	3.5	22109	19898
92	25259	14/12/2022	16/1/2023	Viral Infection	Private	Blood Test	Jaya Yaadav	24/1/2023	5	3424	3082
93	23822	24/12/2022	16/1/2023	Viral Infection	Private	Blood Test	Tejas Saxena	20/1/2023	5	2343	2109
94	26943	24/12/2022	16/1/2023	Pneumonia	General	MRI	Naresh Goyenka	19/1/2023	4.5	34531	31078
95	30311	26/12/2022	16/1/2023	Flu	Private	CT Scan	Jaya Yaadav	23/1/2023	4	47564	42808
96	30339	26/12/2022	16/1/2023	Flu	General	Blood Test	Niki Sharma	12/2/2023	5	2342	2108
97	26101	7/1/2023	16/1/2023	Pneumonia	General	CT Scan	Niki Sharma	24/1/2023	5	38899	35009
98	27785	7/1/2023	16/1/2023	Flu	General	MRI	Ravi D	20/1/2023	5	53422	48080
99	27364	8/1/2023	16/1/2023	Malaria	ICU	MRI	Mark Joy	19/1/2023	3.5	34352	30917
100	23699	9/1/2023	16/1/2023	Viral Infection	ICU	Ultrasound	Ravi D	23/1/2023	3.5	56748	51073