https://towardsdatascience.com/pandas-and-sql-together-a-premier-league-and-player-scouting-example-b41713a5dd3e

Pandas, SQL, Excel data transferThe Python Pandas library makes transferring tabular data from one platform to another simple. This tutorial aims to show you how to move data between a Pandas DataFrame, an SQL database and a Excel spreadsheet, all through the use of Pandas. So wherever your data initially resides, you can transfer it into a format you feel comfortable analyzing and manipulating.

It is often necessary to shuttle data from one platform to another. It may be useful to transform an SQL Table/Query into a Pandas DataFrame. In order to begin, as a prerequisite, 3 modules must be installed. These include; pandas, sqlalchemy, and PyMySQL.