keyten

Python bindings for Keyten, a tiny columnar dataframe engine with compressed blocks and a lazy query optimizer.

Queries stay lazy until collect(), then run entirely in the engine with the GIL released — predicate and projection pushdown, vectorized parallel execution, disk spilling for data bigger than memory, and native-table I/O all happen outside the interpreter.

Install

Keyten currently supports 64-bit Linux, macOS arm64 (Apple Silicon), and CPython 3.11 or newer:

pip install keyten

A first query

import keyten as kt

trades = kt.DataFrame([
    kt.Series.string("sym", ["a", "b", "a", "b"]),
    kt.Series.int("qty", [1, 2, 3, 4]),
])

result = (
    trades.lazy()
    .filter(kt.col("qty") > 1)
    .with_columns((kt.col("qty") * 10).alias("q10"))
    .group_by("sym")
    .agg([
        kt.col("q10").sum(),
        kt.col("qty").count().alias("n"),
    ])
    .sort("sym")
    .collect()
)

print(result)

What's in the box

  • Expressions — arithmetic, comparisons, boolean logic, casts, string operations (substring, regex extract), value recoding, null/NaN shaping, and conditional if_else.
  • Aggregations — sum/min/max/mean/count/first/last/std/median/n_unique and pairwise corr, per group or whole-frame.
  • Windows — cum_sum, shift, diff, rolling_mean, forward_fill, and over(...) partitioned evaluation.
  • Joins — inner, left, semi, anti, and a time-series backward asof join with by-groups.
  • Temporal kinds — dates, timestamps, and times are first-class, parse straight from CSV, and ride the integer encodings.
  • Sources — scan_csv (strict typed inference), scan_parquet (files or directories, statistics-pruned), and scan_native, the engine's own zero-copy, crash-safe table format.
  • Scale — out-of-core execution against a self-derived memory budget; nothing to configure.

The package ships typed stubs (py.typed), so editors and type checkers see the full API with docstrings.

Documentation

Tutorials, the full API reference, and engine internals live at k10.works/docs.

License

Licensed under the MIT License.

Project links

Data verified by PyPI on Aug 12, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (0.1.52)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for hetoku from gravatar.com hetoku

Credits

Author: Anton Kundenko

GitHub Statistics

Data verified by PyPI on Aug 12, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License expression

MIT
View SPDX License List

Requires

Python >=3.11

Tags

dataframe columnar query-engine analytics

Classifiers

Report project as malware

Download files

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

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

keyten-0.1.49-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (4.3 MB view details)

Uploaded CPython 3.11+manylinux: glibc 2.17+ x86-64

keyten-0.1.49-cp311-abi3-macosx_11_0_arm64.whl (3.6 MB view details)

Uploaded CPython 3.11+macOS 11.0+ ARM64

File details

Details for the file keyten-0.1.49-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for keyten-0.1.49-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 e87d999a403b48cc23bbe8967931f4025bd6e59b667015b669803f9e08695e5b
MD5 8f690ba1b09ed8e26b151ddd6ec00eb5
BLAKE2b-256 38a88606822dd919aff6a51c64ff7e532f8ce8d25507fe07c37ea297232529ba

See more details on using hashes here.

Provenance

The following attestation bundles were made for keyten-0.1.49-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl:

Publisher: py-release.yml on k10works/keyten

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

File details

Details for the file keyten-0.1.49-cp311-abi3-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for keyten-0.1.49-cp311-abi3-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 9ae2a8257451030d9cf414f5594f555cc39bbcf9f99d69ad7562f43e04eb07e1
MD5 7bfc6faed29d8f92852c02ed553366d4
BLAKE2b-256 2fc01bccaf9e98dd88c7eab51d0a3e90a7400062905d0a605f855100f8ac256e

See more details on using hashes here.

Provenance

The following attestation bundles were made for keyten-0.1.49-cp311-abi3-macosx_11_0_arm64.whl:

Publisher: py-release.yml on k10works/keyten

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 Sentry Error logging StatusPage Status page