Adult Census Income With AI

Artificial Intelligence to boost data science

@kaggle.blackbee2016_adult_census_income_with_ai

Table List

1 table(1.23 MB)

Modified Census Data

@kaggle.blackbee2016_adult_census_income_with_ai.modified_census_data

1.23 MB
48842 rows
30 columns

unnamed_0 Unnamed: 0	key KEY	label LABEL	age Age	capital_gain Capital Gain	education Education	education_num Education Num	fnlwgt Fnlwgt	hours_per_week Hours Per Week	marital_status Marital Status	native_country Native Country	occupation Occupation	race Race	relationship Relationship	sex Sex	worklabel WorkLABEL	labelpage LabelPage	labelpcapital_gain LabelPcapital Gain	labelpcapital_loss LabelPcapital Loss	labelpeducation LabelPeducation	labelpeducation_num LabelPeducation Num	labelphours_per_week LabelPhours Per Week	labelpmarital_status LabelPmarital Status	labelpnative_country LabelPnative Country	labelpoccupation LabelPoccupation	labelprace LabelPrace	labelprelationship LabelPrelationship	labelpsex LabelPsex	labelpworklabel LabelPworkLABEL
	1		39	2174	Bachelors	13	77516	40	Never-married	United-States	Adm-clerical	White	Not-in-family	Male	State-gov	]36.5;42.5]	]57;3048]	]-inf;77.5]	{Bachelors}	]12.5;13.5]	]39.5;41.5]	{Never-married, Separated}	{United-States, Philippines, Germany, ...}	{Adm-clerical, Machine-op-inspct, Farming-fishing}	{White, Asian-Pac-Islander}	{Not-in-family}	{Male}	{Self-emp-not-inc, Local-gov, State-gov}
1	2		50		Bachelors	13	83311	13	Married-civ-spouse	United-States	Exec-managerial	White	Husband	Male	Self-emp-not-inc	]42.5;54.5]	]-inf;57]	]-inf;77.5]	{Bachelors}	]12.5;13.5]	]-inf;34.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Exec-managerial}	{White, Asian-Pac-Islander}	{Husband, Wife}	{Male}	{Self-emp-not-inc, Local-gov, State-gov}
2	3		38		HS-grad	9	215646	40	Divorced	United-States	Handlers-cleaners	White	Not-in-family	Male	Private	]36.5;42.5]	]-inf;57]	]-inf;77.5]	{HS-grad}	]8.5;9.5]	]39.5;41.5]	{Divorced, Widowed, Married-spouse-absent}	{United-States, Philippines, Germany, ...}	{Handlers-cleaners}	{White, Asian-Pac-Islander}	{Not-in-family}	{Male}	{Private, Without-pay, Never-worked}
3	4		53		11th	7	234721	40	Married-civ-spouse	United-States	Handlers-cleaners	Black	Husband	Male	Private	]42.5;54.5]	]-inf;57]	]-inf;77.5]	{11th, 10th, 7th-8th, ...}	]-inf;8.5]	]39.5;41.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Handlers-cleaners}	{Black, Amer-Indian-Eskimo, Other}	{Husband, Wife}	{Male}	{Private, Without-pay, Never-worked}
4	5		28		Bachelors	13	338409	40	Married-civ-spouse	Cuba	Prof-specialty	Black	Wife	Female	Private	]27.5;29.5]	]-inf;57]	]-inf;77.5]	{Bachelors}	]12.5;13.5]	]39.5;41.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Prof-specialty, Protective-serv, Armed-Forces}	{Black, Amer-Indian-Eskimo, Other}	{Husband, Wife}	{Female}	{Private, Without-pay, Never-worked}
5	6		37		Masters	14	284582	40	Married-civ-spouse	United-States	Exec-managerial	White	Wife	Female	Private	]36.5;42.5]	]-inf;57]	]-inf;77.5]	{Masters}	]13.5;14.5]	]39.5;41.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Exec-managerial}	{White, Asian-Pac-Islander}	{Husband, Wife}	{Female}	{Private, Without-pay, Never-worked}
6	7		49		9th	5	160187	16	Married-spouse-absent	Jamaica	Other-service	Black	Not-in-family	Female	Private	]42.5;54.5]	]-inf;57]	]-inf;77.5]	{11th, 10th, 7th-8th, ...}	]-inf;8.5]	]-inf;34.5]	{Divorced, Widowed, Married-spouse-absent}	{United-States, Philippines, Germany, ...}	{Other-service, Priv-house-serv}	{Black, Amer-Indian-Eskimo, Other}	{Not-in-family}	{Female}	{Private, Without-pay, Never-worked}
7	8	1	52		HS-grad	9	209642	45	Married-civ-spouse	United-States	Exec-managerial	White	Husband	Male	Self-emp-not-inc	]42.5;54.5]	]-inf;57]	]-inf;77.5]	{HS-grad}	]8.5;9.5]	]41.5;49.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Exec-managerial}	{White, Asian-Pac-Islander}	{Husband, Wife}	{Male}	{Self-emp-not-inc, Local-gov, State-gov}
8	9	1	31	14084	Masters	14	45781	50	Never-married	United-States	Prof-specialty	White	Not-in-family	Female	Private	]29.5;33.5]	]10585.5;30961.5]	]-inf;77.5]	{Masters}	]13.5;14.5]	]49.5;61.5]	{Never-married, Separated}	{United-States, Philippines, Germany, ...}	{Prof-specialty, Protective-serv, Armed-Forces}	{White, Asian-Pac-Islander}	{Not-in-family}	{Female}	{Private, Without-pay, Never-worked}
9	10	1	42	5178	Bachelors	13	159449	40	Married-civ-spouse	United-States	Exec-managerial	White	Husband	Male	Private	]36.5;42.5]	]5119;5316.5]	]-inf;77.5]	{Bachelors}	]12.5;13.5]	]39.5;41.5]	{Married-civ-spouse, Married-AF-spouse}	{United-States, Philippines, Germany, ...}	{Exec-managerial}	{White, Asian-Pac-Islander}	{Husband, Wife}	{Male}	{Private, Without-pay, Never-worked}


CREATE TABLE modified_census_data (
  "unnamed_0" BIGINT,
  "key" BIGINT,
  "label" BIGINT,
  "age" BIGINT,
  "capital_gain" BIGINT,
  "capital_loss" BIGINT,
  "education" VARCHAR,
  "education_num" BIGINT,
  "fnlwgt" BIGINT,
  "hours_per_week" BIGINT,
  "marital_status" VARCHAR,
  "native_country" VARCHAR,
  "occupation" VARCHAR,
  "race" VARCHAR,
  "relationship" VARCHAR,
  "sex" VARCHAR,
  "worklabel" VARCHAR,
  "labelpage" VARCHAR,
  "labelpcapital_gain" VARCHAR,
  "labelpcapital_loss" VARCHAR,
  "labelpeducation" VARCHAR,
  "labelpeducation_num" VARCHAR,
  "labelphours_per_week" VARCHAR,
  "labelpmarital_status" VARCHAR,
  "labelpnative_country" VARCHAR,
  "labelpoccupation" VARCHAR,
  "labelprace" VARCHAR,
  "labelprelationship" VARCHAR,
  "labelpsex" VARCHAR,
  "labelpworklabel" VARCHAR
);