Introduction to Python scripting

[lfunderburk]

Starter doc

https://ploomber-sql.readthedocs.io/en/latest/packaging-your-sql-project/intro-to-python-scripting-and-pipelines.html

The goal of this blog is to get the users familiar with the key elements in python scripting:

1. What is a .py script and how is it different from working with Jupyter notebooks
2. Good software development practices for scripting:
   a. Imports at the top
   b. Function definition (should include mention of naming conventions, docstrings, and modularization, use Pythonic principles)
   c. Main program (what does if __name__=="__main__: means and why is it used.
   d. Calling functions from the main program
3. Introducing Python scripting for data download, cleaning and saving with pandas and SQLAlchemy