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.48-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.48-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.48-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl.

File metadata

File hashes

Hashes for keyten-0.1.48-cp311-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm Hash digest
SHA256 fad8dfc58f97727c08aa8019cd10ecb8257b1ce2f07929a91e848fb273287454
MD5 0b811cd6cadfe0d2e7b2c96c4984f329
BLAKE2b-256 9606b36c5195ed0e4643faa11052bc6a9abc1554589f3f592a76161b134455af

See more details on using hashes here.

Provenance

The following attestation bundles were made for keyten-0.1.48-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.48-cp311-abi3-macosx_11_0_arm64.whl.

File metadata

File hashes

Hashes for keyten-0.1.48-cp311-abi3-macosx_11_0_arm64.whl
Algorithm Hash digest
SHA256 f8ed6a2fe0153deca42d584ca48ecdd1436be2daa1c8b0cee4ec972e58062f8a
MD5 b0250bab8c15e45ef6e2c486c7d1d53f
BLAKE2b-256 e4fc2b41d7eb9280b8c43771c044f429d40a36fc7df21ded284deb95071c77e0

See more details on using hashes here.

Provenance

The following attestation bundles were made for keyten-0.1.48-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