import csv,re from decimal import Decimal as D t=open('output/recommendation.md').read() print('words',len(re.findall(r"\S+",t))) specs={r['sku']:r for r in csv.DictReader(open('inputs/S1-manufacturer-specs.csv'))} offers={r['offer_id']:r for r in csv.DictReader(open('inputs/S2-store-offers.csv'))} raw=list(csv.reader(open('output/comparison.csv'))) print('col counts',set(len(r) for r in raw)) rows=list(csv.DictReader(open('output/comparison.csv'))) ok=True for r in rows: o=offers[r['offer_id']]; s=specs[o['sku']] sub=D(o['price_cad'])+D(o['shipping_cad']); tot=(sub*D('1.12')).quantize(D('0.01')) checks=[r['sku']==o['sku'],D(r['landed_total_cad'])==tot,D(r['taxable_subtotal_cad'])==sub, D(r['tax_12pct_cad'])==(sub*D('0.12')).quantize(D('0.01')), r['ram_gb']==s['ram_gb'],r['ssd_gb']==s['ssd_gb'],r['vram_gb']==s['vram_gb'],r['weight_kg']==s['weight_kg'],r['gpu']==s['gpu'], (r['within_2200_budget']=='Yes')==(tot<=2200)] print(r['offer_id'],tot,all(checks)); ok&=all(checks) if str(tot) not in t.replace(',',''): print(' total missing in md',tot) print('all match',ok) print('1964.28*1.12=',D('1964.28')*D('1.12'),' 1964.29*1.12=',D('1964.29')*D('1.12'))