Health Data X Charges

A relation between health data collected and charges.

@kaggle.m1relly_healthdataxcharges

Table List

1 table(20.19 KB)

Healthdataxcharges

@kaggle.m1relly_healthdataxcharges.healthdataxcharges

20.19 KB
500 rows
12 columns

id Id	age Age	sex Sex	bmi Bmi	marital_status Marital Status	smoker Smoker	country Country	alcohol Alcohol	allergies Allergies	medicines Medicines	illness_history Illness History	charges Charges
1000	85	Female	29	Common-Law		Puerto Rico			Atenolol	Autoimmune	154.31
1001	45	Male	24	Divorced		Martinique			Cialis	Oncology	148.14
1002	38	Female	25	Divorced		South Africa	1		Plavix	Endocrine	140.77
1003	17	Male	18	Single		Belarus	1		Atenolol	Neurological	141.33
1004	79	Female	34	Married	1	Algeria	1	1	nan	Endocrine	161.64
1005	58	Male	32	Single		Poland	1	1	Doxycycline Hyclate	Autoimmune	158.96
1006	86	Male	43	Single	1	Sweden		1	Ventolin HFA	DigestiveSystem	148.49
1007	28	Female	40	Divorced		Bulgaria		1	Namenda	Endocrine	153.8
1008	89	Male	26	Married		Costa Rica		1	Naproxen	Cardiac	141.69
1009	96	Male	36	Divorced	1	Iraq			Doxycycline Hyclate	Neurological	148.99


CREATE TABLE healthdataxcharges (
  "id" BIGINT,
  "age" BIGINT,
  "sex" VARCHAR,
  "bmi" BIGINT,
  "marital_status" VARCHAR,
  "smoker" BIGINT,
  "country" VARCHAR,
  "alcohol" BIGINT,
  "allergies" BIGINT,
  "medicines" VARCHAR,
  "illness_history" VARCHAR,
  "charges" DOUBLE
);