Python for Data Analysts
This course covers the basics of getting started with Python, including the semantics of variables, simple and complex data types, and the use of loops for iteration and functions for code reuse. You will also conceptually understand some of Python’s strengths, relative to other technologies.
What you'll learn
Python has exploded in popularity in recent years and has emerged as the technology of choice for data analysts and data scientists.
In this course, Python for Data Analysts, you will gain the ability to write Python programs and utilize fundamental building blocks of programming and data analysis. First, you will learn how programming languages such as Python, spreadsheets such as Microsoft Excel, and SQL-based technologies such as databases differ from each other, and also how they inter-operate.
Next, you will plunge into Python programming, installing Python and getting started with simple programs. You will then understand the ways in which variables are used to hold data, and how simple and complex data types in Python differ in their semantics.
Finally, you will round out your knowledge by working with conditional evaluation using if statements, loops and functions. You will learn how Python treats functions as first-class entities, a key enabler of functional programming.
When you’re finished with this course, you will have the skills and knowledge to identify situations when Python is the right choice for you, and to implement simple but solid programs using Python.
Table of contents
- Version Check 0m
- Module Overview 1m
- Prerequisites and Course Outline 1m
- Python for Data Analysts 3m
- Essential Analytical Building Blocks 5m
- Demo: Installing Anaconda Python on MacOS 5m
- Demo: Installing Anaconda Python on Windows 4m
- Demo: Simple Expressions 6m
- Demo: Logical Operations 5m
- Demo: Variables 6m
- Demo: Basic Types and Type Conversions 4m
- Demo: Simple Strings and Multi-line Strings 4m
- Module Summary 1m
- Module Overview 1m
- Demo: Introducing Built-in Functions 6m
- Demo: String Functions, Return Values, and Nested Function Invocations 6m
- Demo: Introducing Lists 5m
- Demo: List Slicing Operations and List Functions 4m
- Demo: Concatenating and Copying Lists 2m
- Demo: Introducing Tuples 4m
- Demo: Introducing Dictionaries 6m
- Module Summary 1m
- Module Overview 1m
- Transactional and Analytical Processing 5m
- Demo: If Statements for Conditional Branching 4m
- Demo: If Else Statements 6m
- Demo: Using if with Lists and Dictionary Elements 2m
- Demo: If-elif for Multiple Conditional Checks 3m
- Demo: Iterating over List Elements Using a For Loop 5m
- Demo: Using For Loops with the Range Function 3m
- Demo: Iterating over Dictionary Elements Using a For Loop 2m
- Demo: Conditional Looping Using While Loops 8m
- Demo: Break 4m
- Demo: Continue and Pass 4m
- Module Summary 1m
- Module Overview 2m
- Demo: Defining and Invoking Custom Functions 7m
- Demo: Passing Input Arguments to Functions 3m
- Demo: Returning Values from Functions 5m
- Demo: Reassignment of Variables within Functions 6m
- Demo: Modification of Complex Types within Functions 3m
- Demo: Invoking Functions with Keyword Arguments 5m
- Demo: Assigning Default Values for Input Arguments 2m
- Demo: First Class Functions 7m
- Module Summary 1m
- Module Overview 1m
- Demo: Working with the Math Module 3m
- Demo: Introducing NumPy 4m
- Demo: Introducing Pandas 2m
- Demo: Working with the Command Line Processes and Environment Variables 7m
- Demo: Reading the Contents of a File 5m
- Demo: Overwriting and Appending Content to a File 6m
- Demo: Working with CSV and JSON Files 5m
- Module Summary 2m
About the author
Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing ... more