Creating a database with MySQL and conecting with python
In this project we are going to create a database from scratch using MySQL workbench. In this case we have created a simple database that simulates a library database.
The script to generate the database is attached to this repository
Once the database is created, the next thing to do is to connect to the database using python. In this project we show how to do it.
finally we will make some simple queries, and the results will be passed to pandas dataframes.
-
learn how to create relational databases
-
learn how to connect to a relational database using python.
-
Learn how to make queries to the database from python and transform the results into pandas dataframes.
- matplotlib==3.5.1
- mysql_connector_repackaged==0.3.1
- palettable==3.3.0
- pandas==1.4.1
- seaborn==0.11.0