Cleaned Countries Life Expectancy Dataset

Scaled Countries Life Expectancy Dataset (no missing values)

@kaggle.paperxd_cleaned_life_expectancy_dataset

Table List

1 table(200.4 KB)

Cleaned Life Exp

@kaggle.paperxd_cleaned_life_expectancy_dataset.cleaned_life_exp

200.4 KB
2938 rows
22 columns

country Country	year Year	status Status	life_expectancy Life Expectancy	adult_mortality Adult Mortality	infant_deaths Infant Deaths	alcohol Alcohol	percentage_expenditure Percentage Expenditure	hepatitis_b Hepatitis B	measles Measles	bmi BMI	under_five_deaths Under-five Deaths	polio Polio	total_expenditure Total Expenditure	diphtheria Diphtheria	hiv_aids HIV/AIDS	gdp GDP	population Population	thinness_1_19_years Thinness 1-19 Years	thinness_5_9_years Thinness 5-9 Years	income_composition_of_resources Income Composition Of Resources	schooling Schooling
Afghanistan	1.6217623010351567	-0.4593985099361714	-0.4436909012880545	0.7902380162040601	0.2688237751028905	-1.1335711079673514	-0.3355703117263752	-0.6359710477162417	-0.1103843724913253	-0.9591161804958594	0.2553591236602127	-3.2680192089165527	0.8894859356408038	-0.7305779003510356	-0.3234448000817086	-0.4835461186578253	0.3439926026292686	2.7968053425297903	2.757185396646576	-0.7044825600155852	-0.5636139252889358
Afghanistan	1.4049862482398328	-0.4593985099361714	-0.9792791096816856	0.8546135301901625	0.2857863783534794	-1.1335711079673514	-0.3344413196904387	-0.755661006325577	-0.1681237077224487	-0.9840655555969458	0.2740602388458842	-1.0480769413711255	0.8974927926329715	-0.8570915880524737	-0.3234448000817086	-0.4815529386652232	-0.2037056997844359	2.8646873409086964	2.80154992876312	-0.7187096386687841	-0.5933907676054858
Afghanistan	1.1882101954445088	-0.4593985099361714	-0.9792791096816856	0.8304727124453741	0.3027489816040682	-1.1335711079673514	-0.3345944403160823	-0.6758677005860201	-0.17353131917914	-1.009014930698032	0.2927613540315556	-0.877312151559939	0.8774756501525522	-0.7727491295848483	-0.3234448000817086	-0.4802178256971218	0.3111262571802217	2.9099420064946333	2.8459144608796625	-0.7471637959751821	-0.6231676099220359
Afghanistan	0.9714341426491848	-0.4593985099361714	-1.021286027987068	0.8626604694384253	0.3281928864799515	-1.1335711079673514	-0.3320964370773485	-0.5561777419766848	0.0320451357147537	-1.0339643057991186	0.3176961742791175	-0.6638561642959556	1.0336093614998256	-0.6462354418834103	-0.3234448000817086	-0.4775393921833956	-0.1484688960419651	2.9551966720805702	2.912461259054478	-0.7803603128326462	-0.652944452238586
Afghanistan	0.754658089853861	-0.4593985099361714	-1.0527912167161049	0.8868012871832138	0.3451554897305404	-1.1335711079673514	-0.3678621577636695	-0.5162810891069064	0.0517567516697898	-1.0539238058799876	0.3426309945266795	-0.621164966843159	0.7733865092543695	-0.6040642126495976	-0.3234448000817086	-0.5200436934719146	-0.1602455143533788	3.023078670459476	2.9568257911710214	-0.8230415487922431	-0.7422749791882366
Afghanistan	0.5378820370585369	-0.4593985099361714	-1.0947981350214884	0.918989044176265	0.3705993946064236	-1.1335711079673514	-0.3313441882727278	-0.5960743948464632	-0.0375560569052408	-1.078873180981074	0.3737995198361319	-0.7065473617487523	1.3058424992335336	-0.688406671117223	-0.3234448000817086	-0.485714031457498	-0.1618100054207905	3.068333336045413	3.0011903232875645	-0.851495706098641	-0.8316055061378873
Afghanistan	0.3211059842632129	-0.4593985099361714	-1.1158015941741792	0.9350829226727906	0.3960432994823069	-1.1335711079673514	-0.342874386143724	-0.7157643534557985	0.0384993816469337	-1.1038225560821604	0.3987343400836938	-0.8346209541071423	1.3939179261473806	-0.814920358818661	-0.3234448000817086	-0.4932442309562299	-0.2044147470972516	3.11358800163135	3.0677371214623803	-0.9178887398135696	-0.9209360330875374
Afghanistan	0.1043299314678889	-0.4593985099361714	-1.168310242055908	0.9833645581623676	0.4214872043581902	-1.1286348768883103	-0.3584150665528864	-0.6758677005860201	-0.0715716773586216	-1.1287719311832467	0.4236691603312557	-0.7919297566543457	0.9575442200742308	-0.7727491295848483	-0.3234448000817086	-0.4983280354260526	-0.1643303193483998	3.158842667217288	3.1121016535789234	-0.922631099364636	-0.980489717720638
Afghanistan	-0.112446121327435	-0.4593985099361714	-1.2313206195139823	1.04774007214847	0.438449807608779	-1.131102992427831	-0.365943717270008	-0.7157643534557985	-0.111518226506438	-1.153721306284333	0.4423702755169271	-0.8346209541071423	0.3169956607008	-0.814920358818661	-0.3234448000817086	-0.4985751262856317	0.2272737852343334	3.2040973328032245	3.1564661856954674	-1.00799357128383	-1.069820244670288
Afghanistan	-0.329222174122759	-0.4593985099361714	-1.2523240786666738	1.04774007214847	0.4554124108593679	-1.1286348768883103	-0.3627934679727956	-0.6758677005860201	-0.0374688373656167	-1.1786706813854195	0.4610713907025986	-1.0480769413711255	0.5972356554266758	-1.0257765049877243	-0.3234448000817086	-0.5053929545883105	-0.1666268581998274	3.249351998389161	3.200830717812011	-1.055417166794493	-1.1591507716199387


CREATE TABLE cleaned_life_exp (
  "country" VARCHAR,
  "year" DOUBLE,
  "status" DOUBLE,
  "life_expectancy" DOUBLE,
  "adult_mortality" DOUBLE,
  "infant_deaths" DOUBLE,
  "alcohol" DOUBLE,
  "percentage_expenditure" DOUBLE,
  "hepatitis_b" DOUBLE,
  "measles" DOUBLE,
  "bmi" DOUBLE,
  "under_five_deaths" DOUBLE,
  "polio" DOUBLE,
  "total_expenditure" DOUBLE,
  "diphtheria" DOUBLE,
  "hiv_aids" DOUBLE,
  "gdp" DOUBLE,
  "population" DOUBLE,
  "thinness_1_19_years" DOUBLE,
  "thinness_5_9_years" DOUBLE,
  "income_composition_of_resources" DOUBLE,
  "schooling" DOUBLE
);