kennethleungty/PyMySQL-Demo

PyMySQL - Connecting Python and SQL for Data Science

PyMySQL - Connecting Python and SQL for Data Science

Easily access MySQL databases and execute SQL queries in Python

Link to article: https://towardsdatascience.com/pymysql-connecting-python-and-sql-for-data-science-91e7582d21d7

Context

• SQL and Python are indispensable tools for data practitioners to work effectively with data. 
• A common use case would be the retrieval of data from relational databases using SQL queries, followed by manipulation and analysis of the data in Python with libraries such as pandas.
• But did you know that these two seemingly isolated tasks can be combined into a single Python script to deliver the same outcome more easily?
• In this project, we discover the concepts and implementation of PyMySQL for connecting to and interacting with MySQL databases from Python.

Contents

• /data: Folder containing the mock customers data generated from Mockaroo
• /notebooks: Folder containing the Jupyter notebook with the sample codes used in the demonstration

References

• https://pymysql.readthedocs.io/en/latest/
• https://towardsdatascience.com/definitive-guide-to-create-an-sql-database-on-cloud-with-aws-and-python-c818c7270af2