2022: Week 8 - Pokémon Evolution Stats

Challenge by: Will Sutton

In this week's Preppin' Data we're collaborating with #GamesNightViz on their latest challenge Power Ups. We'll be diving into the Pokédex to explore how Pokémon combat stats change when they evolve.

Inputs

  1. pkmn_stats 

  2. pkmn_evolutions 

Requirements

  • Import the data (excel file)
  • From pkmn_stats dataset remove the columns height, weight and evolves from
  • Pivot (wide to long) pkmn stats so that hp, attack, defense, special_attack, special_defense, and speed become a column called 'combat_factors'
  • Using the evolutions data look up the combat_factors for each Pokémon at each stage, making sure that the combat_factors match across the row, i.e. we should be able to see the hp for Bulbasaur, Ivysaur and Venusaur on one row
  • Remove any columns for 'pokedex_number' and 'gen_introduced' that were from joins at Stage 2 & 3
  • If a Pokémon doesn't evolve remove it from the dataset
  • Find the combat power values relating to the Pokémon's last evolution stage
  • Sum together each Pokémon's combat_factors
  • Find the percentage increase in combat power from the first & last evolution stage
  • Sort the dataset, ascending by percentage increase
    • If using Tableau Prep, consider introducing a field to manage this sort and then hide it
  • Output the data
  • Which Pokémon stats decrease from evolving?

Output

  • 8 fields (plus 1 hidden field if using Prep)
    • Stage_1
    • Stage_2
    • Stage_3
    • pokedex_number
    • gen_introduced
    • intial_combat_power
    • final_combat_power
    • combat_power_increase
  • 330 rows (331 including headers)

You can download the full output here

After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and #GamesNightViz and tagging @Datajedininja@JennyMartinDS14@TomProwse1 & @WJSutton12

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help! 

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text