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

Uploaded Source

Built Distribution

data_algebra-1.6.9-py3-none-any.whl (125.7 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for data_algebra-1.6.9.tar.gz
Algorithm Hash digest
SHA256 342bfbf34dd77a6a94c0c314c9588c493954389cf318cd12a7f720571e877d34
MD5 b687a825aa12aa81d59e7a96cd233093
BLAKE2b-256 bf2559f86f2fc1a1db1caf5ee8090529f84b330e030b100108b98fc08e17669d

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for data_algebra-1.6.9-py3-none-any.whl
Algorithm Hash digest
SHA256 c50be257db8981a9dbfcfbfba0b585938542cacfa1cfe60eb53da00c8adc155c
MD5 eecc20efbe02c22e5ba22373939cbff4
BLAKE2b-256 a75ef107043a69f00d28aa9559530afd7bcab8c0d85df58cdd2b93f364a8a1ea

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