readsql
Convert SQL to most human readable format (by AzisK)
modin
Modin: Scale your Pandas workflows by changing a single line of code (by modin-project)
readsql | modin | |
---|---|---|
3 | 11 | |
56 | 9,486 | |
- | 0.6% | |
5.1 | 9.6 | |
over 3 years ago | 2 days ago | |
Python | Python | |
MIT License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
readsql
Posts with mentions or reviews of readsql.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2020-12-27.
- Readsql – convert SQL to most human readable format
-
readsql - convert SQL to most human readable format
Thank you. I do not remember now if I have seen it when I started working on it. I have not seen a SQL linter that lints SQL code in Python code. This is the reason readsql was born. I am not familiar with sqlfluff but I do not see that it would lint SQL code inside Python strings (I may have overseen it)
- Show HN: Readsql – convert SQL to most human readable format
modin
Posts with mentions or reviews of modin.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-15.
- The Distributed Tensor Algebra Compiler (2022)
-
A Polars exploration into Kedro
The interesting thing about Polars is that it does not try to be a drop-in replacement to pandas, like Dask, cuDF, or Modin, and instead has its own expressive API. Despite being a young project, it quickly got popular thanks to its easy installation process and its “lightning fast” performance.
-
Modern Polars: an extensive side-by-side comparison of Polars and Pandas
Yeah, tried Polars a couple of times: the API seems worse than Pandas to me too. eg the decision only to support autoincrementing integer indexes seems like it would make debugging "hmmm, that answer is wrong, what exactly did I select?" bugs much more annoying. Polars docs write "blazingly fast" all over them but I doubt that is a compelling point for people using single-node dataframe libraries. It isn't for me.
Modin (https://github.com/modin-project/modin) seems more promising at this point, particularly since a migration path for standing Pandas code is highly desirable.
-
Polars: The Next Big Python Data Science Library... written in RUST?
If anyone wants a faster version of pandas it’s not hard to find, modin for example uses multiple cores to speed it up, so if you have 4 cores it’s about 4 times faster than pandas, and has the same API as pandas.
-
Working with more than 10gb csv
Modin should fit. It implements Pandas APIs with e.g. Ray as backend. https://github.com/modin-project/modin
- Modern Python Performance Considerations
-
I made a video about efficient memory use in pandas dataframes!
If you really want speed you should try modin.pandas which makes pandas multi-threaded.
-
Almost no one knows how easily you can optimize your AI models
I am guessing XGB is fairly optimised as it is. If you would want to use the sklearn libraries with pandas, look into Modin
-
TIL about modin.pandas which significantly speeds up pandas if you import modin.pandas instead of pandas.
Source
- How to Speed Up Pandas with 1 Line of Code
What are some alternatives?
When comparing readsql and modin you can also consider the following projects:
sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
polars - Dataframes powered by a multithreaded, vectorized query engine, written in Rust