data <- read_excel("../00_data/Pokemon Data.xlsx")
data$pokemon
## [1] "bulbasaur" "ivysaur"
## [3] "venusaur" "charmander"
## [5] "charmeleon" "charizard"
## [7] "squirtle" "wartortle"
## [9] "blastoise" "caterpie"
## [11] "metapod" "butterfree"
## [13] "weedle" "kakuna"
## [15] "beedrill" "pidgey"
## [17] "pidgeotto" "pidgeot"
## [19] "rattata" "raticate"
## [21] "spearow" "fearow"
## [23] "ekans" "arbok"
## [25] "pikachu" "raichu"
## [27] "sandshrew" "sandslash"
## [29] "nidoran-f" "nidorina"
## [31] "nidoqueen" "nidoran-m"
## [33] "nidorino" "nidoking"
## [35] "clefairy" "clefable"
## [37] "vulpix" "ninetales"
## [39] "jigglypuff" "wigglytuff"
## [41] "zubat" "golbat"
## [43] "oddish" "gloom"
## [45] "vileplume" "paras"
## [47] "parasect" "venonat"
## [49] "venomoth" "diglett"
## [51] "dugtrio" "meowth"
## [53] "persian" "psyduck"
## [55] "golduck" "mankey"
## [57] "primeape" "growlithe"
## [59] "arcanine" "poliwag"
## [61] "poliwhirl" "poliwrath"
## [63] "abra" "kadabra"
## [65] "alakazam" "machop"
## [67] "machoke" "machamp"
## [69] "bellsprout" "weepinbell"
## [71] "victreebel" "tentacool"
## [73] "tentacruel" "geodude"
## [75] "graveler" "golem"
## [77] "ponyta" "rapidash"
## [79] "slowpoke" "slowbro"
## [81] "magnemite" "magneton"
## [83] "farfetchd" "doduo"
## [85] "dodrio" "seel"
## [87] "dewgong" "grimer"
## [89] "muk" "shellder"
## [91] "cloyster" "gastly"
## [93] "haunter" "gengar"
## [95] "onix" "drowzee"
## [97] "hypno" "krabby"
## [99] "kingler" "voltorb"
## [101] "electrode" "exeggcute"
## [103] "exeggutor" "cubone"
## [105] "marowak" "hitmonlee"
## [107] "hitmonchan" "lickitung"
## [109] "koffing" "weezing"
## [111] "rhyhorn" "rhydon"
## [113] "chansey" "tangela"
## [115] "kangaskhan" "horsea"
## [117] "seadra" "goldeen"
## [119] "seaking" "staryu"
## [121] "starmie" "mr-mime"
## [123] "scyther" "jynx"
## [125] "electabuzz" "magmar"
## [127] "pinsir" "tauros"
## [129] "magikarp" "gyarados"
## [131] "lapras" "ditto"
## [133] "eevee" "vaporeon"
## [135] "jolteon" "flareon"
## [137] "porygon" "omanyte"
## [139] "omastar" "kabuto"
## [141] "kabutops" "aerodactyl"
## [143] "snorlax" "articuno"
## [145] "zapdos" "moltres"
## [147] "dratini" "dragonair"
## [149] "dragonite" "mewtwo"
## [151] "mew" "chikorita"
## [153] "bayleef" "meganium"
## [155] "cyndaquil" "quilava"
## [157] "typhlosion" "totodile"
## [159] "croconaw" "feraligatr"
## [161] "sentret" "furret"
## [163] "hoothoot" "noctowl"
## [165] "ledyba" "ledian"
## [167] "spinarak" "ariados"
## [169] "crobat" "chinchou"
## [171] "lanturn" "pichu"
## [173] "cleffa" "igglybuff"
## [175] "togepi" "togetic"
## [177] "natu" "xatu"
## [179] "mareep" "flaaffy"
## [181] "ampharos" "bellossom"
## [183] "marill" "azumarill"
## [185] "sudowoodo" "politoed"
## [187] "hoppip" "skiploom"
## [189] "jumpluff" "aipom"
## [191] "sunkern" "sunflora"
## [193] "yanma" "wooper"
## [195] "quagsire" "espeon"
## [197] "umbreon" "murkrow"
## [199] "slowking" "misdreavus"
## [201] "unown" "wobbuffet"
## [203] "girafarig" "pineco"
## [205] "forretress" "dunsparce"
## [207] "gligar" "steelix"
## [209] "snubbull" "granbull"
## [211] "qwilfish" "scizor"
## [213] "shuckle" "heracross"
## [215] "sneasel" "teddiursa"
## [217] "ursaring" "slugma"
## [219] "magcargo" "swinub"
## [221] "piloswine" "corsola"
## [223] "remoraid" "octillery"
## [225] "delibird" "mantine"
## [227] "skarmory" "houndour"
## [229] "houndoom" "kingdra"
## [231] "phanpy" "donphan"
## [233] "porygon2" "stantler"
## [235] "smeargle" "tyrogue"
## [237] "hitmontop" "smoochum"
## [239] "elekid" "magby"
## [241] "miltank" "blissey"
## [243] "raikou" "entei"
## [245] "suicune" "larvitar"
## [247] "pupitar" "tyranitar"
## [249] "lugia" "ho-oh"
## [251] "celebi" "treecko"
## [253] "grovyle" "sceptile"
## [255] "torchic" "combusken"
## [257] "blaziken" "mudkip"
## [259] "marshtomp" "swampert"
## [261] "poochyena" "mightyena"
## [263] "zigzagoon" "linoone"
## [265] "wurmple" "silcoon"
## [267] "beautifly" "cascoon"
## [269] "dustox" "lotad"
## [271] "lombre" "ludicolo"
## [273] "seedot" "nuzleaf"
## [275] "shiftry" "taillow"
## [277] "swellow" "wingull"
## [279] "pelipper" "ralts"
## [281] "kirlia" "gardevoir"
## [283] "surskit" "masquerain"
## [285] "shroomish" "breloom"
## [287] "slakoth" "vigoroth"
## [289] "slaking" "nincada"
## [291] "ninjask" "shedinja"
## [293] "whismur" "loudred"
## [295] "exploud" "makuhita"
## [297] "hariyama" "azurill"
## [299] "nosepass" "skitty"
## [301] "delcatty" "sableye"
## [303] "mawile" "aron"
## [305] "lairon" "aggron"
## [307] "meditite" "medicham"
## [309] "electrike" "manectric"
## [311] "plusle" "minun"
## [313] "volbeat" "illumise"
## [315] "roselia" "gulpin"
## [317] "swalot" "carvanha"
## [319] "sharpedo" "wailmer"
## [321] "wailord" "numel"
## [323] "camerupt" "torkoal"
## [325] "spoink" "grumpig"
## [327] "spinda" "trapinch"
## [329] "vibrava" "flygon"
## [331] "cacnea" "cacturne"
## [333] "swablu" "altaria"
## [335] "zangoose" "seviper"
## [337] "lunatone" "solrock"
## [339] "barboach" "whiscash"
## [341] "corphish" "crawdaunt"
## [343] "baltoy" "claydol"
## [345] "lileep" "cradily"
## [347] "anorith" "armaldo"
## [349] "feebas" "milotic"
## [351] "castform" "kecleon"
## [353] "shuppet" "banette"
## [355] "duskull" "dusclops"
## [357] "tropius" "chimecho"
## [359] "absol" "wynaut"
## [361] "snorunt" "glalie"
## [363] "spheal" "sealeo"
## [365] "walrein" "clamperl"
## [367] "huntail" "gorebyss"
## [369] "relicanth" "luvdisc"
## [371] "bagon" "shelgon"
## [373] "salamence" "beldum"
## [375] "metang" "metagross"
## [377] "regirock" "regice"
## [379] "registeel" "latias"
## [381] "latios" "kyogre"
## [383] "groudon" "rayquaza"
## [385] "jirachi" "deoxys-normal"
## [387] "turtwig" "grotle"
## [389] "torterra" "chimchar"
## [391] "monferno" "infernape"
## [393] "piplup" "prinplup"
## [395] "empoleon" "starly"
## [397] "staravia" "staraptor"
## [399] "bidoof" "bibarel"
## [401] "kricketot" "kricketune"
## [403] "shinx" "luxio"
## [405] "luxray" "budew"
## [407] "roserade" "cranidos"
## [409] "rampardos" "shieldon"
## [411] "bastiodon" "burmy"
## [413] "wormadam-plant" "mothim"
## [415] "combee" "vespiquen"
## [417] "pachirisu" "buizel"
## [419] "floatzel" "cherubi"
## [421] "cherrim" "shellos"
## [423] "gastrodon" "ambipom"
## [425] "drifloon" "drifblim"
## [427] "buneary" "lopunny"
## [429] "mismagius" "honchkrow"
## [431] "glameow" "purugly"
## [433] "chingling" "stunky"
## [435] "skuntank" "bronzor"
## [437] "bronzong" "bonsly"
## [439] "mime-jr" "happiny"
## [441] "chatot" "spiritomb"
## [443] "gible" "gabite"
## [445] "garchomp" "munchlax"
## [447] "riolu" "lucario"
## [449] "hippopotas" "hippowdon"
## [451] "skorupi" "drapion"
## [453] "croagunk" "toxicroak"
## [455] "carnivine" "finneon"
## [457] "lumineon" "mantyke"
## [459] "snover" "abomasnow"
## [461] "weavile" "magnezone"
## [463] "lickilicky" "rhyperior"
## [465] "tangrowth" "electivire"
## [467] "magmortar" "togekiss"
## [469] "yanmega" "leafeon"
## [471] "glaceon" "gliscor"
## [473] "mamoswine" "porygon-z"
## [475] "gallade" "probopass"
## [477] "dusknoir" "froslass"
## [479] "rotom" "uxie"
## [481] "mesprit" "azelf"
## [483] "dialga" "palkia"
## [485] "heatran" "regigigas"
## [487] "giratina-altered" "cresselia"
## [489] "phione" "manaphy"
## [491] "darkrai" "shaymin-land"
## [493] "arceus" "victini"
## [495] "snivy" "servine"
## [497] "serperior" "tepig"
## [499] "pignite" "emboar"
## [501] "oshawott" "dewott"
## [503] "samurott" "patrat"
## [505] "watchog" "lillipup"
## [507] "herdier" "stoutland"
## [509] "purrloin" "liepard"
## [511] "pansage" "simisage"
## [513] "pansear" "simisear"
## [515] "panpour" "simipour"
## [517] "munna" "musharna"
## [519] "pidove" "tranquill"
## [521] "unfezant" "blitzle"
## [523] "zebstrika" "roggenrola"
## [525] "boldore" "gigalith"
## [527] "woobat" "swoobat"
## [529] "drilbur" "excadrill"
## [531] "audino" "timburr"
## [533] "gurdurr" "conkeldurr"
## [535] "tympole" "palpitoad"
## [537] "seismitoad" "throh"
## [539] "sawk" "sewaddle"
## [541] "swadloon" "leavanny"
## [543] "venipede" "whirlipede"
## [545] "scolipede" "cottonee"
## [547] "whimsicott" "petilil"
## [549] "lilligant" "basculin-red-striped"
## [551] "sandile" "krokorok"
## [553] "krookodile" "darumaka"
## [555] "darmanitan-standard" "maractus"
## [557] "dwebble" "crustle"
## [559] "scraggy" "scrafty"
## [561] "sigilyph" "yamask"
## [563] "cofagrigus" "tirtouga"
## [565] "carracosta" "archen"
## [567] "archeops" "trubbish"
## [569] "garbodor" "zorua"
## [571] "zoroark" "minccino"
## [573] "cinccino" "gothita"
## [575] "gothorita" "gothitelle"
## [577] "solosis" "duosion"
## [579] "reuniclus" "ducklett"
## [581] "swanna" "vanillite"
## [583] "vanillish" "vanilluxe"
## [585] "deerling" "sawsbuck"
## [587] "emolga" "karrablast"
## [589] "escavalier" "foongus"
## [591] "amoonguss" "frillish"
## [593] "jellicent" "alomomola"
## [595] "joltik" "galvantula"
## [597] "ferroseed" "ferrothorn"
## [599] "klink" "klang"
## [601] "klinklang" "tynamo"
## [603] "eelektrik" "eelektross"
## [605] "elgyem" "beheeyem"
## [607] "litwick" "lampent"
## [609] "chandelure" "axew"
## [611] "fraxure" "haxorus"
## [613] "cubchoo" "beartic"
## [615] "cryogonal" "shelmet"
## [617] "accelgor" "stunfisk"
## [619] "mienfoo" "mienshao"
## [621] "druddigon" "golett"
## [623] "golurk" "pawniard"
## [625] "bisharp" "bouffalant"
## [627] "rufflet" "braviary"
## [629] "vullaby" "mandibuzz"
## [631] "heatmor" "durant"
## [633] "deino" "zweilous"
## [635] "hydreigon" "larvesta"
## [637] "volcarona" "cobalion"
## [639] "terrakion" "virizion"
## [641] "tornadus-incarnate" "thundurus-incarnate"
## [643] "reshiram" "zekrom"
## [645] "landorus-incarnate" "kyurem"
## [647] "keldeo-ordinary" "meloetta-aria"
## [649] "genesect" "chespin"
## [651] "quilladin" "chesnaught"
## [653] "fennekin" "braixen"
## [655] "delphox" "froakie"
## [657] "frogadier" "greninja"
## [659] "bunnelby" "diggersby"
## [661] "fletchling" "fletchinder"
## [663] "talonflame" "scatterbug"
## [665] "spewpa" "vivillon"
## [667] "litleo" "pyroar"
## [669] "flabebe" "floette"
## [671] "florges" "skiddo"
## [673] "gogoat" "pancham"
## [675] "pangoro" "furfrou"
## [677] "espurr" "meowstic-male"
## [679] "honedge" "doublade"
## [681] "aegislash-shield" "spritzee"
## [683] "aromatisse" "swirlix"
## [685] "slurpuff" "inkay"
## [687] "malamar" "binacle"
## [689] "barbaracle" "skrelp"
## [691] "dragalge" "clauncher"
## [693] "clawitzer" "helioptile"
## [695] "heliolisk" "tyrunt"
## [697] "tyrantrum" "amaura"
## [699] "aurorus" "sylveon"
## [701] "hawlucha" "dedenne"
## [703] "carbink" "goomy"
## [705] "sliggoo" "goodra"
## [707] "klefki" "phantump"
## [709] "trevenant" "pumpkaboo-average"
## [711] "gourgeist-average" "bergmite"
## [713] "avalugg" "noibat"
## [715] "noivern" "xerneas"
## [717] "yveltal" "zygarde"
## [719] "diancie" "hoopa"
## [721] "volcanion" "rowlet"
## [723] "dartrix" "decidueye"
## [725] "litten" "torracat"
## [727] "incineroar" "popplio"
## [729] "brionne" "primarina"
## [731] "pikipek" "trumbeak"
## [733] "toucannon" "yungoos"
## [735] "gumshoos" "grubbin"
## [737] "charjabug" "vikavolt"
## [739] "crabrawler" "crabominable"
## [741] "oricorio-baile" "cutiefly"
## [743] "ribombee" "rockruff"
## [745] "lycanroc-midday" "wishiwashi-solo"
## [747] "mareanie" "toxapex"
## [749] "mudbray" "mudsdale"
## [751] "dewpider" "araquanid"
## [753] "fomantis" "lurantis"
## [755] "morelull" "shiinotic"
## [757] "salandit" "salazzle"
## [759] "stufful" "bewear"
## [761] "bounsweet" "steenee"
## [763] "tsareena" "comfey"
## [765] "oranguru" "passimian"
## [767] "wimpod" "golisopod"
## [769] "sandygast" "palossand"
## [771] "pyukumuku" "type-null"
## [773] "silvally" "minior-red-meteor"
## [775] "komala" "turtonator"
## [777] "togedemaru" "mimikyu-disguised"
## [779] "bruxish" "drampa"
## [781] "dhelmise" "jangmo-o"
## [783] "hakamo-o" "kommo-o"
## [785] "tapu-koko" "tapu-lele"
## [787] "tapu-bulu" "tapu-fini"
## [789] "cosmog" "cosmoem"
## [791] "solgaleo" "lunala"
## [793] "nihilego" "buzzwole"
## [795] "pheromosa" "xurkitree"
## [797] "celesteela" "kartana"
## [799] "guzzlord" "necrozma"
## [801] "magearna" "marshadow"
## [803] "deoxys-attack" "deoxys-defense"
## [805] "deoxys-speed" "wormadam-sandy"
## [807] "wormadam-trash" "shaymin-sky"
## [809] "giratina-origin" "rotom-heat"
## [811] "rotom-wash" "rotom-frost"
## [813] "rotom-fan" "rotom-mow"
## [815] "castform-sunny" "castform-rainy"
## [817] "castform-snowy" "basculin-blue-striped"
## [819] "darmanitan-zen" "meloetta-pirouette"
## [821] "tornadus-therian" "thundurus-therian"
## [823] "landorus-therian" "kyurem-black"
## [825] "kyurem-white" "keldeo-resolute"
## [827] "meowstic-female" "aegislash-blade"
## [829] "pumpkaboo-small" "pumpkaboo-large"
## [831] "pumpkaboo-super" "gourgeist-small"
## [833] "gourgeist-large" "gourgeist-super"
## [835] "venusaur-mega" "charizard-mega-x"
## [837] "charizard-mega-y" "blastoise-mega"
## [839] "alakazam-mega" "gengar-mega"
## [841] "kangaskhan-mega" "pinsir-mega"
## [843] "gyarados-mega" "aerodactyl-mega"
## [845] "mewtwo-mega-x" "mewtwo-mega-y"
## [847] "ampharos-mega" "scizor-mega"
## [849] "heracross-mega" "houndoom-mega"
## [851] "tyranitar-mega" "blaziken-mega"
## [853] "gardevoir-mega" "mawile-mega"
## [855] "aggron-mega" "medicham-mega"
## [857] "manectric-mega" "banette-mega"
## [859] "absol-mega" "garchomp-mega"
## [861] "lucario-mega" "abomasnow-mega"
## [863] "floette-eternal" "latias-mega"
## [865] "latios-mega" "swampert-mega"
## [867] "sceptile-mega" "sableye-mega"
## [869] "altaria-mega" "gallade-mega"
## [871] "audino-mega" "sharpedo-mega"
## [873] "slowbro-mega" "steelix-mega"
## [875] "pidgeot-mega" "glalie-mega"
## [877] "diancie-mega" "metagross-mega"
## [879] "kyogre-primal" "groudon-primal"
## [881] "rayquaza-mega" "pikachu-rock-star"
## [883] "pikachu-belle" "pikachu-pop-star"
## [885] "pikachu-phd" "pikachu-libre"
## [887] "pikachu-cosplay" "hoopa-unbound"
## [889] "camerupt-mega" "lopunny-mega"
## [891] "salamence-mega" "beedrill-mega"
## [893] "rattata-alola" "raticate-alola"
## [895] "raticate-totem-alola" "pikachu-original-cap"
## [897] "pikachu-hoenn-cap" "pikachu-sinnoh-cap"
## [899] "pikachu-unova-cap" "pikachu-kalos-cap"
## [901] "pikachu-alola-cap" "raichu-alola"
## [903] "sandshrew-alola" "sandslash-alola"
## [905] "vulpix-alola" "ninetales-alola"
## [907] "diglett-alola" "dugtrio-alola"
## [909] "meowth-alola" "persian-alola"
## [911] "geodude-alola" "graveler-alola"
## [913] "golem-alola" "grimer-alola"
## [915] "muk-alola" "exeggutor-alola"
## [917] "marowak-alola" "greninja-battle-bond"
## [919] "greninja-ash" "zygarde-10"
## [921] "zygarde-50" "zygarde-complete"
## [923] "gumshoos-totem" "vikavolt-totem"
## [925] "oricorio-pom-pom" "oricorio-pau"
## [927] "oricorio-sensu" "lycanroc-midnight"
## [929] "wishiwashi-school" "lurantis-totem"
## [931] "salazzle-totem" "minior-orange-meteor"
## [933] "minior-yellow-meteor" "minior-green-meteor"
## [935] "minior-blue-meteor" "minior-indigo-meteor"
## [937] "minior-violet-meteor" "minior-red"
## [939] "minior-orange" "minior-yellow"
## [941] "minior-green" "minior-blue"
## [943] "minior-indigo" "minior-violet"
## [945] "mimikyu-busted" "mimikyu-totem-disguised"
## [947] "mimikyu-totem-busted" "kommo-o-totem"
## [949] "magearna-original"
str_detect(data$type_1, "fire")
## [1] FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [13] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [25] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [37] TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [49] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE
## [61] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [73] FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [85] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [97] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [109] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [121] FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE
## [133] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [145] FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE
## [157] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [169] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [181] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [193] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [205] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [217] FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [229] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [241] FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE
## [253] FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [265] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [277] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [289] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [301] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [313] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE
## [325] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [337] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [349] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [361] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [373] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [385] FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE
## [397] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [409] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [421] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [433] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [445] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [457] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [469] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [481] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [493] FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE
## [505] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE
## [517] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [529] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [541] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [553] FALSE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [565] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [577] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [589] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [601] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [613] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [625] FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
## [637] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [649] FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE
## [661] FALSE TRUE TRUE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE FALSE
## [673] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [685] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [697] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [709] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [721] TRUE FALSE FALSE FALSE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE
## [733] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE
## [745] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [757] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [769] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE
## [781] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [793] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [805] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE
## [817] FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [829] FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE FALSE FALSE FALSE
## [841] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
## [853] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [865] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [877] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [889] TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [901] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [913] FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [925] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [937] FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
## [949] FALSE
sum(str_detect(data$type_1,"fire"))
## [1] 59
data %>%
summarise(num_fire =sum(str_detect(data$type_1, "fire")) )
## # A tibble: 1 × 1
## num_fire
## <int>
## 1 59
data %>%
mutate(col_Fire = str_extract(type_1, "fire")) %>%
select(id, pokemon, col_Fire) %>%
filter(!is.na(col_Fire))
## # A tibble: 59 × 3
## id pokemon col_Fire
## <dbl> <chr> <chr>
## 1 4 charmander fire
## 2 5 charmeleon fire
## 3 6 charizard fire
## 4 37 vulpix fire
## 5 38 ninetales fire
## 6 58 growlithe fire
## 7 59 arcanine fire
## 8 77 ponyta fire
## 9 78 rapidash fire
## 10 126 magmar fire
## # ℹ 49 more rows
data %>%
mutate(col_Dragon = str_replace(type_1, "fire", "dragon")) %>%
select(id, pokemon, col_Dragon) %>%
filter(!is.na(col_Dragon))
## # A tibble: 949 × 3
## id pokemon col_Dragon
## <dbl> <chr> <chr>
## 1 1 bulbasaur grass
## 2 2 ivysaur grass
## 3 3 venusaur grass
## 4 4 charmander dragon
## 5 5 charmeleon dragon
## 6 6 charizard dragon
## 7 7 squirtle water
## 8 8 wartortle water
## 9 9 blastoise water
## 10 10 caterpie bug
## # ℹ 939 more rows