• Course Structure & Outline Free
  • Introducing the Course Project Free
  • Setting Expectations Free

  • Benchmark Assessment Free

  • What is Python? Free
  • Python for Data Analysis Free
  • The Python Analytics Ecosystem Free
  • Data Roles that use Python Free

  • Jupyter Notebooks Intro & Install Free
  • Launching Jupyter & Creating a Notebook Free
  • The Jupyter Interface Free
  • The Code Cell Free
  • Comments & Markdown Free
  • The Print Function & Function Help Pro
  • ALTERNATIVE: Google Colab Pro
  • Helpful Resources & Key Takeaways Pro
  • QUIZ: Jupyter Notebooks Pro

  • Python Data Types Pro
  • The Type Function & Type Conversion Pro
  • DEMO: Type Function & Conversion Pro
  • Iterables & Mutability Pro
  • QUIZ: Python Data Types Pro

  • Intro to Variables Pro
  • DEMO: Variable Assignment Pro
  • ASSIGNMENT: Variable Assignment Pro
  • SOLUTION: Variable Assignment Pro
  • Overwriting Variables Pro
  • Deleting Variables Pro
  • DEMO: Overwriting & Deleting Variables Pro
  • Variable Naming Rules Pro
  • Keeping Track of Variables Pro
  • DEMO: Naming & Tracking Variables Pro
  • ASSIGNMENT: Variable Naming Rules Pro
  • SOLUTION: Variable Naming Rules Pro
  • Key Takeaways Pro
  • QUIZ: Variables Pro

  • Intro to Numeric Data Pro
  • Numeric Data Types Pro
  • Numeric Type Conversion Pro
  • Arithmetic Operators & Order of Operations Pro
  • DEMO: Numeric Data Pro
  • ASSIGNMENT: Arithemetic Operators Pro
  • SOLUTION: Arithmetic Operators Pro
  • Numeric Functions Pro
  • DEMO: Numeric Functions Pro
  • ASSIGNMENT: Numeric Functions Pro
  • SOLUTION: Numeric Functions Pro
  • Key Takeaways Pro
  • QUIZ: Numeric Data Pro

  • Intro to Strings Pro
  • String Arithmetic Pro
  • DEMO: String Creation & Arithmetic Pro
  • String Indexing Pro
  • DEMO: String Indexing Pro
  • ASSIGNMENT: String Indexing Pro
  • SOLUTION: String Indexing Pro
  • String Slicing Pro
  • DEMO: String Slicing Pro
  • ASSIGNMENT: String Slicing Pro
  • SOLUTION: String Slicing Pro
  • The Length Function Pro
  • ASSIGNMENT: The Length Function Pro
  • SOLUTION: The Length Function Pro
  • String Methods Pro
  • DEMO: String Methods Pro
  • ASSIGNMENT: String Methods Pro
  • SOLUTION: String Methods Pro
  • F-Strings Pro
  • DEMO: F-Strings Pro
  • ASSIGNMENT: F-Strings Pro
  • SOLUTION: F-Strings Pro
  • Key Takeaways Pro
  • QUIZ: Strings Pro

  • The Boolean Data Type Pro
  • Comparison Operators & Membership Tests Pro
  • Boolean Operators Pro
  • DEMO: Boolean Data Types & Operators Pro
  • ASSIGNMENT: Boolean Operators Pro
  • SOLUTION: Boolean Operators Pro
  • The IF Statement & Control Flow Pro
  • Else & Elif Statements Pro
  • DEMO: If, Else, Elif Pro
  • ASSIGNMENT: Control Flow Pro
  • SOLUTION: Control Flow Pro
  • Nested If Statements Pro
  • ASSIGNMENT: Nested If Statements Pro
  • SOLUTION: Nested If Statements Pro
  • Key Takeaways Pro
  • QUIZ: Conditional Logic Pro

  • Sequence & List Basics Pro
  • List Operations Pro
  • DEMO: List Operations Pro
  • ASSIGNMENT: List Operations Pro
  • SOLUTION: List Operations Pro
  • Modifying Lists Pro
  • DEMO: Modifying Lists Pro
  • ASSIGNMENT: Adding List Elements Pro
  • SOLUTION: Adding List Elements Pro
  • ASSIGNMENT: Removing List Elements Pro
  • SOLUTION: Removing List Elements Pro
  • List Methods & Functions Pro
  • DEMO: List Methods & Functions Pro
  • ASSIGNMENT: List Methods & Functions Pro
  • SOLUTION: List Methods & Functions Pro
  • Nesting & Copying Lists Pro
  • DEMO: Nested Lists & Copying Lists Pro
  • ASSIGNMENT: Nested Lists & Copying Lists Pro
  • SOLUTION: Nested Lists & Copying Lists Pro
  • Tuples Pro
  • DEMO: Tuples Pro
  • ASSIGNMENT: Tuples Pro
  • SOLUTION: Tuples Pro
  • Ranges Pro
  • DEMO: Ranges Pro
  • ASSIGNMENT: Ranges Pro
  • SOLUTION: Ranges Pro
  • Key Takeaways Pro
  • QUIZ: Sequence Data Types Pro

  • Loop Basics Pro
  • For Loops & Looping Over Items Pro
  • DEMO: For Loops Pro
  • Looping Over Indices & Multiple Iterables Pro
  • DEMO: Looping Over Indices Pro
  • PRO TIP: Enumerate Pro
  • DEMO: Enumerate Pro
  • ASSIGNMENT: For Loops Pro
  • SOLUTION: For Loops Pro
  • ASSIGNMENT: Enumerate Pro
  • SOLUTION: Enumerate Pro
  • While Loops Pro
  • DEMO: While Loops Pro
  • ASSIGNMENT: While Loops Pro
  • SOLUTION: While Loops Pro
  • Nested Loops Pro
  • DEMO: Nested Loops Pro
  • ASSIGNMENT: Nested Loops Pro
  • SOLUTION: Nested Loops Pro
  • Loop Control Pro
  • Break, Continue & Pass Pro
  • Try-Except Pro
  • DEMO: Loop Control Pro
  • ASSIGNMENT: Loop Control Pro
  • SOLUTION: Loop Control Pro
  • Key Takeaways Pro
  • QUIZ: Loops Pro

  • Intro to Dictionaries Pro
  • Dictionary Overview Pro
  • Accessing & Modifying Dictionary Values Pro
  • DEMO: Dictionary Operations Pro
  • ASSIGNMENT: Dictionary Basics Pro
  • SOLUTION: Dictionary Basics Pro
  • ASSIGNMENT: Dictionary Creation Pro
  • SOLUTION: Dictionary Creation Pro
  • Keys & Values Methods Pro
  • Get, Items & Update Methods Pro
  • DEMO: Dictionary Methods Pro
  • ASSIGNMENT: Dictionary Methods Pro
  • SOLUTION: Dictionary Methods Pro
  • The Zip Function Pro
  • ASSIGNMENT: The Zip Function Pro
  • SOLUTION: The Zip Function Pro
  • Nested Dictionaries Pro
  • DEMO: Nested Dictionaries Pro
  • ASSIGNMENT: Nested Dictionaries Pro
  • SOLUTION: Nested Dictionaries Pro
  • Intro to Sets Pro
  • DEMO: Sets Pro
  • ASSIGNMENT: Sets Pro
  • SOLUTION:Sets Pro
  • Set Operations Pro
  • Set Use Cases Pro
  • DEMO: Set Operations Pro
  • ASSIGNMENT: Set Operations Pro
  • SOLUTION: Set Operations Pro
  • Key Takeaways Pro
  • QUIZ: Dictionaries & Sets Pro

  • Intro to Functions Pro
  • Anatomy of a Function Pro
  • Defining Functions Pro
  • The Docstring Pro
  • DEMO: Defining a Function Pro
  • ASSIGNMENT: Defining a Function Pro
  • SOLUTION: Defining a Function Pro
  • Argument Types Pro
  • DEMO: Argument Types Pro
  • Return Values Pro
  • DEMO: Return Values Pro
  • Variable Scope Pro
  • DEMO: Variable Scope Pro
  • Creating Modules Pro
  • Importing Modules Pro
  • DEMO: Creating & Importing Modules Pro
  • ASSIGNMENT: Creating a Module Pro
  • SOLUTION: Creating A Module Pro
  • ASSIGNMENT: Importing a Function Pro
  • SOLUTION: Importing a Function Pro
  • Importing External Functions Pro
  • PRO TIP: Naming Conflicts Pro
  • Installing & Managing Packages Pro
  • DEMO: Installing Packages Pro
  • The Map Function Pro
  • ASSIGNMENT: The Map Function Pro
  • SOLUTION: The Map Function Pro
  • Lambda Functions Pro
  • DEMO: Lambda Functions Pro
  • ASSIGNMENT: Lambda Functions Pro
  • SOLUTION: Lambda Functions Pro
  • PRO TIP: Comprehensions Pro
  • DEMO: List Comprehensions Pro
  • ASSIGNMENT: List Comprehensions Pro
  • SOLUTION: List Comprehensions Pro
  • PRO TIP: Dictionary Comprehensions Pro
  • DEMO: Dictionary Comprehensions Pro
  • ASSIGNMENT: Dictionary Comprehensions Pro
  • SOLUTION: Dictionary Comprehensions Pro
  • PRO TIP: Comprehensions vs. Map() Pro
  • Key Takeaways Pro
  • QUIZ: Functions Pro

  • The Openpyxl Package Pro
  • Navigating Excel Workbooks, Worksheets & Cells Pro
  • DEMO: Navigating Excel Workbooks With Python Pro
  • ASSIGNMENT: Missing Sales Tax Pro
  • SOLUTION: Missing Sales Tax Pro
  • Determining Ranges & Writing to Cells Pro
  • DEMO: Writing To Excel From Python Pro
  • ASSIGNMENT: Pound & Yen Columns Pro
  • SOLUTION: Pound & Yen Columns Pro
  • Inserting & Deleting Columns Pro
  • Saving Workbooks Pro
  • Bringing it All Together Pro
  • Key Takeaways Pro
  • QUIZ: Manipulating Excel Sheets Pro

  • Welcome to the Final Project! Pro
  • SOLUTION: Final Project (Part 1) Pro
  • SOLUTION: Final Project (Part 2) Pro

  • Final Assessment Pro

  • Course Feedback Survey Pro
  • Share the Love! Pro
  • Next Steps Pro