search

zekrom-vale / ZekDex

ZekDex: A comprehensive R package and CSV files for Pokémon data. Features National Dex Info, Legendary/Mythical Groupings, Base Stats, Evolution Info, and Random Pokémon Generation. Data sourced from Bulbapedia, covering generations I-IX. Ideal for data scientists, Pokémon enthusiasts, and researchers.
Other
1 stars 0 forks source link

Data issue: Inconsistent Data Format in `stats` Dataset #12

Closed zekrom-vale closed 5 months ago

zekrom-vale commented 5 months ago

Describe the Data Issue The stats dataset in the ZekDex package (version 0.1.2) currently has an inconsistent format that makes it difficult to join with other datasets. The form column does not match the form regional format that is expected.

Dataset Name stats form column

Identify the Incorrect Data The form column contains values that should be split into form and regional columns. For example, Alolan Sandshrew is listed under form, but Alolan should be in a separate regional column.

ndex | name | form | MegaOrPrimal | Mega | HP | Attack | Defense | Speed | Special | Total | Average | Gen | SpAttack | SpDefense -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- 674 | Pancham | NA | NA | NA | 67 | 82 | 62 | 43 | NA | 348 | 58 | VI | 46 | 48 675 | Pangoro | NA | NA | NA | 95 | 124 | 78 | 58 | NA | 495 | 82.5 | VI | 69 | 71 676 | Furfrou | NA | NA | NA | 75 | 80 | 60 | 102 | NA | 472 | 78.67 | VI | 65 | 90 677 | Espurr | NA | NA | NA | 62 | 48 | 54 | 68 | NA | 355 | 59.17 | VI | 63 | 60 678 | Meowstic | NA | NA | NA | 74 | 48 | 76 | 104 | NA | 466 | 77.67 | VI | 83 | 81 679 | Honedge | NA | NA | NA | 45 | 80 | 100 | 28 | NA | 325 | 54.17 | VI | 35 | 37 680 | Doublade | NA | NA | NA | 59 | 110 | 150 | 35 | NA | 448 | 74.67 | VI | 45 | 49 681 | Aegislash | Shield Forme | NA | NA | 60 | 50 | 150 | 60 | NA | 520 | 86.67 | VI | 50 | 150 681 | Aegislash | Blade Forme | NA | NA | 60 | 150 | 50 | 60 | NA | 520 | 86.67 | VI | 150 | 50 682 | Spritzee | NA | NA | NA | 78 | 52 | 60 | 23 | NA | 341 | 56.83 | VI | 63 | 65 683 | Aromatisse | NA | NA | NA | 101 | 72 | 72 | 29 | NA | 462 | 77 | VI | 99 | 89 684 | Swirlix | NA | NA | NA | 62 | 48 | 66 | 49 | NA | 341 | 56.83 | VI | 59 | 57 685 | Slurpuff | NA | NA | NA | 82 | 80 | 86 | 72 | NA | 480 | 80 | VI | 85 | 75 686 | Inkay | NA | NA | NA | 53 | 54 | 53 | 45 | NA | 288 | 48 | VI | 37 | 46 687 | Malamar | NA | NA | NA | 86 | 92 | 88 | 73 | NA | 482 | 80.33 | VI | 68 | 75 688 | Binacle | NA | NA | NA | 42 | 52 | 67 | 50 | NA | 306 | 51 | VI | 39 | 56 689 | Barbaracle | NA | NA | NA | 72 | 105 | 115 | 68 | NA | 500 | 83.33 | VI | 54 | 86 690 | Skrelp | NA | NA | NA | 50 | 60 | 60 | 30 | NA | 320 | 53.33 | VI | 60 | 60 691 | Dragalge | NA | NA | NA | 65 | 75 | 90 | 44 | NA | 494 | 82.33 | VI | 97 | 123 692 | Clauncher | NA | NA | NA | 50 | 53 | 62 | 44 | NA | 330 | 55 | VI | 58 | 63 693 | Clawitzer | NA | NA | NA | 71 | 73 | 88 | 59 | NA | 500 | 83.33 | VI | 120 | 89 694 | Helioptile | NA | NA | NA | 44 | 38 | 33 | 70 | NA | 289 | 48.17 | VI | 61 | 43 695 | Heliolisk | NA | NA | NA | 62 | 55 | 52 | 109 | NA | 481 | 80.17 | VI | 109 | 94 696 | Tyrunt | NA | NA | NA | 58 | 89 | 77 | 48 | NA | 362 | 60.33 | VI | 45 | 45 697 | Tyrantrum | NA | NA | NA | 82 | 121 | 119 | 71 | NA | 521 | 86.83 | VI | 69 | 59 698 | Amaura | NA | NA | NA | 77 | 59 | 50 | 46 | NA | 362 | 60.33 | VI | 67 | 63 699 | Aurorus | NA | NA | NA | 123 | 77 | 72 | 58 | NA | 521 | 86.83 | VI | 99 | 92 700 | Sylveon | NA | NA | NA | 95 | 65 | 65 | 60 | NA | 525 | 87.5 | VI | 110 | 130 701 | Hawlucha | NA | NA | NA | 78 | 92 | 75 | 118 | NA | 500 | 83.33 | VI | 74 | 63 702 | Dedenne | NA | NA | NA | 67 | 58 | 57 | 101 | NA | 431 | 71.83 | VI | 81 | 67 703 | Carbink | NA | NA | NA | 50 | 50 | 150 | 50 | NA | 500 | 83.33 | VI | 50 | 150 704 | Goomy | NA | NA | NA | 45 | 50 | 35 | 40 | NA | 300 | 50 | VI | 55 | 75 705 | Sliggoo | NA | NA | NA | 68 | 75 | 53 | 60 | NA | 452 | 75.33 | VI | 83 | 113 706 | Goodra | NA | NA | NA | 90 | 100 | 70 | 80 | NA | 600 | 100 | VI | 110 | 150 707 | Klefki | NA | NA | NA | 57 | 80 | 91 | 75 | NA | 470 | 78.33 | VI | 80 | 87 708 | Phantump | NA | NA | NA | 43 | 70 | 48 | 38 | NA | 309 | 51.5 | VI | 50 | 60 709 | Trevenant | NA | NA | NA | 85 | 110 | 76 | 56 | NA | 474 | 79 | VI | 65 | 82 710 | Pumpkaboo | Small Size | NA | NA | 44 | 66 | 70 | 56 | NA | 335 | 55.83 | VI | 44 | 55 710 | Pumpkaboo | Average Size | NA | NA | 49 | 66 | 70 | 51 | NA | 335 | 55.83 | VI | 44 | 55 710 | Pumpkaboo | Large Size | NA | NA | 54 | 66 | 70 | 46 | NA | 335 | 55.83 | VI | 44 | 55 710 | Pumpkaboo | Super Size | NA | NA | 59 | 66 | 70 | 41 | NA | 335 | 55.83 | VI | 44 | 55 711 | Gourgeist | Small Size | NA | NA | 55 | 85 | 122 | 99 | NA | 494 | 82.33 | VI | 58 | 75 711 | Gourgeist | Average Size | NA | NA | 65 | 90 | 122 | 84 | NA | 494 | 82.33 | VI | 58 | 75 711 | Gourgeist | Large Size | NA | NA | 75 | 95 | 122 | 69 | NA | 494 | 82.33 | VI | 58 | 75 711 | Gourgeist | Super Size | NA | NA | 85 | 100 | 122 | 54 | NA | 494 | 82.33 | VI | 58 | 75 712 | Bergmite | NA | NA | NA | 55 | 69 | 85 | 28 | NA | 304 | 50.67 | VI | 32 | 35 713 | Avalugg | NA | NA | NA | 95 | 117 | 184 | 28 | NA | 514 | 85.67 | VI | 44 | 46 714 | Noibat | NA | NA | NA | 40 | 30 | 35 | 55 | NA | 245 | 40.83 | VI | 45 | 40 715 | Noivern | NA | NA | NA | 85 | 70 | 80 | 123 | NA | 535 | 89.17 | VI | 97 | 80 716 | Xerneas | NA | NA | NA | 126 | 131 | 95 | 99 | NA | 680 | 113.33 | VI | 131 | 98 717 | Yveltal | NA | NA | NA | 126 | 131 | 95 | 99 | NA | 680 | 113.33 | VI | 131 | 98 718 | Zygarde | NA | NA | NA | 108 | 100 | 121 | 95 | NA | 600 | 100 | VI | 81 | 95 719 | Diancie | NA | NA | NA | 50 | 100 | 150 | 50 | NA | 600 | 100 | VI | 100 | 150 719 | Diancie | NA | Mega | Mega Diancie | 50 | 160 | 110 | 110 | NA | 700 | 116.67 | VI | 160 | 110 720 | Hoopa | Hoopa Confined | NA | NA | 80 | 110 | 60 | 70 | NA | 600 | 100 | VI | 150 | 130 720 | Hoopa | Hoopa Unbound | NA | NA | 80 | 160 | 60 | 80 | NA | 680 | 113.33 | VI | 170 | 130 721 | Volcanion | NA | NA | NA | 80 | 110 | 120 | 70 | NA | 600 | 100 | VI | 130 | 90 1 | Bulbasaur | NA | NA | NA | 45 | 49 | 49 | 45 | NA | 318 | 53 | VII | 65 | 65 2 | Ivysaur | NA | NA | NA | 60 | 62 | 63 | 60 | NA | 405 | 67.5 | VII | 80 | 80 3 | Venusaur | NA | NA | NA | 80 | 82 | 83 | 80 | NA | 525 | 87.5 | VII | 100 | 100 3 | Venusaur | NA | Mega | Mega Venusaur | 80 | 100 | 123 | 80 | NA | 625 | 104.17 | VII | 122 | 120 4 | Charmander | NA | NA | NA | 39 | 52 | 43 | 65 | NA | 309 | 51.5 | VII | 60 | 50 5 | Charmeleon | NA | NA | NA | 58 | 64 | 58 | 80 | NA | 405 | 67.5 | VII | 80 | 65 6 | Charizard | NA | NA | NA | 78 | 84 | 78 | 100 | NA | 534 | 89 | VII | 109 | 85 6 | Charizard | NA | Mega | Mega Charizard X | 78 | 130 | 111 | 100 | NA | 634 | 105.67 | VII | 130 | 85 6 | Charizard | NA | Mega | Mega Charizard Y | 78 | 104 | 78 | 100 | NA | 634 | 105.67 | VII | 159 | 115 7 | Squirtle | NA | NA | NA | 44 | 48 | 65 | 43 | NA | 314 | 52.33 | VII | 50 | 64 8 | Wartortle | NA | NA | NA | 59 | 63 | 80 | 58 | NA | 405 | 67.5 | VII | 65 | 80 9 | Blastoise | NA | NA | NA | 79 | 83 | 100 | 78 | NA | 530 | 88.33 | VII | 85 | 105 9 | Blastoise | NA | Mega | Mega Blastoise | 79 | 103 | 120 | 78 | NA | 630 | 105 | VII | 135 | 115 10 | Caterpie | NA | NA | NA | 45 | 30 | 35 | 45 | NA | 195 | 32.5 | VII | 20 | 20 11 | Metapod | NA | NA | NA | 50 | 20 | 55 | 30 | NA | 205 | 34.17 | VII | 25 | 25 12 | Butterfree | NA | NA | NA | 60 | 45 | 50 | 70 | NA | 395 | 65.83 | VII | 90 | 80 13 | Weedle | NA | NA | NA | 40 | 35 | 30 | 50 | NA | 195 | 32.5 | VII | 20 | 20 14 | Kakuna | NA | NA | NA | 45 | 25 | 50 | 35 | NA | 205 | 34.17 | VII | 25 | 25 15 | Beedrill | NA | NA | NA | 65 | 90 | 40 | 75 | NA | 395 | 65.83 | VII | 45 | 80 15 | Beedrill | NA | Mega | Mega Beedrill | 65 | 150 | 40 | 145 | NA | 495 | 82.5 | VII | 15 | 80 16 | Pidgey | NA | NA | NA | 40 | 45 | 40 | 56 | NA | 251 | 41.83 | VII | 35 | 35 17 | Pidgeotto | NA | NA | NA | 63 | 60 | 55 | 71 | NA | 349 | 58.17 | VII | 50 | 50 18 | Pidgeot | NA | NA | NA | 83 | 80 | 75 | 101 | NA | 479 | 79.83 | VII | 70 | 70 18 | Pidgeot | NA | Mega | Mega Pidgeot | 83 | 80 | 80 | 121 | NA | 579 | 96.5 | VII | 135 | 80 19 | Rattata | NA | NA | NA | 30 | 56 | 35 | 72 | NA | 253 | 42.17 | VII | 25 | 35 19 | Rattata | Alolan Rattata | NA | NA | 30 | 56 | 35 | 72 | NA | 253 | 42.17 | VII | 25 | 35 20 | Raticate | NA | NA | NA | 55 | 81 | 60 | 97 | NA | 413 | 68.83 | VII | 50 | 70 20 | Raticate | Alolan Raticate | NA | NA | 75 | 71 | 70 | 77 | NA | 413 | 68.83 | VII | 40 | 80 21 | Spearow | NA | NA | NA | 40 | 60 | 30 | 70 | NA | 262 | 43.67 | VII | 31 | 31 22 | Fearow | NA | NA | NA | 65 | 90 | 65 | 100 | NA | 442 | 73.67 | VII | 61 | 61 23 | Ekans | NA | NA | NA | 35 | 60 | 44 | 55 | NA | 288 | 48 | VII | 40 | 54 24 | Arbok | NA | NA | NA | 60 | 95 | 69 | 80 | NA | 448 | 74.67 | VII | 65 | 79 25 | Pikachu | NA | NA | NA | 35 | 55 | 40 | 90 | NA | 320 | 53.33 | VII | 50 | 50 25 | Pikachu | Partner Pikachu | NA | NA | 45 | 80 | 50 | 120 | NA | 430 | 71.67 | VII | 75 | 60 26 | Raichu | NA | NA | NA | 60 | 90 | 55 | 110 | NA | 485 | 80.83 | VII | 90 | 80 26 | Raichu | Alolan Raichu | NA | NA | 60 | 85 | 50 | 110 | NA | 485 | 80.83 | VII | 95 | 85 27 | Sandshrew | NA | NA | NA | 50 | 75 | 85 | 40 | NA | 300 | 50 | VII | 20 | 30 27 | Sandshrew | Alolan Sandshrew | NA | NA | 50 | 75 | 90 | 40 | NA | 300 | 50 | VII | 10 | 35 28 | Sandslash | NA | NA | NA | 75 | 100 | 110 | 65 | NA | 450 | 75 | VII | 45 | 55 28 | Sandslash | Alolan Sandslash | NA | NA | 75 | 100 | 120 | 65 | NA | 450 | 75 | VII | 25 | 65 29 | Nidoran♀ | NA | NA | NA | 55 | 47 | 52 | 41 | NA | 275 | 45.83 | VII | 40 | 40 30 | Nidorina | NA | NA | NA | 70 | 62 | 67 | 56 | NA | 365 | 60.83 | VII | 55 | 55 31 | Nidoqueen | NA | NA | NA | 90 | 92 | 87 | 76 | NA | 505 | 84.17 | VII | 75 | 85 32 | Nidoran♂ | NA | NA | NA | 46 | 57 | 40 | 50 | NA | 273 | 45.5 | VII | 40 | 40

Expected Correct Data The form column should only contain the form of the Pokémon (e.g., Shield Forme, Blade Forme, Small Size, etc.). Any regional information (e.g., Alolan) should be in a separate regional column.

Additional Information: Here are a few examples of the current data:

Alolan Sandshrew is listed under form, but Alolan should be in the regional column and form should be NA. Hoopa Confined is listed under form, but Confined should be in the form column and regional should be NA.

Environment (please complete the following information):