Querexfuzz

Querexfuzz is a flexible query engine for pandas DataFrames. It lets you filter, sort, and search your data using a single unified query string that combines SQL-like where clauses, regular expressions, relative date ranges, and fuzzy matching — without leaving Python.

from querexfuzz import querexfuzz_from_df

querexfuzz_from_df(df)   # attaches .querex() to df

df.querex("top 10 where department == 'Engineering' @y-1 # python")

Key features:

• Unified syntax — combine where, regex, date, fuzzy, sort, and select in one string

• DataFrame native — attaches .querex() and .q() directly to your DataFrame instance

• Auto-configuration — querexfuzz_from_df inspects column types and wires up defaults

• Fast fuzzy search — powered by skimmatch; matcher built once and cached

• Configurable — via keyword arguments, YAML file, or both

---

Contents

• Getting Started
  • Installation
  • Quickstart
  • Explicit configuration
  • From a YAML file
  • Multiple DataFrames
  • Next steps
• Query Syntax
  • Flags: verbose and recent
  • top N / bottom N
  • select
  • Regex: ! and ~
  • where
  • order by / sort by
  • @ Date range
  • # Fuzzy search
  • Combining clauses
• API Reference
  • Public API
  • Querexfuzz class
  • Configuration
  • Parser
  • Engine
  • Date utilities