fugue
RasgoQL
Our great sponsors
fugue | RasgoQL | |
---|---|---|
11 | 11 | |
1,876 | 267 | |
2.3% | 0.4% | |
6.7 | 0.0 | |
6 days ago | almost 2 years ago | |
Python | Jupyter Notebook | |
Apache License 2.0 | GNU Affero General Public License v3.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
fugue
- FLaNK Stack Weekly 22 January 2024
-
Daft: A High-Performance Distributed Dataframe Library for Multimodal Data
Please integrate it with Fugue.
https://github.com/fugue-project/fugue
- Fugue: A unified interface for distributed computing
- [Discussion] Open Source beats Google's AutoML for Time series
- Ask HN: How do you test SQL?
-
Replacing Pandas with Polars. A Practical Guide
Fugue is an interesting library in this space , though I haven’t tried it
https://github.com/fugue-project/fugue
A unified interface for distributed computing. Fugue executes SQL, Python, and Pandas code on Spark, Dask and Ray without any rewrites.
-
The hand-picked selection of the best Python libraries and tools of 2022
fugue — distributed computing done easy
-
[P] Open data transformations in Python, no SQL required
This looks similar to fugue, am I right? How do they compare?
-
What the Duck?!
I am looking forward to how Substrait could help removing this friction. It aims to provide a standardised intermediate query language (lower level than SQL) to connect frontend user interfaces like SQL or data frame libraries with backend analytical computing engines. It is linked to the Arrow ecosystem. Something like Ibis or Fugue could become the front and DuckDB the backend engine.
-
Pyspark now provides a native Pandas API
There's dask-sql, but I think it is being abandoned for fugue-project. I'm actually excited for this project as it is trying to provide a backend agnostic solution, which would seem like a difficult, lofty goal. I wish them luck.
RasgoQL
-
Dbt Vs python scripts
I built an open source package to bridge the gap between python and dbt, would love your feedback if you have a chance to check it out: https://github.com/rasgointelligence/RasgoQL
-
How to balance multiple time series data?
I’ve actually solved a similar problem several times in a variety of settings. I’ve had success with boosted trees and feature engineering on the sensor readings over time. I treat each reading as an observation and set the target to be the value I want to forecast (e.g. one hour ahead, the sum over the next day, the value at the same time the next day). There was a recent paper that compared boosted trees to deep learning techniques and found the boosted trees performed really well. Next, I perform feature engineering to aggregate the data up to the current time. These features will include the current value, lagged values over multiple observations for that sensor, more complicated features from moving statistics over different time scales, etc. I actually wrote a blog about creating these features using the open-source package RasgoQL and have similar types of features shared in the open-source repository here. I have also had success creating these sorts of historical features using the tsfresh package. Finally, when evaluating the forecast, use a time based split so earlier data is used to train the model and later data to evaluate the model.
-
RasgoQL - Open source data transformations in Python, without having to write SQL.
I created RasgoQL to give anyone a pandas-like syntax that you can use to quickly generate hundreds of lines of SQL that will run directly in your Snowflake or BigQuery data warehouse (with more data warehouse support coming soon). The best part? In one line of code, you can export this SQL to your dbt project so that it can run in production alongside other data pipelines.
- RasgoQL - Transform tables directly with Python, without writing SQL
- RasgoQL - Open data transformations in Python, no SQL required
-
[P] Open data transformations in Python, no SQL required
You can check it out here: https://github.com/rasgointelligence/RasgoQL
- [Project] Open data transformations in Python, no SQL required
- Open data transformations in Python, no SQL required
What are some alternatives?
modin - Modin: Scale your Pandas workflows by changing a single line of code
pygwalker - PyGWalker: Turn your pandas dataframe into an interactive UI for visual analysis
data-science-ipython-notebooks - Data science Python notebooks: Deep learning (TensorFlow, Theano, Caffe, Keras), scikit-learn, Kaggle, big data (Spark, Hadoop MapReduce, HDFS), matplotlib, pandas, NumPy, SciPy, Python essentials, AWS, and various command lines.
Data-Science-For-Beginners - 10 Weeks, 20 Lessons, Data Science for All!
Optimus - :truck: Agile Data Preparation Workflows made easy with Pandas, Dask, cuDF, Dask-cuDF, Vaex and PySpark
tempo - API for manipulating time series on top of Apache Spark: lagged time values, rolling statistics (mean, avg, sum, count, etc), AS OF joins, downsampling, and interpolation
mlToolKits - learningOrchestra is a distributed Machine Learning integration tool that facilitates and streamlines iterative processes in a Data Science project.
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
xarray - N-D labeled arrays and datasets in Python
ickle - DataFrame, analysis & manipulation library for tiny labeled datasets
ploomber - The fastest ⚡️ way to build data pipelines. Develop iteratively, deploy anywhere. ☁️
100-pandas-puzzles - 100 data puzzles for pandas, ranging from short and simple to super tricky (60% complete)