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

This version

1.6.6

1.6.5

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

Uploaded Source

Built Distribution

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

Uploaded Python 3

File details

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

File metadata

  • Download URL: data_algebra-1.6.6.tar.gz
  • Upload date:
  • Size: 114.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.7.1 importlib_metadata/6.0.0 pkginfo/1.9.6 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.65.0 CPython/3.10.10

File hashes

Hashes for data_algebra-1.6.6.tar.gz
Algorithm Hash digest
SHA256 21ac9e1e1e11890675c6d16b0c19d7b11b4db4071e2ec121c281a07e2d388cf2
MD5 566e400970f0575b2ffe20611d146a9d
BLAKE2b-256 a768bca01f5457569c532dc7f17bcecb031400564abf646a90aef89d738107df

See more details on using hashes here.

File details

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

File metadata

  • Download URL: data_algebra-1.6.6-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/6.0.0 pkginfo/1.9.6 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.65.0 CPython/3.10.10

File hashes

Hashes for data_algebra-1.6.6-py3-none-any.whl
Algorithm Hash digest
SHA256 94681b74f45da59d558258ef9872dc846575ab21a8030973d4fba0839f375eeb
MD5 167b562b5a97d821acbbe10b9b53731e
BLAKE2b-256 4d344f06973d656390e3ae2d8b717a0f602fba9f4138725df44f790c6c4403a8

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