Querying the Premier League using Python and SQL Combined
https://towardsdatascience.com/querying-the-premier-league-using-python-and-sql-combined-501cb9d9319a
It may be useful sometimes to convert an Excel sheet into a MySQL database. This conversion will enable querying operations to be undertaken using straightforward SQL queries. Using Python, we can simply convert a limited Excel spreadsheet into a MySQL database.
To demonstrate how this is possible, I will use a Sports example. Having witnessed Liverpool’s triumphant display against Barcelona in the UEFA Champions League (07/05/19), I will choose an example close to home, the Premier League Table.
Querying the Premier League using Python and SQL Combined
May 9, 2019, 9:19pm UTC
https://towardsdatascience.com/querying-the-premier-league-using-python-and-sql-combined-501cb9d9319a
> It may be useful sometimes to convert an Excel sheet into a MySQL database. This conversion will enable querying operations to be undertaken using straightforward SQL queries. Using Python, we can simply convert a limited Excel spreadsheet into a MySQL database.
> To demonstrate how this is possible, I will use a Sports example. Having witnessed Liverpool’s triumphant display against Barcelona in the UEFA Champions League (07/05/19), I will choose an example close to home, the Premier League Table.