Skip to main content

HMDA mortgage lending disparity analyzer — denial rates, racial disparities, lending deserts, and lender benchmarking

Project description

hmda-analyzer 📊

HMDA mortgage lending disparity analyzer.

Compute denial rate disparities by race, identify lending deserts, benchmark lenders against peers, and generate fair lending analysis reports — using CFPB HMDA LAR data. Free public API, no authentication required.


Why hmda-analyzer?

HMDA data covers 10+ million mortgage applications per year with borrower demographics, denial rates, loan amounts, and census tract locations. It is the most powerful public dataset for analyzing mortgage lending disparities — but it requires significant engineering to use. hmda-analyzer makes it accessible in Python.


Installation

pip install hmda-analyzer

Both of these import styles work after installation:

from hmdaanalyzer import denial_rate_by_race   # canonical form
from hmda_analyzer import denial_rate_by_race   # pip-name convention alias

Quickstart

from hmdaanalyzer import (
    load_sample, denial_rate_by_race, disparity_ratio,
    lending_by_tract, lending_desert_score, lender_summary,
    generate_disparity_report,
)

# Load sample data (no API required)
df = load_sample(n=5000)

# Or load from CFPB API — streams and stops at limit rows
# df = load_from_api(year=2023, state="IL", limit=10_000)

# Or load multiple years at once (inclusive range) with provenance
# from hmdaanalyzer import load_range
# df = load_range(2021, 2023, state="IL", county="17031", limit=10_000)
# df["activity_year"] tags each row's year; filters apply to every year

# Denial rates by race
rates = denial_rate_by_race(df)
print(rates)

# Disparity ratios vs White applicants
disparities = disparity_ratio(df)
print(disparities)

# Geographic analysis — lending activity by census tract
tracts = lending_by_tract(df)
print(tracts.head())

# Lending desert identification — tracts with abnormally low application volume
deserts = lending_desert_score(df)
print(deserts.head())

# Lender analysis
summary = lender_summary(df, lei="LEI000001")

# Full disparity report
report = generate_disparity_report(df, title="Illinois Mortgage Market 2023")
print(report)

Multi-Year Loading (load_range)

load_range(start_year, end_year, ...) fetches HMDA LAR for every year in the inclusive range and returns one concatenated DataFrame with an activity_year provenance column:

from hmdaanalyzer import load_range

df = load_range(2021, 2023, state="IL", county="17031", limit=10_000)
df["activity_year"].value_counts()   # rows tagged by year
  • Filters apply to every year. state, lei, county, and limit are forwarded identically to each per-year fetch; limit is per year.
  • Fail-loud, no partial. If any year's fetch fails, load_range raises immediately with the failing year named (a CFPBAPIError keeps its HTTP status) and returns no partial frame — it never silently skips a year.
  • Schema guard. Each year's columns are validated against a canonical set; a missing or unexpected column raises SchemaValidationError naming the year, rather than silently NaN-filling or dropping fields.
  • Provenance checked. The native activity_year is asserted to match the requested year; a wrong-year payload raises ActivityYearMismatchError.
  • Empty years are fine. A valid year matching zero rows is not an error; its empty frame just contributes no rows.

The CFPB column schema is identical across 2018–2025 (2018 is the earliest year the API serves), so no columns are year-conditional.

⚠️ Scale. Multi-year national pulls are enormous — the same filters apply to every year, so a range with no state/county filter multiplies a full national LAR file by the number of years. Always filter multi-year loads. load_range streams each year to limit; it does not silently cap or block large pulls.


Analyses Supported

  • Denial rate by race and ethnicity
  • Disparity ratios vs reference group (default: White applicants)
  • Denial rate by income band
  • Denial reasons by race
  • Lending activity by census tract, county, and state
  • Lending desert identification (low application volume tracts)
  • Lender vs market comparison
  • Top lenders by origination volume

Error Handling

If you pass a DataFrame that is missing a column an analysis requires, the function raises MissingColumnError (importable from hmdaanalyzer or hmda_analyzer) instead of silently returning an empty result. In a fair-lending context a silent empty result can read as "no disparity," so a schema problem fails loudly:

from hmdaanalyzer import MissingColumnError, lending_by_state

try:
    lending_by_state(df)            # df has 'state' but not 'state_code'
except MissingColumnError as e:
    print(e)                        # names the function and the missing column

MissingColumnError subclasses ValueError, so existing except ValueError handlers keep working. This applies to the analysis functions and to filtering arguments: passing lei=... or state=... when that column is absent raises rather than silently computing whole-market results. A well-formed query that simply matches no rows is not an error — e.g. lender_summary(df, lei=...) with a valid schema but an unknown LEI still returns an empty {}, and generate_disparity_report(df, lei=...) returns a clean no-records report.

Breaking change in 0.3.0: functions that previously returned an empty result on a missing column now raise MissingColumnError. See the CHANGELOG for the full list.


Disparity Ratio Thresholds

Based on CFPB fair lending examination standards:

  • = 2.0x — HIGH disparity (triggers regulatory scrutiny)

  • = 1.5x — MODERATE disparity

  • < 1.5x — LOW disparity
  • < 1.0x — FAVORABLE (group has lower denial rate than reference)

Data Sources

CFPB HMDA Data Browser API — free, no API key required. 2024 data covers 4,908 institutions and millions of loan applications.

https://ffiec.cfpb.gov/data-browser/

Cloud environments (Colab/hosted notebooks)

From cloud/datacenter environments such as Google Colab, an API request can hit an HTTP 403 "Access Denied" from the CFPB edge (Akamai) even when the query is valid — it's an access/network block, not a problem with your year/state/county values. hmda-analyzer sends an identifying User-Agent and Accept/Accept-Language headers that clear this in the cases we reproduced, and a 403 now raises a typed CFPBAPIError explaining the situation. If you still hit a block, run locally or download the CSV directly from the HMDA Data Browser and load it with load_from_file(...).


Running Tests

PYTHONPATH=. pytest tests/ -v

86 tests across all modules (offline/mocked; no live API calls).


Who This Is For

  • Fair lending analysts and compliance teams at banks and CDFIs
  • Community reinvestment researchers studying mortgage disparities
  • Journalists covering housing discrimination and redlining
  • Regulators and examiners analyzing lender performance
  • Academics studying racial wealth gaps and homeownership barriers

License

MIT 2026 Jaypatel1511

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

hmda_analyzer-0.4.0.tar.gz (29.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

hmda_analyzer-0.4.0-py3-none-any.whl (24.7 kB view details)

Uploaded Python 3

File details

Details for the file hmda_analyzer-0.4.0.tar.gz.

File metadata

  • Download URL: hmda_analyzer-0.4.0.tar.gz
  • Upload date:
  • Size: 29.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.13

File hashes

Hashes for hmda_analyzer-0.4.0.tar.gz
Algorithm Hash digest
SHA256 8f73246d85400c3a2c790e994afc37fadc3581ca840bdcf5d7f1ad21dfdcf5b6
MD5 da2d70ff697d89b873ff1892bd28369a
BLAKE2b-256 36c0728b814ca64b2b32caa02bb33532964aa6195b988f7f2e9c0137e2e78dda

See more details on using hashes here.

Provenance

The following attestation bundles were made for hmda_analyzer-0.4.0.tar.gz:

Publisher: release.yml on Jaypatel1511/hmda-analyzer

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file hmda_analyzer-0.4.0-py3-none-any.whl.

File metadata

  • Download URL: hmda_analyzer-0.4.0-py3-none-any.whl
  • Upload date:
  • Size: 24.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.13

File hashes

Hashes for hmda_analyzer-0.4.0-py3-none-any.whl
Algorithm Hash digest
SHA256 c0f81d9dd1ee8f6dcc3c809a236f5830a69f745ba75ab4ad4fdc6537b611d6aa
MD5 e306784127476a26425a45d384d6dbca
BLAKE2b-256 8eefc077f060c9c8f6539f34fdf9b787f48b0549a94145a919bcaa38d1323bb6

See more details on using hashes here.

Provenance

The following attestation bundles were made for hmda_analyzer-0.4.0-py3-none-any.whl:

Publisher: release.yml on Jaypatel1511/hmda-analyzer

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page