applicable-fee-ids

name	Applicable_Fee_IDs
description	Solve Applicable_Fee_IDs questions in the dabstep dataset. Use this skill whenever a question asks which fee IDs apply to a merchant, a specific account_type/aci combination, a specific day/month/year, or when reverse-looking up which merchants are affected by a given fee ID.

Applicable Fee IDs — Solution Guide

CRITICAL: Compute Once, Submit Immediately

The #1 failure mode: computing the correct answer and then entering a verification loop that exhausts all turns. Once you have the sorted list of applicable fee IDs, format and print it, then submit as the final answer. Do NOT spend additional turns verifying individual fees.

The #2 failure mode: abbreviating a long output list with "...". Always use Python to print the full comma-separated list — never abbreviate.

Dataset Overview

• fees.json: 1000 fee rules with filtering fields and formula fields
• merchant_data.json: 30 merchants with account_type, capture_delay (string: "1", "2", "7", "immediate", "manual"), acquirer (list), merchant_category_code
• payments.csv: Transaction-level data with merchant, year, day_of_year, card_scheme, is_credit, aci, issuing_country, acquirer_country, eur_amount, has_fraudulent_dispute
• manual.md: Domain definitions

Verified data facts:

• account_type in fees: always [] (empty list) or a list of strings — never null
• aci in fees: always [] (empty list) or a list of letters — never null
• ACI values in fees: A, B, C, D, E, F only — ACI='G' appears in payments but NOT in any fee rule's aci list (it can only match fees where aci: [])
• Card schemes in fees: GlobalCard, NexPay, SwiftCharge, TransactPlus
• 2023 is NOT a leap year (365 days)

Fee Rule Matching Logic

A fee rule applies when all specified fields match.

Null/Empty = "Applies to All"

null AND empty list [] both mean the rule applies to all values of that field.

def field_matches_list(rule_list, value):
    return not rule_list or value in rule_list

def field_matches_scalar(rule_val, value):
    return rule_val is None or rule_val == value

capture_delay Mapping

def map_capture_delay(raw):
    try:
        n = int(raw)
        return '<3' if n < 3 else ('3-5' if n <= 5 else '>5')
    except (ValueError, TypeError):
        return raw  # 'immediate' or 'manual' returned as-is

intracountry

Computed per transaction: issuing_country == acquirer_country
In fee rules: 1.0 = True (domestic), 0.0 = False (international), null = all.

Month Ranges (2023, non-leap year)

MONTH_RANGES = {
    1:(1,31), 2:(32,59), 3:(60,90), 4:(91,120),
    5:(121,151), 6:(152,181), 7:(182,212), 8:(213,243),
    9:(244,273), 10:(274,304), 11:(305,334), 12:(335,365)
}

monthly_volume Ranges

'<100k'   → monthly_vol_eur < 100_000
'100k-1m' → 100_000 ≤ vol < 1_000_000
'1m-5m'   → 1_000_000 ≤ vol < 5_000_000
'>5m'     → vol ≥ 5_000_000

monthly_fraud_level Ranges

'<7.2%'     → fraud_pct < 7.2
'7.2%-7.7%' → 7.2 ≤ pct < 7.7
'7.7%-8.3%' → 7.7 ≤ pct < 8.3
'>8.3%'     → pct ≥ 8.3

Fraud rate = sum(eur_amount where has_fraudulent_dispute==True) / sum(eur_amount) × 100 for the merchant in that natural calendar month.

Complete fee_applies Function

def matches_monthly_volume(rule_vol, monthly_vol):
    if rule_vol is None: return True
    if rule_vol == '<100k':   return monthly_vol < 100_000
    if rule_vol == '100k-1m': return 100_000 <= monthly_vol < 1_000_000
    if rule_vol == '1m-5m':   return 1_000_000 <= monthly_vol < 5_000_000
    return monthly_vol >= 5_000_000  # '>5m'

def matches_monthly_fraud(rule_fraud, fraud_pct):
    if rule_fraud is None: return True
    if rule_fraud == '<7.2%':     return fraud_pct < 7.2
    if rule_fraud == '7.2%-7.7%': return 7.2 <= fraud_pct < 7.7
    if rule_fraud == '7.7%-8.3%': return 7.7 <= fraud_pct < 8.3
    return fraud_pct >= 8.3  # '>8.3%'

def fee_applies():
      field_matches_scalar(fee[], card_scheme):  
      field_matches_list(fee[], account_type):  
      field_matches_scalar(fee[], capture_delay_mapped):  
      field_matches_list(fee[], mcc):  
      field_matches_scalar(fee[], is_credit):  
      field_matches_list(fee[], aci):  
     fee[]     (fee[]) != intracountry:  
      matches_monthly_volume(fee[], monthly_vol):  
      matches_monthly_fraud(fee[], monthly_fraud_pct):  
     

Task Types and Solutions

Type 1: Pure Attribute Query

"What fee IDs apply to account_type = X and aci = Y?"

No transaction data needed. Filter fees.json directly on only the specified attributes:

import json
with open('fees.json') as f: fees = json.load(f)

result = sorted([
    fee['ID'] for fee in fees
    if field_matches_list(fee['account_type'], 'F')
    and field_matches_list(fee['aci'], 'A')
])
# Print the FULL list — never abbreviate with "..."
print(', '.join(str(x) for x in result))

Submit immediately after printing. Do not verify individual fee details.

---

Type 2: Merchant + Specific Day

"For the Nth of the year 2023, what Fee IDs apply to Merchant X?"

import pandas as pd, json

with open('merchant_data.json') as f: merchants = json.load(f)
with open('fees.json') as f: fees = json.load(f)
payments = pd.read_csv('payments.csv')

# Merchant properties
merch = next(m for m in merchants if m['merchant'] == 'MerchantName')
account_type = merch['account_type']
mcc = merch['merchant_category_code']
capture_delay = map_capture_delay(merch['capture_delay'])

# Find the calendar month for the target day
target_day = 200
target_month = next(m for m, (s, e) in MONTH_RANGES.items() if s <= target_day <= e)
month_start, month_end = MONTH_RANGES[target_month]

# Filter merchant payments for 2023
merch_payments = payments[(payments['merchant'] == merch['merchant']) & (payments['year'] == 2023)]

# Monthly stats for the calendar month containing the target day
month_txns = merch_payments[merch_payments['day_of_year'].between(month_start, month_end)]
monthly_vol = month_txns['eur_amount'].sum()
fraud_vol = month_txns[month_txns['has_fraudulent_dispute'] == True]['eur_amount'].sum()
monthly_fraud_pct = (fraud_vol / monthly_vol * 100) if monthly_vol > 0  


day_txns = merch_payments[merch_payments[] == target_day].copy()
day_txns[] = day_txns[] == day_txns[]
unique_profiles = day_txns[[, , , ]].drop_duplicates()


applicable_ids = ()
 _, row  unique_profiles.iterrows():
     fee  fees:
         fee_applies(fee, row[], row[], row[],
                       row[], account_type, capture_delay, mcc,
                       monthly_vol, monthly_fraud_pct):
            applicable_ids.add(fee[])


(.join((x)  x  (applicable_ids)))

Key: Use actual unique (card_scheme, is_credit, aci, intracountry) combinations from real transactions — NOT Cartesian products.

---

Type 3a: Merchant + Full Year

"What were the applicable Fee IDs for Merchant X in 2023?"

Process each calendar month separately, collect union of applicable fees:

# (Load data and merchant properties same as Type 2)
all_applicable = set()
for month_num, (m_start, m_end) in MONTH_RANGES.items():
    month_txns = merch_payments[merch_payments['day_of_year'].between(m_start, m_end)]
    if len(month_txns) == 0:
        continue
    monthly_vol = month_txns['eur_amount'].sum()
    fraud_vol = month_txns[month_txns['has_fraudulent_dispute'] == True]['eur_amount'].sum()
    monthly_fraud_pct = (fraud_vol / monthly_vol * 100) if monthly_vol > 0 else 0.0

    month_txns = month_txns.copy()
    month_txns['intracountry'] = month_txns['issuing_country'] == month_txns['acquirer_country']
    unique_profiles = month_txns[['card_scheme', 'is_credit', 'aci', 'intracountry']].drop_duplicates()

    for _, row in unique_profiles.iterrows():
        for fee in fees:
            if fee_applies(fee, row['card_scheme'], row['is_credit'], row['aci'],
                           row['intracountry'], account_type, capture_delay, mcc,
                           monthly_vol, monthly_fraud_pct):
                all_applicable.add(fee['ID'])

print(', '.join(str(x) for x in sorted(all_applicable)))

---

Type 3b: Merchant + Specific Month

"What were the applicable Fee IDs for Merchant X in October 2023?"

Same as Type 3a but for one month only:

month_map = {'January':1,'February':2,'March':3,'April':4,'May':5,'June':6,
             'July':7,'August':8,'September':9,'October':10,'November':11,'December':12}
target_month = month_map['October']
m_start, m_end = MONTH_RANGES[target_month]
# Then run the single-month version of Type 3a

---

Type 4: Reverse Lookup

"In 2023, which merchants were affected by Fee with ID 709?"

target_fee = next(f for f in fees if f['ID'] == target_fee_id)

filtered = payments.copy()
filtered['intracountry'] = filtered['issuing_country'] == filtered['acquirer_country']

if target_fee['card_scheme'] is not None:
    filtered = filtered[filtered['card_scheme'] == target_fee['card_scheme']]
if target_fee['is_credit'] is not None:
    filtered = filtered[filtered['is_credit'] == target_fee['is_credit']]
if target_fee['aci']:
    filtered = filtered[filtered['aci'].isin(target_fee['aci'])]
if target_fee['intracountry'] is not None:
    filtered = filtered[filtered['intracountry'] == bool(target_fee['intracountry'])]

merch_lookup = {m['merchant']: m for m in merchants}
affected = set()
for merch_name in filtered['merchant'].unique():
    merch = merch_lookup.get(merch_name)
    if not merch: continue
    if not field_matches_list(target_fee['account_type'], merch['account_type']): 
      field_matches_list(target_fee[], merch[]): 
      field_matches_scalar(target_fee[], map_capture_delay(merch[])): 
    affected.add(merch_name)

(.join((affected)))

Output Format

• Return a sorted, comma-separated list of integer fee IDs: 3, 4, 5, 7, 8, 9, 11
• If no fees match, return an empty string (not "Not Applicable")
• Never abbreviate the output — always print the FULL list using Python

Common Mistakes to Avoid

1. Verification loops — compute answer, print it, submit; never spend extra turns verifying individual fee matches
2. Abbreviating long lists — never put "..." in the answer; always print(', '.join(str(x) for x in sorted(applicable_ids)))
3. Cartesian products instead of actual transaction profiles — over-counts fees
4. Treating [] as "no match" — empty lists mean "applies to all", same as null
5. Wrong capture_delay mapping — merchant "1" or "2" → <3; "7" → >5
6. Wrong intracountry comparison — fee stores 1.0/0.0, convert with bool() before comparing
7. Yearly totals for monthly stats — always compute per natural calendar month
8. Wrong monthly stats scope — for a specific day query, monthly stats come from the full calendar month containing that day (e.g., day 200 = July → use all July transactions for monthly stats)
9. ACI='G' transactions — G is in payments but not in fee rule aci lists; these transactions only match fees with aci: []