In [7]:

    

import sqlite3
import importlib.util as iutil
import numpy as np
import pandas as pd

spec = iutil.spec_from_file_location("RaderChart", "./libs/PokePlot_Lib.py")
pokeplot = iutil.module_from_spec(spec)
spec.loader.exec_module(pokeplot)


    

In [8]:

    

TYPE_LIST =  pokeplot.TYPE_LIST
COLOR_LIST = pokeplot.COLOR_LIST
COLOR_MAP = pokeplot.COLOR_MAP


    

In [9]:

    

# Read sqlite query results into a pandas DataFrame
con = sqlite3.connect("./data/alola_db.db")
df = pd.read_sql_query("SELECT * from POKEDEX", con)
con.close()
columnLabels = []
for col in df.columns:
    columnLabels.append(str(col))


    

In [10]:

    

pokeplot.statSpread(df, 0, 'GENGAR', 'BLISSEY')


    

    
Out[10]:

In [11]:

    

pokeplot.statSpread(df, 1, 'MR. MIME', 'HO-OH')


    

    
Out[11]:

In [12]:

    

pokeplot.statSpread(df, 2, 'TAPU LELE','TAPU KOKO','TAPU BULU', 'TAPU FINI')


    

    
Out[12]:

In [ ]: