How to Convert SQL into Python Pandas? Part 1

Informula
Imu Framework Design
2 min readApr 24, 2023

--

In this series of articles, we will study how to convert SQL statements into Python Pandas syntax. We are using Google Colab to access to the database file stored in Google Drive and to run the python statements.

Access to DB

We upload the SQLite DB file named with “sample.db” under Data/db. The data we are using is SQLite Sample Database Chinook.

--

--