Prediction Of Poisonous Mushrooms Cleaned

Playground Series - Season 4, Episode 8 Cleaned Dataset

@kaggle.blade007_prediction_of_poisonous_mushrooms_cleaned

Table List

3 tables(290.23 MB)

Submission

Testing Set

Training Set

Training Set

@kaggle.blade007_prediction_of_poisonous_mushrooms_cleaned.training_set

168.33 MB
3116945 rows
30 columns

id Id	class Class	cap_diameter Cap-diameter	cap_shape Cap-shape	cap_surface Cap-surface	cap_color Cap-color	does_bruise_or_bleed Does-bruise-or-bleed	gill_attachment Gill-attachment	gill_spacing Gill-spacing	gill_color Gill-color	stem_height Stem-height	stem_width Stem-width	stem_root Stem-root	stem_surface Stem-surface	stem_color Stem-color	veil_type Veil-type	veil_color Veil-color	has_ring Has-ring	ring_type Ring-type	spore_print_color Spore-print-color	habitat Habitat	season Season	log_cap_diameter Log-cap-diameter	log_stem_height Log-stem-height	log_stem_width Log-stem-width	stem_area Stem Area	stem_volume Stem Volume	cap_area Cap Area	stem_cap_ratio Stem Cap Ratio	stem_shape Stem Shape
		8.8	f	s	Other	f	a	c	w	4.51	15.39	_NA_	_NA_	w	_NA_	_NA_	f	f	_NA_	d	a	2.2823823856765264	1.706564623164823	2.796671392755738	4.25431967562815	6.733359809474644	4.124246894018546	0.4137639109228594	1.4844225782158598
1	1	4.51	x	h	o	f	a	c	n	4.79	6.48	_NA_	y	Other	_NA_	_NA_	t	Other	_NA_	d	w	1.706564623164823	1.7561322915849038	2.012232791986386	3.466960153099419	5.068717309053351	2.831746220316333	0.7237172466446233	0.8556139166288611
2		6.94	f	s	Other	f	x	c	w	6.85	9.93	_NA_	s	n	_NA_	_NA_	f	f	_NA_	l	w	2.0719132752590443	2.060513531794317	2.391511302188447	4.234403561920638	6.275688400738614	3.6591314107696142	0.6866419172864973	0.8959390487649261
3		3.88	f	y	g	f	s	_NA_	g	4.16	6.53	_NA_	_NA_	w	_NA_	_NA_	f	f	_NA_	d	u	1.5851452198650555	1.6409365794934714	2.018895041811802	3.338072971309571	4.943916632559184	2.5512948740952366	0.7285939295556929	0.943793650763782
4		5.85	x	Other	w	f	d	_NA_	w	3.37	8.36	_NA_	_NA_	w	_NA_	_NA_	f	f	_NA_	g	a	1.9242486522741336	1.4747630091074988	2.2364452904895007	3.3732504796112046	5.2256564595879125	3.3278482011844024	0.4549333763247373	1.2472369183011136
5	1	4.3	x	t	n	f	s	c	n	5.91	8.2	_NA_	_NA_	w	_NA_	Other	t	Other	_NA_	d	a	1.667706820558076	1.9329696377795784	2.2192034840549946	3.9012046979922665	5.746548560654851	2.7422591481834058	0.8647526094770575	0.8702379344467157
6		9.65	Other	y	w	f	e	c	Other	19.07	12.69	_NA_	s	w	_NA_	_NA_	t	Other	_NA_	g	w	2.365559892155434	2.9992261628082466	2.6166656393003573	5.493054447431304	7.788595028440406	4.305931464921123	1.090635828829129	0.5100912167666073
7	1	4.55	x	Other	e	f	a	_NA_	y	8.31	9.77	_NA_	_NA_	y	_NA_	w	t	Other	_NA_	d	a	1.713797927758343	2.231089091288976	2.376764491168297	4.40901782302595	6.436131944860741	2.848374621647333	1.0389944858466142	0.7773467460966736
8	1	7.36	f	h	e	f	x	d	w	5.77	17.13	b	_NA_	w	_NA_	_NA_	f	f	_NA_	d	a	2.1234584270966104	1.9125010869241836	2.8975680247667595	4.603569906223179	7.1935219503200685	3.773788096638922	0.5788397555739199	1.3784648300401858
9		6.45	x	t	n	f	a	d	w	7.13	12.77	_NA_	_NA_	Other	_NA_	_NA_	f	f	_NA_	d	a	2.008214032391468	2.0955609235597192	2.6224923127405635	4.522332994044602	6.818038562317142	3.5167416789236503	0.744517991322869	1.026408497304242


CREATE TABLE training_set (
  "id" BIGINT,
  "class" BIGINT,
  "cap_diameter" DOUBLE,
  "cap_shape" VARCHAR,
  "cap_surface" VARCHAR,
  "cap_color" VARCHAR,
  "does_bruise_or_bleed" VARCHAR,
  "gill_attachment" VARCHAR,
  "gill_spacing" VARCHAR,
  "gill_color" VARCHAR,
  "stem_height" DOUBLE,
  "stem_width" DOUBLE,
  "stem_root" VARCHAR,
  "stem_surface" VARCHAR,
  "stem_color" VARCHAR,
  "veil_type" VARCHAR,
  "veil_color" VARCHAR,
  "has_ring" VARCHAR,
  "ring_type" VARCHAR,
  "spore_print_color" VARCHAR,
  "habitat" VARCHAR,
  "season" VARCHAR,
  "log_cap_diameter" DOUBLE,
  "log_stem_height" DOUBLE,
  "log_stem_width" DOUBLE,
  "stem_area" DOUBLE,
  "stem_volume" DOUBLE,
  "cap_area" DOUBLE,
  "stem_cap_ratio" DOUBLE,
  "stem_shape" DOUBLE
);