001 Course Structure & Outline (21.24 MB)
004 Introducing the Course Project (5.17 MB)
005 Setting Expectations (11.02 MB)
001 What is Python (5.48 MB)
002 Python for Data Analysis (11.58 MB)
003 The Python Analytics Ecosystem (13.49 MB)
004 Data Roles that use Python (12.29 MB)
001 Jupyter Notebooks Intro & Install (4.32 MB)
002 Launching Jupyter & Creating a Notebook (7.72 MB)
003 The Jupyter Interface (11.36 MB)
004 The Code Cell (8.84 MB)
005 Comments & Markdown (20.14 MB)
006 The Print Function & Function Help (14.64 MB)
007 ALTERNATIVE Google Colab (2.24 MB)
009 Helpful Resources & Key Takeaways (7.67 MB)
001 Python Data Types (8.25 MB)
002 The Type Function & Type Conversion (6.69 MB)
003 DEMO Type Function & Conversion (5.94 MB)
005 Iterables & Mutability (8.18 MB)
001 Intro to Variables (7.09 MB)
002 DEMO Variable Assignment (3.63 MB)
004 ASSIGNMENT Assigning Variables (5.41 MB)
005 SOLUTION Assigning Variables (2.23 MB)
006 Overwriting Variables (12.85 MB)
007 Deleting Variables (8.85 MB)
008 DEMO Overwriting & Deleting Variables (9.15 MB)
010 Variable Naming Rules (9.47 MB)
011 Keeping Track of Variables (3.55 MB)
012 DEMO Naming & Tracking Variables (7.79 MB)
013 ASSIGNMENT Variable Naming Rules (3.86 MB)
014 SOLUTION Variable Naming Rules (26.59 MB)
015 Key Takeaways (1.85 MB)
001 Intro to Numeric Data (826.89 KB)
002 Numeric Data Types (1.97 MB)
003 Numeric Type Conversion (5.4 MB)
004 Arithmetic Operators & Order of Operations (9.5 MB)
005 DEMO Numeric Data (9.39 MB)
007 ASSIGNMENT Arithemetic Operators (6.2 MB)
008 SOLUTION Arithmetic Operators (23.26 MB)
009 Numeric Functions (5.81 MB)
010 DEMO Numeric Functions (5.92 MB)
012 ASSIGNMENT Numeric Functions (1.84 MB)
013 SOLUTION Numeric Functions (7.42 MB)
014 Key Takeaways (1.59 MB)
001 Intro to Strings (6.51 MB)
002 String Arithmetic (3.96 MB)
003 DEMO String Creation & Arithmetic (11.12 MB)
005 String Indexing (8.86 MB)
006 DEMO String Indexing (1.99 MB)
008 ASSIGNMENT String Indexing (6.43 MB)
009 SOLUTION String Indexing (3.93 MB)
010 String Slicing (12.38 MB)
011 DEMO String Slicing (4.2 MB)
013 ASSIGNMENT String Slicing (4.07 MB)
014 SOLUTION String Slicing (7.83 MB)
015 The Length Function (2.01 MB)
016 ASSIGNMENT The Length Function (4.91 MB)
017 SOLUTION The Length Function (11.15 MB)
018 String Methods (37.06 MB)
019 DEMO String Methods (9.48 MB)
021 ASSIGNMENT String Methods (6.02 MB)
022 SOLUTION String Methods (14 MB)
023 F-Strings (2.85 MB)
024 DEMO F-Strings (2.5 MB)
026 ASSIGNMENT F-Strings (4.62 MB)
027 SOLUTION F-Strings (2.12 MB)
028 Key Takeaways (3.13 MB)
001 The Boolean Data Type (3.29 MB)
002 Comparison Operators & Membership Tests (5.43 MB)
003 Boolean Operators (7.84 MB)
004 DEMO Boolean Data Types & Operators (14.83 MB)
006 ASSIGNMENT Boolean Operators (6.8 MB)
007 SOLUTION Boolean Operators (13.85 MB)
008 The IF Statement & Control Flow (6.08 MB)
009 Else & Elif Statements (10.11 MB)
010 DEMO If, Else, Elif (10.07 MB)
012 ASSIGNMENT Control Flow (1.35 MB)
013 SOLUTION Control Flow (6.25 MB)
014 Nested If Statements (3.65 MB)
015 ASSIGNMENT Nested If Statements (3.11 MB)
016 SOLUTION Nested If Statements (11.04 MB)
017 Key Takeaways (2.44 MB)
001 Sequence & List Basics (3.5 MB)
002 List Operations (5.58 MB)
003 DEMO List Operations (4.5 MB)
005 ASSIGNMENT List Operations (5.03 MB)
006 SOLUTION List Operations (20.02 MB)
007 Modifying Lists (8.95 MB)
008 ASSIGNMENT Adding List Elements (2.86 MB)
009 SOLUTION Adding List Elements (6.63 MB)
010 ASSIGNMENT Removing List Elements (1.95 MB)
011 SOLUTION Removing List Elements (9.43 MB)
012 DEMO Modifying Lists (14.46 MB)
014 List Methods & Functions (8.55 MB)
015 DEMO List Methods & Functions (16.49 MB)
017 ASSIGNMENT List Methods & Functions (12.17 MB)
018 SOLUTION List Methods & Functions (11.4 MB)
019 Nesting & Copying Lists (11.96 MB)
020 DEMO Nested Lists & Copying Lists (18.76 MB)
021 ASSIGNMENT Nested Lists & Copying Lists (3.1 MB)
022 SOLUTION Nested Lists & Copying Lists (15.67 MB)
023 Tuples (7.71 MB)
024 DEMO Tuples (16.43 MB)
026 ASSIGNMENT Tuples (1.99 MB)
027 SOLUTION Tuples (8.3 MB)
028 Ranges (4.32 MB)
029 DEMO Ranges (3.04 MB)
031 ASSIGNMENT Ranges (2.38 MB)
032 SOLUTION Ranges (8.85 MB)
033 Key Takeaways (2.09 MB)
001 Loop Basics (6.43 MB)
002 For Loops & Looping Over Items (8.74 MB)
003 DEMO For Loops (8.33 MB)
005 Looping Over Indices & Multiple Iterables (5.25 MB)
006 DEMO Looping Over Indices (6.94 MB)
008 PRO TIP Enumerate (4.08 MB)
009 DEMO Enumerate (12.32 MB)
011 ASSIGNMENT For Loops (4.73 MB)
012 SOLUTION For Loops (5.5 MB)
013 ASSIGNMENT Enumerate (4.69 MB)
014 SOLUTION Enumerate (6.76 MB)
015 While Loops (9.17 MB)
016 DEMO While Loops (6.62 MB)
018 ASSIGNMENT While Loops (2.22 MB)
019 SOLUTION While Loops (5.77 MB)
020 Nested Loops (6.38 MB)
021 DEMO Nested Loops (8.31 MB)
023 ASSIGNMENT Nested Loops (4.62 MB)
024 SOLUTION Nested Loops (11.9 MB)
025 Loop Control (1.55 MB)
026 Break, Continue & Pass (7.06 MB)
028 Try-Except (7.79 MB)
029 DEMO Loop Control (8.95 MB)
030 ASSIGNMENT Loop Control (6.61 MB)
031 SOLUTION Loop Control (13.64 MB)
032 Key Takeaways (1.23 MB)
001 Intro to Dictionaries (2.97 MB)
002 Dictionary Overview (5.29 MB)
003 Accessing & Modifying Dictionary Values (2.6 MB)
004 DEMO Dictionary Operations (23.21 MB)
006 ASSIGNMENT Dictionary Basics (5.27 MB)
007 SOLUTION Dictionary Basics (6.41 MB)
008 ASSIGNMENT Dictionary Creation (3.28 MB)
009 SOLUTION Dictionary Creation (9.32 MB)
010 Keys & Values Methods (3.37 MB)
011 Get, Items & Update Methods (6.58 MB)
012 DEMO Dictionary Methods (18.76 MB)
013 ASSIGNMENT Dictionary Methods (7.75 MB)
014 SOLUTION Dictionary Methods (21.85 MB)
015 The Zip Function (5.04 MB)
017 ASSIGNMENT The Zip Function (5.16 MB)
018 SOLUTION The Zip Function (10.59 MB)
019 Nested Dictionaries (2.52 MB)
020 DEMO Nested Dictionaries (11.96 MB)
022 ASSIGNMENT Nested Dictionaries (5.13 MB)
023 SOLUTION Nested Dictionaries (14.16 MB)
024 Intro to Sets (3.37 MB)
025 DEMO Sets (3.7 MB)
027 ASSIGNMENT Sets (3.53 MB)
028 SOLUTIONSets (15.53 MB)
029 Set Operations (6.91 MB)
030 Set Use Cases (4.23 MB)
031 DEMO Set Operations (6.5 MB)
033 ASSIGNMENT Set Operations (3.95 MB)
034 SOLUTION Set Operations (11.63 MB)
035 Key Takeaways (2.16 MB)
001 Intro to Functions (5.53 MB)
002 Anatomy of a Function (3.19 MB)
003 Defining Functions (8.97 MB)
004 The Docstring (2.85 MB)
005 DEMO Defining a Function (7.87 MB)
007 ASSIGNMENT Defining a Function (2.49 MB)
008 SOLUTION Defining a Function (7.41 MB)
009 Argument Types (13.48 MB)
010 DEMO Argument Types (12.22 MB)
012 Return Values (5.81 MB)
013 DEMO Return Values (4.89 MB)
015 Variable Scope (7.03 MB)
016 DEMO Variable Scope (5.39 MB)
017 Creating Modules (2.99 MB)
018 Importing Modules (4.44 MB)
019 DEMO Creating & Importing Modules (11.47 MB)
020 ASSIGNMENT Creating a Module (3.25 MB)
021 SOLUTION Creating a Module (6.89 MB)
022 ASSIGNMENT Importing a Function (5.56 MB)
023 SOLUTION Importing a Function (11.66 MB)
024 Importing External Functions (7.12 MB)
025 PRO TIP Naming Conflicts (3 MB)
026 Installing & Managing Packages (8.65 MB)
027 DEMO Installing Packages (16.08 MB)
028 The Map Function (2.16 MB)
030 ASSIGNMENT The Map Function (1.4 MB)
031 SOLUTION The Map Function (3.59 MB)
032 Lambda Functions (5.52 MB)
033 DEMO Lambda Functions (2.69 MB)
035 ASSIGNMENT Lambda Functions (2.36 MB)
036 SOLUTION Lambda Functions (9.48 MB)
037 PRO TIP Comprehensions (4.38 MB)
038 DEMO List Comprehensions (6.43 MB)
040 ASSIGNMENT List Comprehensions (6.36 MB)
041 SOLUTION List Comprehensions (8.44 MB)
042 PRO TIP Dictionary Comprehensions (8.47 MB)
043 DEMO Dictionary Comprehensions (4.54 MB)
045 ASSIGNMENT Dictionary Comprehensions (9.26 MB)
046 SOLUTION Dictionary Comprehensions (26.16 MB)
047 PRO TIP Comprehensions vs Map() (8.66 MB)
048 Key Takeaways (2.91 MB)
001 The Openpyxl Package (6.37 MB)
002 Navigating Excel Workbooks, Worksheets & Cells (11.93 MB)
003 DEMO Navigating Excel Workbooks With Python (8.67 MB)
004 ASSIGNMENT Missing Sales Tax (4.63 MB)
005 SOLUTION Missing Sales Tax (12.63 MB)
006 Determining Ranges & Writing to Cells (12.41 MB)
007 DEMO Writing To Excel From Python (15.13 MB)
008 ASSIGNMENT Pound & Yen Columns (6.29 MB)
009 SOLUTION Pound & Yen Columns (29.19 MB)
010 Inserting & Deleting Columns (3.24 MB)
012 Bringing it All Together (2.53 MB)
013 Key Takeaways (3.28 MB)
001 Welcome to the Final Project! (14.01 MB)
002 SOLUTION Final Project (Part 1) (63.6 MB)
003 SOLUTION Final Project (Part 2) (47.91 MB)