Querying databases

A common task in data science is to combine data sources to gain new insights. These tasks are typically done using relational databases, collections of tables. The Structured Query Language (SQL) is the tool of choice when it comes to querying databases. When working with Pandas dataframes in Python, we can use the pandasql library for using SQL with pandas, more precisely, it uses SQLite.

See also

• How to Use SQL in Pandas (Towards Data Science)

• Pandas - SQL comparison

Installation

We can install pandasql using mamba/conda

mamba install -c conda-forge pandasql