Pandas and SQL together, a Premier League and Player Scouting Example
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.