The Complete Pokemon Dataset

Data on more than 800 Pokemon from all 7 Generations.

@kaggle.rounakbanik_pokemon

Table List

1 table(89.89 KB)

Pokemon

@kaggle.rounakbanik_pokemon.pokemon

89.89 KB
801 rows
41 columns

abilities Abilities	against_bug Against Bug	against_dark Against Dark	against_dragon Against Dragon	against_electric Against Electric	against_fairy Against Fairy	against_fight Against Fight	against_fire Against Fire	against_flying Against Flying	against_ghost Against Ghost	against_grass Against Grass	against_ground Against Ground	against_ice Against Ice	against_normal Against Normal	against_poison Against Poison	against_psychic Against Psychic	against_rock Against Rock	against_steel Against Steel	against_water Against Water	attack Attack	base_egg_steps Base Egg Steps	base_happiness Base Happiness	base_total Base Total	capture_rate Capture Rate	classfication Classfication	defense Defense	experience_growth Experience Growth	height_m Height M	hp Hp	japanese_name Japanese Name	name Name	percentage_male Percentage Male	pokedex_number Pokedex Number	sp_attack Sp Attack	sp_defense Sp Defense	speed Speed	type1 Type1	type2 Type2	weight_kg Weight Kg	generation Generation
['Overgrow', 'Chlorophyll']	1	1	1	0.5	0.5	0.5	2	2	1	0.25	1	2	1	1	2	1	1	0.5	49	5120	70	318	45	Seed Pokémon	49	1059860	0.7	45	Fushigidaneフシギダネ	Bulbasaur	88.1	1	65	65	45	grass	poison	6.9	1
['Overgrow', 'Chlorophyll']	1	1	1	0.5	0.5	0.5	2	2	1	0.25	1	2	1	1	2	1	1	0.5	62	5120	70	405	45	Seed Pokémon	63	1059860	1	60	Fushigisouフシギソウ	Ivysaur	88.1	2	80	80	60	grass	poison	13	1
['Overgrow', 'Chlorophyll']	1	1	1	0.5	0.5	0.5	2	2	1	0.25	1	2	1	1	2	1	1	0.5	100	5120	70	625	45	Seed Pokémon	123	1059860	2	80	Fushigibanaフシギバナ	Venusaur	88.1	3	122	120	80	grass	poison	100	1
['Blaze', 'Solar Power']	0.5	1	1	1	0.5	1	0.5	1	1	0.5	2	0.5	1	1	1	2	0.5	2	52	5120	70	309	45	Lizard Pokémon	43	1059860	0.6	39	Hitokageヒトカゲ	Charmander	88.1	4	60	50	65	fire	nan	8.5	1
['Blaze', 'Solar Power']	0.5	1	1	1	0.5	1	0.5	1	1	0.5	2	0.5	1	1	1	2	0.5	2	64	5120	70	405	45	Flame Pokémon	58	1059860	1.1	58	Lizardoリザード	Charmeleon	88.1	5	80	65	80	fire	nan	19	1
['Blaze', 'Solar Power']	0.25	1	1	2	0.5	0.5	0.5	1	1	0.25		1	1	1	1	4	0.5	2	104	5120	70	634	45	Flame Pokémon	78	1059860	1.7	78	Lizardonリザードン	Charizard	88.1	6	159	115	100	fire	flying	90.5	1
['Torrent', 'Rain Dish']	1	1	1	2	1	1	0.5	1	1	2	1	0.5	1	1	1	1	0.5	0.5	48	5120	70	314	45	Tiny Turtle Pokémon	65	1059860	0.5	44	Zenigameゼニガメ	Squirtle	88.1	7	50	64	43	water	nan	9	1
['Torrent', 'Rain Dish']	1	1	1	2	1	1	0.5	1	1	2	1	0.5	1	1	1	1	0.5	0.5	63	5120	70	405	45	Turtle Pokémon	80	1059860	1	59	Kameilカメール	Wartortle	88.1	8	65	80	58	water	nan	22.5	1
['Torrent', 'Rain Dish']	1	1	1	2	1	1	0.5	1	1	2	1	0.5	1	1	1	1	0.5	0.5	103	5120	70	630	45	Shellfish Pokémon	120	1059860	1.6	79	Kamexカメックス	Blastoise	88.1	9	135	115	78	water	nan	85.5	1
['Shield Dust', 'Run Away']	1	1	1	1	1	0.5	2	2	1	0.5	0.5	1	1	1	1	2	1	1	30	3840	70	195	255	Worm Pokémon	35	1000000	0.3	45	Caterpieキャタピー	Caterpie	50	10	20	20	45	bug	nan	2.9	1


CREATE TABLE pokemon (
  "abilities" VARCHAR,
  "against_bug" DOUBLE,
  "against_dark" DOUBLE,
  "against_dragon" DOUBLE,
  "against_electric" DOUBLE,
  "against_fairy" DOUBLE,
  "against_fight" DOUBLE,
  "against_fire" DOUBLE,
  "against_flying" DOUBLE,
  "against_ghost" DOUBLE,
  "against_grass" DOUBLE,
  "against_ground" DOUBLE,
  "against_ice" DOUBLE,
  "against_normal" DOUBLE,
  "against_poison" DOUBLE,
  "against_psychic" DOUBLE,
  "against_rock" DOUBLE,
  "against_steel" DOUBLE,
  "against_water" DOUBLE,
  "attack" BIGINT,
  "base_egg_steps" BIGINT,
  "base_happiness" BIGINT,
  "base_total" BIGINT,
  "capture_rate" VARCHAR,
  "classfication" VARCHAR,
  "defense" BIGINT,
  "experience_growth" BIGINT,
  "height_m" DOUBLE,
  "hp" BIGINT,
  "japanese_name" VARCHAR,
  "name" VARCHAR,
  "percentage_male" DOUBLE,
  "pokedex_number" BIGINT,
  "sp_attack" BIGINT,
  "sp_defense" BIGINT,
  "speed" BIGINT,
  "type1" VARCHAR,
  "type2" VARCHAR,
  "weight_kg" DOUBLE,
  "generation" BIGINT,
  "is_legendary" BIGINT
);