← back to Cslb Call List

scripts/enrich_links.py

18 lines

import csv, urllib.parse
IN="out/cslb_call_list_CA.csv"; OUT="out/cslb_call_list_CA.enriched.csv"
def q(s): return urllib.parse.quote_plus(s or "")
with open(IN,newline='',encoding='utf-8') as fh:
    r=csv.DictReader(fh); rows=list(r); cols=list(r.fieldnames)
for c in ["google_search","yelp_search","linkedin_search","maps_search"]:
    if c not in cols: cols.append(c)
for row in rows:
    name=row.get("business_name","").strip(); city=(row.get("city") or "").strip()
    base=f"{name} {city} CA"
    row["google_search"]=f"https://www.google.com/search?q={q(base)}"
    row["yelp_search"]=f"https://www.yelp.com/search?find_desc={q(name)}&find_loc={q(city+', CA')}"
    row["linkedin_search"]=f"https://www.linkedin.com/search/results/all/?keywords={q(name)}"
    row["maps_search"]=f"https://www.google.com/maps/search/{q(base)}"
with open(OUT,"w",newline='',encoding='utf-8') as fh:
    w=csv.DictWriter(fh,fieldnames=cols); w.writeheader(); w.writerows(rows)
print(f"enriched {len(rows)} rows -> {OUT}")