Chapters

  1. 1. Introduction
    1. 1.1. Why Learn Data Analysis?
    2. 1.2. Why Learn To Code?
    3. 1.3. Why Learn Python?
    4. 1.4. About LaunchCode Programs
    5. 1.5. Blended Learning
    6. 1.6. Class Platforms
    7. 1.7. Using This Book
  2. 2. How Programs Work
    1. 2.1. Introduction
    2. 2.2. Programming Languages
    3. 2.3. The Python Language
    4. 2.4. Your First Program
  3. 3. How To Write Code
    1. 3.1. What is Code?
    2. 3.2. Syntax Rules
    3. 3.3. Comments
    4. 3.4. Output With print
    5. 3.5. Fixing Errors in Your Code
    6. 3.6. Welcome, Novice Coder
  4. 4. Terminal
    1. 4.1. What is a terminal?
    2. 4.2. Filesystem and Paths
    3. 4.3. How to Do Stuff in the Terminal
    4. 4.4. Running Programs in the Terminal
  5. 5. Data and Variables
    1. 5.1. Values and Data Types
    2. 5.2. Type Conversion
    3. 5.3. Variables
    4. 5.4. More On Variables
    5. 5.5. Expressions and Evaluation
    6. 5.6. Operations
    7. 5.7. Other Operators
    8. 5.8. Input with input()
    9. 5.9. Exercises: Data and Variables
  6. 6. Making Decisions With Conditionals
    1. 6.1. Decision Making
    2. 6.2. Data Type for True/False
    3. 6.3. Boolean Expressions
    4. 6.4. Can We Do Math with Boolean Values?
    5. 6.5. Conditionals
    6. 6.6. Logical Operators
    7. 6.7. Truth Tables
    8. 6.8. Nested Conditionals
    9. 6.9. Chained Conditionals
    10. 6.10. Exercises: Booleans and Conditionals
  7. 7. Repeating Things With Loops
    1. 7.1. Iteration
    2. 7.2. for Loops
    3. 7.3. More on range
    4. 7.4. Loops With Conditions
    5. 7.5. The Accumulator Pattern
    6. 7.6. while Loops
    7. 7.7. Infinite Loops
    8. 7.8. Ending a Loop With break
    9. 7.9. Exercises: Loops
    10. 7.10. Studio: Goal Setting and Getting into the Right Mindset
  8. 8. Stringing Characters Together
    1. 8.1. Strings as Collections
    2. 8.2. Bracket Notation
    3. 8.3. Taking a Slice
    4. 8.4. String Immutability
    5. 8.5. String Methods
    6. 8.6. Special Characters
    7. 8.7. Template Literals
    8. 8.8. Iteration with Strings
    9. 8.9. Checking Strings
    10. 8.10. The string Module
    11. 8.11. Exercises: Strings
  9. 9. Lists Keep Things in Order
    1. 9.1. List Basics
    2. 9.2. Lists Are Like Strings
    3. 9.3. Working with Lists
    4. 9.4. List Methods
    5. 9.5. Iterating Through Lists
    6. 9.6. Common List Tasks
    7. 9.7. Cloning Lists
    8. 9.8. split and join
    9. 9.9. Lists Within Lists
    10. 9.10. Exercises: Lists
    11. 9.11. Studio: Strings and Lists
  10. 10. Errors and Debugging
    1. 10.1. What is Debugging?
    2. 10.2. Types of Errors
    3. 10.3. Error Messages are Good
    4. 10.4. Fixing Logic Errors
    5. 10.5. How To Avoid Debugging
    6. 10.6. Asking Good Questions
    7. 10.7. Exercises: Errors and Debugging
    8. 10.8. Studio: Errors and Debugging
  11. 11. What’s Your Function
    1. 11.1. Introduction
    2. 11.2. Calling Functions
    3. 11.3. Defining Our Own Functions
    4. 11.4. Function Input
    5. 11.5. Function Output
    6. 11.6. A Good Function-Writing Process
    7. 11.7. Parameters and Variables
    8. 11.8. Functions Calling Other Functions
    9. 11.9. Why Create Functions?
    10. 11.10. Exercises: Functions
    11. 11.11. Studio: Functions
  12. 12. Python Dictionaries and Tuples
    1. 12.1. Dictionary Basics
    2. 12.2. Working with Dictionaries
    3. 12.3. Dictionary Methods
    4. 12.4. Iterating Through Dictionaries
    5. 12.5. Accumulator Pattern with Dictionaries
    6. 12.6. Search a Dictionary
    7. 12.7. Additional Collections in Python
    8. 12.8. Exercises: Dictionaries
    9. 12.9. Studio: Mad Dictionaries
  13. 13. Introduction To Data
    1. 13.1. Introduction To Data
    2. 13.2. Exercises: Introduction To Data
    3. 13.3. Studio: Introduction To Data
  14. 14. Exploratory Data Analysis
    1. 14.1. Exploratory Data Analysis
    2. 14.2. Exercises: Exploratory Data Analysis
    3. 14.3. Studio: Exploratory Data Analysis
  15. 15. EDA With Python Part 2
    1. 15.1. EDA With Python Part 2
    2. 15.2. Exercises: EDA With Python Part 2
    3. 15.3. Studio: EDA With Python Part 2
  16. 16. Cleaning Data
    1. 16.1. Cleaning Data
    2. 16.2. Exercises: Cleaning Data
    3. 16.3. Studio: Cleaning Data
  17. 17. Data Manipulation
    1. 17.1. Data Manipulation
    2. 17.2. Exercises: Data Manipulation
    3. 17.3. Studio: Data Manipulation
  18. 18. Data Visualization with Python
    1. 18.1. Data Visualization with Python
    2. 18.2. Exercises: Data Visualization with Python
    3. 18.3. Studio: Data Visualization with Python
  19. 19. SQL Part 1 - Introduction and Azure Data Studio
    1. 19.1. SQL Part 1 - Introduction and Azure Data Studio
    2. 19.2. Exercises: SQL Part 1 - Introduction and Azure Data Studio
    3. 19.3. Studio: SQL Part 1 - Introduction and Azure Data Studio
  20. 20. SQL Part 2 - String and Date Functions
    1. 20.1. SQL Part 2 - String and Date Functions
    2. 20.2. Exercises: SQL Part 2 - String and Date Functions
    3. 20.3. Studio: SQL Part 2 - String and Date Functions
  21. 21. SQL Part 3 - Joins
    1. 21.1. SQL Part 3 - Joins
    2. 21.2. Exercises: SQL Part 3 - Joins
    3. 21.3. Studio: SQL Part 3 - Joins
  22. 22. SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
    1. 22.1. SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
    2. 22.2. Exercises: SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
    3. 22.3. Studio: SQL Part 4 - Subqueries, UNION, INTERSECT, EXCEPT
  23. 23. SQL Part 5 - Schemas and CRUD Operations
    1. 23.1. SQL Part 5 - Schemas and CRUD Operations
    2. 23.2. Exercises: SQL Part 5 - Schemas and CRUD Operations
    3. 23.3. Studio: SQL Part 5 - Schemas and CRUD Operations
  24. 24. Working with Databases in Python
    1. 24.1. Working with Databases in Python
    2. 24.2. Exercises: Working with Databases in Python
    3. 24.3. Studio: Working with Databases in Python
  25. 25. Tableau Part 1 - Introduction to Visualization
    1. 25.1. Viz Of The Day
    2. 25.2. Tableau Part 1 - Introduction to Visualization
    3. 25.3. Exercises: Tableau Part 1 - Introduction to Visualization
    4. 25.4. Studio: Tableau Part 1 - Introduction to Visualization
  26. 26. Tableau Part 2 - Data Preparation
    1. 26.1. Tableau Part 2 - Data Preparation
    2. 26.2. Exercises: Tableau Part 2 - Data Preparation
    3. 26.3. Studio: Tableau Part 2 - Data Preparation
  27. 27. Tableau Part 3 - Dashboard Finesse, Calculations and Parameters
    1. 27.1. Tableau Part 3 - Dashboard Finesse, Calculations and Parameters
    2. 27.2. Exercises: Tableau Part 3 - Dashboard Finesse, Calculations and Parameters
    3. 27.3. Studio: Tableau Part 3 - Dashboard Finesse, Calculations and Parameters
  28. 28. Tableau Part 4 - Stories and Dates
    1. 28.1. Tableau Part 4 - Stories and Dates
    2. 28.2. Exercises: Tableau Part 4 - Stories and Dates
    3. 28.3. Studio: Tableau Part 4 - Stories and Dates
  29. 29. Introduction to Statistics and Data Modeling
    1. 29.1. Introduction to Statistics and Data Modeling
    2. 29.2. Exercises: Introduction to Statistics and Data Modeling
    3. 29.3. Studio: Introduction to Statistics and Data Modeling
  30. 30. Data Modeling Part 2: Linear Regression
    1. 30.1. Data Modeling Part 2: Linear Regression
    2. 30.2. Exercises: Data Modeling Part 2: Linear Regression
    3. 30.3. Studio: Data Modeling Part 2: Linear Regression