xorq

xorq

LETSQL is a deferred compute system focused on smart composition of AI pipelines. Optimize performance with cross-engine caching and static planning. Easily go from research to production with portable UDFs.

Stars: 93

Visit
 screenshot

Xorq (formerly LETSQL) is a data processing library built on top of Ibis and DataFusion to write multi-engine data workflows. It provides a flexible and powerful tool for processing and analyzing data from various sources, enabling users to create complex data pipelines and perform advanced data transformations.

README:

xorq (formerly LETSQL)

Downloads PyPI - Version GitHub License PyPI - Status GitHub Actions Workflow Status Codecov

Data processing library built on top of Ibis and DataFusion to write multi-engine data workflows.

[!NOTE]
We are changing the name from LETSQL to xorq.

[!CAUTION] This library does not currently have a stable release. Both the API and implementation are subject to change, and future updates may not be backward compatible.

Getting Started

Installation

LETSQL is available as xorq on PyPI:

pip install xorq

Usage

import urllib.request

import xorq as xq

urllib.request.urlretrieve("https://raw.githubusercontent.com/mwaskom/seaborn-data/master/iris.csv", "iris.csv")

con = xq.connect()
iris_table = con.read_csv("iris.csv", table_name="iris")

res = (
    iris_table.filter([iris_table.sepal_length > 5])
    .group_by("species")
    .agg(iris_table.sepal_width.sum())
    .execute()
)

for more examples on how to use letsql, check the examples directory, note that in order to run some of the scripts in there, you need to install the library with examples extra:

pip install 'xorq[examples]'

Contributing

Contributions are welcome and highly appreciated. To get started, check out the contributing guidelines.

Support

If you have any issues with this repository, please don't hesitate to raise them. It is actively maintained, and we will do our best to help you.

Acknowledgements

This project heavily relies on Ibis and DataFusion.

Liked the work?

If you've found this repository helpful, why not give it a star? It's an easy way to show your appreciation and support for the project. Plus, it helps others discover it too!

License

This repository is licensed under the Apache License

For Tasks:

Click tags to check more tools for each tasks

For Jobs:

Alternative AI tools for xorq

Similar Open Source Tools

For similar tasks

For similar jobs