Books & Videos

Table of Contents

  1. Chapter 1 Python Basics

    1. How to Create a Python Script

    2. How to Run a Python Script

    3. Useful Tips for Interacting with the Command Line

    4. Python’s Basic Building Blocks

    5. Reading a Text File

    6. Reading Multiple Text Files with glob

    7. Writing to a Text File

    8. print Statements

    9. Chapter Exercises

  2. Chapter 2 Comma-Separated Values (CSV) Files

    1. Base Python Versus pandas

    2. Filter for Specific Rows

    3. Select Specific Columns

    4. Select Contiguous Rows

    5. Add a Header Row

    6. Reading Multiple CSV Files

    7. Concatenate Data from Multiple Files

    8. Sum and Average a Set of Values per File

    9. Chapter Exercises

  3. Chapter 3 Excel Files

    1. Introspecting an Excel Workbook

    2. Processing a Single Worksheet

    3. Reading All Worksheets in a Workbook

    4. Reading a Set of Worksheets in an Excel Workbook

    5. Processing Multiple Workbooks

    6. Chapter Exercises

  4. Chapter 4 Databases

    1. Python’s Built-in sqlite3 Module

    2. MySQL Database

    3. Chapter Exercises

  5. Chapter 5 Applications

    1. Find a Set of Items in a Large Collection of Files

    2. Calculate a Statistic for Any Number of Categories from Data in a CSV File

    3. Calculate Statistics for Any Number of Categories from Data in a Text File

    4. Chapter Exercises

  6. Chapter 6 Figures and Plots

    1. matplotlib

    2. pandas

    3. ggplot

    4. seaborn

  7. Chapter 7 Descriptive Statistics and Modeling

    1. Datasets

    2. Wine Quality

    3. Customer Churn

  8. Chapter 8 Scheduling Scripts to Run Automatically

    1. Task Scheduler (Windows)

    2. The cron Utility (macOS and Unix)

  9. Chapter 9 Where to Go from Here

    1. Additional Standard Library Modules and Built-in Functions

    2. Python Package Index (PyPI): Additional Add-in Modules

    3. Additional Data Structures

    4. Where to Go from Here

  10. Appendix Download Instructions

    1. Download Python 3

    2. Download the xlrd Package

    3. Download the MySQL Database Server

    4. Download mysqlclient (Python 3.x)/MySQL-python (Python 2.x)

  11. Appendix Answers to Exercises

    1. Chapter 1