10
51
+ 1
1

What is Pandasql?

pandasql allows you to query pandas DataFrames using SQL syntax. It works similarly to sqldf in R. pandasql seeks to provide a more familiar way of manipulating and cleaning data for people new to Python or pandas.
Pandasql is a tool in the Database Tools category of a tech stack.
Pandasql is an open source tool with 1.3K GitHub stars and 183 GitHub forks. Here’s a link to Pandasql's open source repository on GitHub

Who uses Pandasql?

Developers
7 developers on StackShare have stated that they use Pandasql.
Pros of Pandasql
1
Super fast to handel df by sql syntax

Pandasql Alternatives & Comparisons

What are some alternatives to Pandasql?
SQLAlchemy
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
Pandas
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more.
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
See all alternatives

Pandasql's Followers
51 developers follow Pandasql to keep up with related blogs and decisions.