Recommended Article for data analysts learning Python and SQL
Full article written by Sanjana is posted here
A data analyst or data scientist get lots of opportunity to work on Python and SQL. Python with its enormous library support provides data analyst with a magic wand to manipulate and visualize data. Likewise SQL helps us store millions of records and establish relationships with other tables for optimal data management. There are scenarios that require a Python program to directly load data into a back-end database. For example, if a data frame is dynamically modified periodically or at random instances, uploading the csv file for each data update into the database is not feasible. In this post, we will go through how to integrate a Python program with MySQL database.