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

Uploaded Source

Built Distribution

data_algebra-1.7.0-py3-none-any.whl (127.3 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: data_algebra-1.7.0.tar.gz
  • Upload date:
  • Size: 184.0 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.0.tar.gz
Algorithm Hash digest
SHA256 90f11cdd33b6ecb33144f89529fd841708514e3ebc00760632c83b25c18e1e12
MD5 00ae083e4c75d11bda42f63a83ebb299
BLAKE2b-256 51d17b808e9ea79858c03fda65115a367dcb3901d2acafe13d986eff757f6c6a

See more details on using hashes here.

File details

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

File metadata

  • Download URL: data_algebra-1.7.0-py3-none-any.whl
  • Upload date:
  • Size: 127.3 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.0-py3-none-any.whl
Algorithm Hash digest
SHA256 66d8ccb62ffea0e4e6054deabaa6aeb165556fa72cebe4db991b3759216ebea1
MD5 2976188a65aff5d3374560b70e129675
BLAKE2b-256 1f09f9a4e49d977efce369cc9140834de17d6fc4dd6bb6025a8bbfe5dac906ef

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