Closed zekrom-vale closed 3 months ago
Looks like it's an issue when it has alternative methods:
Eeveelution | Eevee | NA | Water Stone | Vaporeon | NA | First | Eevee | NA | NA | NA | NA | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- Eeveelution | Eevee | NA | Thunder Stone | Jolteon | NA | First | Eevee | NA | NA | NA | NA | Eeveelution | Eevee | NA | Fire Stone | Flareon | NA | First | Eevee | NA | NA | NA | NA | Eeveelution | Eevee | NA | Friendship (day) | Level up with Sun ShardXD | Espeon | NA | First | Eevee | NA | NA | NA | NA Eeveelution | Eevee | NA | Friendship (night) | Level up with Moon ShardXD | Umbreon | NA | First | Eevee | NA | NA | NA | NA Eeveelution | Eevee | NA | Level up near Moss Rock | Leaf StoneVIII+ | Leafeon | NA | First | Eevee | NA | NA | NA | NA Eeveelution | Eevee | NA | Level up near Ice Rock | Ice StoneSwShLASV | Glaceon | NA | First | Eevee | NA | NA | NA | NA Eeveelution | Eevee | NA | Level up with a Fairy-type moveand either two hearts of affectionor high friendshipSwShLASV | Sylveon | NA | First | Eevee | NA | NA | NA | NA | Porygon | Porygon | NA | Trade holding Upgrade | Porygon2 | NA | First | Porygon | NA | NA | NA | NA | Omanyte | Omanyte | NA | Level 40 | Omastar | NA | First | Omanyte | NA | NA | NA | NA |The issue is that ;
are naked and unquoted in the csv and LibreOffice interprets ;
as the separator. Quoting it can fix the issue, perhaps there is an option in readr
.
Disabling ;
as a separator fixes the issue. However, it should not be used in the first place.
Describe the Data Issue Data in the CSV does not match up to the columns
Dataset Name PokemonFamily.csv perhaps more
Identify the Incorrect Data It looks like method is shifting all values to the right in the CSV file. Something is wrong either in the CSV encoding or R. I think it's an issue with readr
Expected Correct Data Please provide a clear and concise description of what you expected the correct data to be.
Screenshots
family | base | form | method | evo | evoForm | transition | first | firstForm | regional | evoRegional | firstRegional | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- Bulbasaur | Bulbasaur | NA | Level 16 | Ivysaur | NA | First | Bulbasaur | NA | NA | NA | NA | Charmander | Charmander | NA | Level 16 | Charmeleon | NA | First | Charmander | NA | NA | NA | NA | Squirtle | Squirtle | NA | Level 16 | Wartortle | NA | First | Squirtle | NA | NA | NA | NA | Caterpie | Caterpie | NA | Level 7 | Metapod | NA | First | Caterpie | NA | NA | NA | NA | Weedle | Weedle | NA | Level 7 | Kakuna | NA | First | Weedle | NA | NA | NA | NA | Pidgey | Pidgey | NA | Level 18 | Pidgeotto | NA | First | Pidgey | NA | NA | NA | NA | Rattata | Rattata | NA | Level 20 | Raticate | Kantonian | First | Rattata | NA | Kantonian | NA | Kantonian | Rattata | Rattata | NA | Level 20 (night) | Raticate | Alolan | First | Rattata | NA | Alolan | NA | Alolan | Spearow | Spearow | NA | Level 20 | Fearow | NA | First | Spearow | NA | NA | NA | NA | Ekans | Ekans | NA | Level 22 | Arbok | NA | First | Ekans | NA | NA | NA | NA | Pikachu | Pichu | NA | Friendship | Pikachu | NA | First | Pichu | NA | NA | NA | NA | Pikachu | Pichu | NA | Friendship | Pikachu | NA | First | Pichu | NA | NA | NA | NA | Sandshrew | Sandshrew | NA | Level 22 | Sandslash | Kantonian | First | Sandshrew | NA | Kantonian | NA | Kantonian | Sandshrew | Sandshrew | NA | Ice Stone | Sandslash | Alolan | First | Sandshrew | NA | Alolan | NA | Alolan | Nidoran | Nidoran♀ | NA | Level 16 | Nidorina | NA | First | Nidoran♀ | NA | NA | NA | NA | Nidoran | Nidoran♂ | NA | Level 16 | Nidorino | NA | First | Nidoran♂ | NA | NA | NA | NA | Clefairy | Cleffa | NA | Friendship | Clefairy | NA | First | Cleffa | NA | NA | NA | NA | Vulpix | Vulpix | NA | Fire Stone | Ninetales | Kantonian | First | Vulpix | NA | Kantonian | NA | Kantonian | Vulpix | Vulpix | NA | Ice Stone | Ninetales | Alolan | First | Vulpix | NA | Alolan | NA | Alolan | Jigglypuff | Igglybuff | NA | Friendship | Jigglypuff | NA | First | Igglybuff | NA | NA | NA | NA | Zubat | Zubat | NA | Level 22 | Golbat | NA | First | Zubat | NA | NA | NA | NA | Oddish | Oddish | NA | Level 21 | Gloom | NA | First | Oddish | NA | NA | NA | NA | Oddish | Oddish | NA | Level 21 | Gloom | NA | First | Oddish | NA | NA | NA | NA | Paras | Paras | NA | Level 24 | Parasect | NA | First | Paras | NA | NA | NA | NA | Venonat | Venonat | NA | Level 31 | Venomoth | NA | First | Venonat | NA | NA | NA | NA | Diglett | Diglett | NA | Level 26 | Dugtrio | Kantonian | First | Diglett | NA | Kantonian | NA | Kantonian | Diglett | Diglett | NA | Level 26 | Dugtrio | Alolan | First | Diglett | NA | Alolan | NA | Alolan | Meowth | Meowth | NA | Level 28 | Persian | Kantonian | First | Meowth | NA | Kantonian | NA | Kantonian | Meowth | Meowth | NA | Friendship | Level 28PE | Persian | Alolan | First | Meowth | NA | Alolan | NA | AlolanEnvironment (please complete the following information):
Additional Context Add any other context about the data issue here.