Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Evolution Items without descriptions #371

Open
ebailin opened this issue Oct 21, 2022 · 0 comments
Open

Evolution Items without descriptions #371

ebailin opened this issue Oct 21, 2022 · 0 comments

Comments

@ebailin
Copy link

ebailin commented Oct 21, 2022

Hello!

The following evolution trigger items don't have a description, and are not connected to evolutionary chains:

['strawberry-sweet', 'love-sweet', 'berry-sweet', 'clover-sweet', 'flower-sweet', 'star-sweet', 'ribbon-sweet', 'sweet-apple', 'tart-apple', 'cracked-pot', 'chipped-pot']

I got these from first using the graphql console (I LOVE IT by the way!), then using pandas to do an outer merge. I tried to just search for the evolution trigger items that didn't have any effect text, but it kept coming up with nothing, so I had to be circuitous to make sure I wasn't doing something wrong.

Here's my code:

query evolution_items_full {
  pokemon_v2_item(where: {item_category_id: {_eq: 10}, pokemon_v2_itemeffecttexts: {effect: {_is_null: false}}}) {
    name
    id
  }
}

query all_evolution_items {
  pokemon_v2_item(where: {item_category_id: {_eq: 10}}) {
    name
    id
  }
}
import pandas as pd

all_items=query_graphql(all_evolution_items) #my function that calls requests on graphql and returns a nicely structured dataframe of ["name", "id"]

complete_items=query_graphql(evolution_items_full)

empty_effects=pd.merge(all_items, not_null, on=['name','id'], how="outer", indicator=True
                   ).query('_merge=="left_only"')

print(empty_effects["name"])

`
I've confirmed that the items do cause evolutions.

I'm happy to add these to the csv(s)/graphql, I just don't know which ones to edit (there are a lot of csvs!).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant