letsql

letsql

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

Stars: 77

Visit
 screenshot

LETSQL is a data processing library built on top of Ibis and DataFusion to write multi-engine data workflows. It is currently in development and does not have a stable release. Users can install LETSQL from PyPI and use it to connect to data sources, read data, filter, group, and aggregate data for analysis. Contributions to the project are welcome, and the library is actively maintained with support available for any issues. LETSQL heavily relies on Ibis and DataFusion for its functionality.

README:

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.

[!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 letsql on PyPI:

pip install letsql

Usage

import urllib.request

import letsql as ls

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

con = ls.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 'letsql[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 letsql

Similar Open Source Tools

For similar tasks

For similar jobs