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

This version

1.6.4

1.6.3

1.6.2

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.4.tar.gz (114.4 kB view details)

Uploaded Source

Built Distribution

data_algebra-1.6.4-py3-none-any.whl (120.3 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: data_algebra-1.6.4.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.4.tar.gz
Algorithm Hash digest
SHA256 57bff0daefc2c91fa0912e915f56392befaf9adf4d2db5ef6dec09bde723e639
MD5 036416d26e5c26bb3d913386a70a7b3b
BLAKE2b-256 9d2764a4e867ab3a89810d691f047ad61ec202c7ce565771744e641e82ad4059

See more details on using hashes here.

File details

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

File metadata

  • Download URL: data_algebra-1.6.4-py3-none-any.whl
  • Upload date:
  • Size: 120.3 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.4-py3-none-any.whl
Algorithm Hash digest
SHA256 11c1ff9bc97280e7207bbeec2d158350e8eb0eba0d8960f1426cd48fef6e77ac
MD5 f57528dd9aab2ed906c15b67cedb632d
BLAKE2b-256 850d74860886227528eec5f55594f708a8162c5d15f5e0cbacf608883a09f274

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