Skip to main content

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

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


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

Uploaded Source

Built Distribution

data_algebra-1.7.1-py3-none-any.whl (128.0 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: data_algebra-1.7.1.tar.gz
  • Upload date:
  • Size: 185.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.11.5

File hashes

Hashes for data_algebra-1.7.1.tar.gz
Algorithm Hash digest
SHA256 c9010316c5121354a6304a6f2c16ed6392aadcd4167cd7aa261630cf99a05237
MD5 a02c63ecbcf81ad05fa667ab46f5bc9e
BLAKE2b-256 756682a58f206e82f48ca979d00a6c537aef0b0f8b502b082437322c18c7a9d4

See more details on using hashes here.

File details

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

File metadata

  • Download URL: data_algebra-1.7.1-py3-none-any.whl
  • Upload date:
  • Size: 128.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.11.5

File hashes

Hashes for data_algebra-1.7.1-py3-none-any.whl
Algorithm Hash digest
SHA256 46b0d720cc50e8998800aeeca06c311dfd8404ff02c0422502ebc42e43024d7b
MD5 7228016da0e79ba749d2fc5e995576a5
BLAKE2b-256 0a44d59c09ff7f6f29161c9500798f1448bce8e611947bbf859a90d2dbc78a73

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