Python / pandasFür Entwickler

import os
import httpx
import pandas as pd

TOKEN = os.environ["BRW_TOKEN"]
BASE = "https://api.bodenrichtwert.ai/api/bodenrichtwert"

def lookup(address: str) -> dict | None:
    r = httpx.get(BASE, params={"address": address}, headers={
        "Authorization": f"Bearer {TOKEN}",
    }, timeout=10.0)
    if r.status_code == 451:
        return {"restricted": True}
    r.raise_for_status()
    return r.json()

df = pd.read_excel("adressen.xlsx")
df["brw"] = df["adresse"].apply(lookup)
df.to_excel("adressen_mit_brw.xlsx")