All Pokemon Dataset

Data from all Pokemons and their different forms from all 8 generations

@kaggle.maca11_all_pokemon_dataset

Table List

1 table(90.35 KB)

All Pokemon

@kaggle.maca11_all_pokemon_dataset.all_pokemon

90.35 KB
1032 rows
44 columns

number Number	name Name	type_1 Type 1	type_2 Type 2	abilities Abilities	hp HP	att Att	def Def	spa Spa	spd Spd	spe Spe	bst BST	mean Mean	standard_deviation Standard Deviation	generation Generation	experience_type Experience Type	experience_to_level_100 Experience To Level 100	final_evolution Final Evolution	catch_rate Catch Rate	mega_evolution Mega Evolution	against_normal Against Normal	against_fire Against Fire	against_water Against Water	against_electric Against Electric	against_grass Against Grass	against_ice Against Ice	against_fighting Against Fighting	against_poison Against Poison	against_ground Against Ground	against_flying Against Flying	against_psychic Against Psychic	against_bug Against Bug	against_rock Against Rock	against_ghost Against Ghost	against_dragon Against Dragon	against_dark Against Dark	against_steel Against Steel	against_fairy Against Fairy	height Height	weight Weight	bmi BMI
1	Bulbasaur	Grass	Poison	['Chlorophyll', 'Overgrow']	45	49	49	65	65	45	318	53	8.640987597877146	1	Medium Slow	1059860		45		1	2	0.5	0.5	0.25	2	0.5	1	1	2	2	1	1	1	1	1	1	0.5	0.7	6.9	14.1
2	Ivysaur	Grass	Poison	['Chlorophyll', 'Overgrow']	60	62	63	80	80	60	405	67.5	8.902246907382429	1	Medium Slow	1059860		45		1	2	0.5	0.5	0.25	2	0.5	1	1	2	2	1	1	1	1	1	1	0.5	1	13	13
3	Venusaur	Grass	Poison	['Chlorophyll', 'Overgrow']	80	82	83	100	100	80	525	87.5	8.902246907382429	1	Medium Slow	1059860	1	45		1	2	0.5	0.5	0.25	2	0.5	1	1	2	2	1	1	1	1	1	1	0.5	2	100	25
3	Mega Venusaur	Grass	Poison	['Thick Fat']	80	100	123	122	120	80	625	104.16666666666669	18.747592438023133	6	Medium Slow	1059860	1	45	1	1	2	0.5	0.5	0.25	2	0.5	1	1	2	2	1	1	1	1	1	1	0.5	2.4	155.5	27
4	Charmander	Fire	nan	['Blaze', 'Solar Power']	39	52	43	60	50	65	309	51.5	8.995369179009089	1	Medium Slow	1059860		45		1	0.5	2	1	0.5	0.5	1	1	2	1	1	0.5	2	1	1	1	0.5	0.5	0.6	8.5	23.6
5	Charmeleon	Fire	nan	['Blaze', 'Solar Power']	58	64	58	80	65	80	405	67.5	9.233092656309694	1	Medium Slow	1059860		45		1	0.5	2	1	0.5	0.5	1	1	2	1	1	0.5	2	1	1	1	0.5	0.5	1.1	19	15.7
6	Charizard	Fire	Flying	['Blaze', 'Solar Power']	78	84	78	109	85	100	534	89	11.575836902790224	1	Medium Slow	1059860	1	45		1	0.5	2	2	0.25	1	0.5	1		1	1	0.25	4	1	1	1	0.5	0.5	1.7	90.5	31.3
6	Mega Charizard Y	Fire	Flying	['Drought']	78	104	78	159	115	100	634	105.66666666666669	27.378012264508094	6	Medium Slow	1059860	1	45	1	1	0.5	2	2	0.25	1	0.5	1		1	1	0.25	4	1	1	1	0.5	0.5	1.7	100.5	34.8
6	Mega Charizard X	Fire	Dragon	['Tough Claws']	78	130	111	130	85	100	634	105.66666666666669	20.154955277107963	6	Medium Slow	1059860	1	45	1	1	0.25	1	0.5	0.25	1	1	1	2	1	1	0.5	2	1	2	1	0.5	1	1.7	110.5	38.2
7	Squirtle	Water	nan	['Rain Dish', 'Torrent']	44	48	65	50	64	43	314	52.333333333333336	8.919392106839767	1	Medium Slow	1059860		45		1	0.5	0.5	2	2	0.5	1	1	1	1	1	1	1	1	1	1	0.5	1	0.5	9	36


CREATE TABLE all_pokemon (
  "number" BIGINT,
  "name" VARCHAR,
  "type_1" VARCHAR,
  "type_2" VARCHAR,
  "abilities" VARCHAR,
  "hp" BIGINT,
  "att" BIGINT,
  "def" BIGINT,
  "spa" BIGINT,
  "spd" BIGINT,
  "spe" BIGINT,
  "bst" BIGINT,
  "mean" DOUBLE,
  "standard_deviation" DOUBLE,
  "generation" DOUBLE,
  "experience_type" VARCHAR,
  "experience_to_level_100" BIGINT,
  "final_evolution" DOUBLE,
  "catch_rate" BIGINT,
  "legendary" DOUBLE,
  "mega_evolution" DOUBLE,
  "alolan_form" DOUBLE,
  "galarian_form" DOUBLE,
  "against_normal" DOUBLE,
  "against_fire" DOUBLE,
  "against_water" DOUBLE,
  "against_electric" DOUBLE,
  "against_grass" DOUBLE,
  "against_ice" DOUBLE,
  "against_fighting" DOUBLE,
  "against_poison" DOUBLE,
  "against_ground" DOUBLE,
  "against_flying" DOUBLE,
  "against_psychic" DOUBLE,
  "against_bug" DOUBLE,
  "against_rock" DOUBLE,
  "against_ghost" DOUBLE,
  "against_dragon" DOUBLE,
  "against_dark" DOUBLE,
  "against_steel" DOUBLE,
  "against_fairy" DOUBLE,
  "height" DOUBLE,
  "weight" DOUBLE,
  "bmi" DOUBLE
);