Skip to main content

Upload your Chart of Accounts. Get a production-ready financial hierarchy and dbt models. Zero config.

Project description

DataBridge Core

Your finance team just spent 4 hours on VLOOKUP. This takes 5 seconds.

DataBridge Core is a Python toolkit for data reconciliation, profiling, and ingestion. Compare CSV files, find fuzzy matches, detect schema drift, and clean messy data -- from the command line or Python.

pip install databridge-core

5-Second Demo

# Profile a file
databridge profile sales.csv

# Compare two sources -- find orphans, conflicts, match rate
databridge compare source.csv target.csv --keys id

# Fuzzy match names across systems
databridge fuzzy erp_accounts.csv gl_accounts.csv --column name --threshold 80

Python API

from databridge_core import compare_hashes, profile_data, load_csv

# Profile your data
profile = profile_data("chart_of_accounts.csv")
print(f"{profile['rows']} rows, {profile['columns']} columns")
print(f"Potential keys: {profile['potential_key_columns']}")

# Compare two sources
result = compare_hashes("source.csv", "target.csv", key_columns="account_id")
stats = result["statistics"]
print(f"Match rate: {stats['match_rate_percent']}%")
print(f"Conflicts: {stats['conflicts']}, Orphans: {stats['total_orphans']}")

Commands

Command Description
databridge profile <file> Profile data: structure, quality, cardinality
databridge compare <a> <b> --keys <col> Hash comparison: orphans, conflicts, match rate
databridge fuzzy <a> <b> -c <col> Fuzzy match columns across two files
databridge diff <a> <b> Text diff between two files
databridge drift <old> <new> Detect schema drift between CSVs
databridge transform <file> -c <col> --op upper Clean a column (upper/lower/strip/trim/remove_special)
databridge merge <a> <b> --keys <col> Merge two CSVs on key columns
databridge find "*.csv" Find files matching a pattern
databridge parse <text> Parse tabular data from messy text

Optional Extras

pip install 'databridge-core[fuzzy]'   # Fuzzy matching (rapidfuzz)
pip install 'databridge-core[pdf]'     # PDF text extraction (pypdf)
pip install 'databridge-core[ocr]'     # OCR image extraction (pytesseract)
pip install 'databridge-core[sql]'     # Database queries (sqlalchemy)
pip install 'databridge-core[all]'     # Everything
pip install 'databridge-core[dev]'     # Development tools (pytest, ruff, build)

Built for Finance

DataBridge Core is the open-source foundation of DataBridge AI -- a full platform for financial hierarchy management, dbt model generation, and enterprise data reconciliation.

How it works: Upload your Chart of Accounts. Get a production-ready financial hierarchy and dbt models. Zero config.

License

MIT

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

databridge_core-0.1.0.tar.gz (24.3 kB view details)

Uploaded Source

Built Distribution

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

databridge_core-0.1.0-py3-none-any.whl (26.6 kB view details)

Uploaded Python 3

File details

Details for the file databridge_core-0.1.0.tar.gz.

File metadata

  • Download URL: databridge_core-0.1.0.tar.gz
  • Upload date:
  • Size: 24.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.12.3

File hashes

Hashes for databridge_core-0.1.0.tar.gz
Algorithm Hash digest
SHA256 14417d7aa4ad5f2f004b132e08c37d585b4ec9cbcbce16140a68625f5a032d33
MD5 a5188326b8aa1212643e7cf120f813e0
BLAKE2b-256 1669026642e882b138da8654000a969838b99a66493144fb3a12f8c0dc4599c8

See more details on using hashes here.

File details

Details for the file databridge_core-0.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for databridge_core-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 29b761352c2605a3f0e835443566e7565741e7d41f94f94d0dc60314229a801d
MD5 f95d733518fa80ccfc2a9f6ae419da8c
BLAKE2b-256 133251ecc6ae669adaad625df019f26d30c7cea5270059ca76962e86a1714a74

See more details on using hashes here.

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