from axion import Axion, utils, visualize

client = Axion(api_key="your_api_key")

issuers = ["Apple", "Microsoft", "Amazon", "Tesla", "ExxonMobil"]

def fetch_ratings(row):
    name    = row["name"]
    results = client.credit.search(name)
    ratings = client.credit.ratings(results[0]["id"]) if results else []
    return (name, ratings)

df_issuers  = utils.df([{"name": n} for n in issuers])
ratings_map = {}
utils.work(df_issuers, fetch_ratings, ratings_map)

flat = [
    {
        "issuer":  issuer,
        "agency":  r["agency"],
        "rating":  r["rating"],
        "outlook": r.get("outlook", "N/A"),
    }
    for issuer, ratings in ratings_map.items()
    for r in ratings
]

df_ratings = utils.df(flat)
visualize.bar(df_ratings, x="issuer", y="rating")