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.