Mushroom Dataset

This is a Challenge for ML learners

@kaggle.dhinaharp_mushroom_dataset

Table List

2 tables(423.86 KB)

Secondary Data

@kaggle.dhinaharp_mushroom_dataset.secondary_data

402.35 KB
61069 rows
21 columns

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
p	15.26	x	g	o	f	e	nan	w	16.95	17.09	s	y	w	u	w	t	g	nan	d	w
p	16.6	x	g	o	f	e	nan	w	17.99	18.19	s	y	w	u	w	t	g	nan	d	u
p	14.07	x	g	o	f	e	nan	w	17.8	17.74	s	y	w	u	w	t	g	nan	d	w
p	14.17	f	h	e	f	e	nan	w	15.77	15.98	s	y	w	u	w	t	p	nan	d	w
p	14.64	x	h	o	f	e	nan	w	16.53	17.2	s	y	w	u	w	t	p	nan	d	w
p	15.34	x	g	o	f	e	nan	w	17.84	18.79	s	y	w	u	w	t	p	nan	d	u
p	14.85	f	h	o	f	e	nan	w	17.71	16.89	s	y	w	u	w	t	g	nan	d	w
p	14.86	x	h	e	f	e	nan	w	17.03	17.44	s	y	w	u	w	t	p	nan	d	u
p	12.85	f	g	o	f	e	nan	w	17.27	18.69	s	y	w	u	w	t	p	nan	d	a
p	13.55	f	g	e	f	e	nan	w	16.04	16.88	s	y	w	u	w	t	p	nan	d	w


CREATE TABLE secondary_data (
  "class" VARCHAR,
  "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
);