Introducing FugueSQL — SQL for Pandas, Spark, and Dask DataFrames

As a data scientist, you might be familiar with both Pandas and SQL. However, there might be some queries, transformations that you feel comfortable doing in SQL instead of Python.

Wouldn’t it be nice if you can query a pandas DataFrame using SQL or use a Python function within a SQL query?

That is when FugueSQL comes in handy. FugueSQL is a Python library that allows users to combine Python code and SQL commands.

In my latest article, we will explore some utilities of FugueSQL and compare FugueSQL with other tools such as pandasql.

Link to the article.

Link to the source code

Scroll to Top