data_algebra is a data manipulation language that can both generate SQL queries and work on Pandas DataFrames.

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for jmountwv from gravatar.com jmountwv

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: BSD License (License :: OSI Approved :: BSD 3-clause License)
  • Author: John Mount
  • Requires: Python >=3.7
Classifiers

Project description

data_algebra is a piped data wrangling system based on Codd's relational algebra and experience working with data manipulation languages at scale.
The primary purpose of the package is to support an easy to compose and maintain grammar of data processing steps that in turn can be used to generate database specific SQL. The package also implements the same transforms for Pandas and Polars DataFrames.

Currently the system is primarily adapted and testing for Pandas, Polars, Google BigQuery, PostgreSQL, SQLite, Spark, and MySQL.

R versions of the system are available as the rquery and rqdatatable packages.

Project details

Verified details

These details have been verified by PyPI
Maintainers
Avatar for jmountwv from gravatar.com jmountwv

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: BSD License (License :: OSI Approved :: BSD 3-clause License)
  • Author: John Mount
  • Requires: Python >=3.7
Classifiers

Release history Release notifications | RSS feed

1.7.1

1.7.0

1.6.9

1.6.8

1.6.7

1.6.6

1.6.5

1.6.4

1.6.3

1.6.2

This version

1.6.1

1.6.0

1.5.0

1.4.5

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.3

1.3.2

1.3.1

1.3.0

1.2.2

1.2.1

1.2.0

1.1.2

1.1.1

1.1.0

1.0.0

0.9.1

0.9.0

0.8.2

0.8.0

0.7.9

0.7.8

0.7.7

0.7.6

0.7.5 yanked

Reason this release was yanked:

obsolete

0.7.4 yanked

Reason this release was yanked:

obsolete

0.7.3 yanked

Reason this release was yanked:

obsolete

0.7.2 yanked

Reason this release was yanked:

obsolete

0.7.1 yanked

Reason this release was yanked:

obsolete

0.7.0

0.6.3

0.6.2

0.5.4

0.5.0

0.4.7

0.4.0

0.3.9

0.3.3

0.3.0

0.2.9

0.2.4

Download files

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

Source Distribution

data_algebra-1.6.1.tar.gz (114.4 kB view details)

Uploaded Source

Built Distribution

data_algebra-1.6.1-py3-none-any.whl (120.6 kB view details)

Uploaded Python 3

File details

Details for the file data_algebra-1.6.1.tar.gz.

File metadata

  • Download URL: data_algebra-1.6.1.tar.gz
  • Upload date:
  • Size: 114.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.11.3 pkginfo/1.8.3 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.64.1 CPython/3.10.8

File hashes

Hashes for data_algebra-1.6.1.tar.gz
Algorithm Hash digest
SHA256 24f9e9448d123bce6303654315911c19093c4876f1d2df57b85731ef8556cd2f
MD5 53f4869ffe77e503740e978e682e0ca3
BLAKE2b-256 d1175cc55670530264c93c4f3854b42772eee96106ecb195d43d81d0c405c5f4

See more details on using hashes here.

File details

Details for the file data_algebra-1.6.1-py3-none-any.whl.

File metadata

  • Download URL: data_algebra-1.6.1-py3-none-any.whl
  • Upload date:
  • Size: 120.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/4.11.3 pkginfo/1.8.3 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.64.1 CPython/3.10.8

File hashes

Hashes for data_algebra-1.6.1-py3-none-any.whl
Algorithm Hash digest
SHA256 811696743ae8d57567e4a34e9ad900c852692962ceb4c70adf1e607be5168007
MD5 5988c058ce8454769c359dd70a105e23
BLAKE2b-256 623750c9415a682b6ae5dd7ee9b34c945b966cc9ff24fb7cfc5c855b1a271949

See more details on using hashes here.

Supported by

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