Tutorials
Hands-On Python
Hands-On Python
  • Hands-On Python Tutorial For Real-World Business Analytics Problems
  • Preface
    • Section I. A Note From The Author
    • Section II. Tutorial Overview
    • Section III. What Is The Preflight Checklist?
    • Section IV. Supplimentery Material
  • Preflight Checklist
    • Section V. Select Your Difficulty Setting
    • Section VI. Download Anaconda
    • Section VII. Download PyCharm (Optional)
    • Section VIII. Download SQL Server Developer Edition
    • Section IX. Configure Database Environment
    • Section X. Download The Source Code
    • Section XI. Starting JupyterLab
    • Section XII. How To Get Help With This Tutorial
  • Language Basics
    • Lesson 1. Obligatory Hello World
    • Lesson 2. Code Comments
    • Lesson 3. Data Types
    • Lesson 4. Variables
    • Lesson 5. String Concatenation
    • Lesson 6. Arithmetic Operators
    • Lesson 7. Making Decisions
    • Lesson 8. Control Flow With if-elif-else
    • Lesson 9. Control Flow With while
    • Lesson 10. Data Structures Part I: List
    • Lesson 11. Data Structures Part II: Tuples
    • Lesson 12. Data Structures Part III: Dictionaries
    • Lesson 13. Looping With for
    • Lesson 14. Functions
    • Lesson 15. Importing Modules
    • Lesson 16. Python Programming Standards
  • Advanced Topics
    • Lesson 17. Functional Programing With map
    • Lesson 18. Generators
    • Lesson 19. Comprehensions
    • Lesson 20. Basic File Operations
    • Lesson 21. Working With Data In Numpy
    • Lesson 22. Working With Data In Pandas
    • Lesson 23. Working With JSON
    • Lesson 24. Making File Request Over HTTP And SFTP
    • Lesson 25. Interacting With Databases
    • Lesson 26. Saving Objects With Pickle
    • Lesson 27. Error Handling
    • Lesson 28. Bringing It All Together
  • Solutions To Real World Problems
    • Lesson 29. Download A Zip File Over HTTP
    • Lesson 30. Looping Over Files In A Directory
    • Lesson 31. Convert Comma Delmited Files To Pipe Delimited
    • Lesson 32. Combining Multiple CSVs Into One File
    • Lesson 33. Load Large CSVs Into Data Warehouse Staging Tables
    • Lesson 34. Efficiently Write Large Database Query Results To Disk
    • Lesson 35. Working With SFTP In The Real World
    • Lesson 36. Executing Python From SQL Server Agent
Powered by GitBook
On this page
  1. Preface

Section II. Tutorial Overview

PreviousSection I. A Note From The AuthorNextSection III. What Is The Preflight Checklist?

Last updated 3 years ago

Like all MSU tutorials, this tutorial is not generic content. Yes, we need to learn syntax and all the other things you will find in every programming language. Once that is done, you are going to start learning how to use Python in a business analytics context.

This tutorial is very focused on a specific use case and takes an opinionated appproch to teaching. It is for people wanting to work in business analytics doing data engineering, data science, or data visualization work. There will be no discussion of the web development frameworks Django or Flask.

This tutorial is organized in four parts.

Language Basics

This section takes you through foundational Python

Advanced Topics

This section takes you into the heavier programming aspects of Python. Here you will start to learn how to perform real world task.

Solutions To Real World Problems

This is a highly opinionated section where I share my solutions to recurring problems that I have tackled over the past 20 years. Fortunately, all this stuff was kept in various forums, emails, and Stack Overflow in addition to the stuff I keep at the top of my head.

If you are brand new to Python, much of this section may go over your head. That is ok. File it away for later.

This section is basically me uploading two decades of coding experience to the internet. I am not saying the way I do things is the correct way. I am saying that this is what I did and feel free to steal and adapt to your use case.

Final Project

Just like universities everywhere, this tutorial has a final project. You will be given a set of business requirements. You will use the skills you have learned in this course to develop a solution. There are no answers provided. You will need to use your knowledge and creativity to tackle the problem.

What We Gon Learn

I am going to teach you enough Python that you can start doing basic task, with the language. Additionally, this tutorial will set you up for more advanced tutorials, and, ultimately, allow you to follow along in classes that are taught using Python.

The focus of this tutorial is learning basic extract, transform, load (ETL) task with Python. It does not matter what data analytics track you go down. At some point, you are going to have to download a file, move a file, suck in a file, drag out a file, or manipulate a file. The list goes on. In business analytics, sooner or later, there is a file involved.

I want to make clear that, unlike the , this tutorial will not give you job ready skills. Python is a huge language and you should settle in for months of study before you would be considered minimally qualified for an entry level position. This tutorial is a good start but it is not any more than that.

What We Not Gon Learn

I am not going to teach you how to write software with Python. Not in this tutorial. I am going to teach you how to write scripts. Scripts are a series of instructions that execute top to bottom and require only one file of source code to do its job.

Learning how to write software is for people on the data engineering track. People that are on the data science track may want to learn how to write software as part of literate statistical programming training. Those on the data visualization track have the shortest path to their career. All you need is this tutorial and one more, and you’re done.

A Word Of Caution About This Tutorial

I do NOT take myself seriously. If you’re looking for a stuffy wishy-washy generic tutorial that is about as exciting as oatmeal, you are taking the WRONG tutorial my friend.

Fun fact. In the winter months of grade school, grandma fed me oatmeal EVERYDAY for breakfast. I don’t ever want to see another bowl of oatmeal again.

Practical T-SQL Pocket Guide For Beginners