Appendix A. Setting Up Your Environment

This appendix provides the practical setup needed to work through the book’s examples without interruption. It introduces the core toolkit—Python, Jupyter Lab, PostgreSQL, an OpenAI account, and a few free data APIs—and explains that you do not need to install everything at once. Instead, the recommended approach is to get the basics in place first, then add extra tools as later chapters require them, with the companion repository supplying the book’s code, notebooks, sample data, and setup files.

The foundation of the workflow is a clean Python installation paired with a virtual environment, which keeps the book’s packages isolated from the rest of your system. After cloning the repository, readers install the shared dependencies and use Jupyter Lab as the main notebook interface for running examples. The appendix also introduces several AI coding companion options—such as ChatGPT, Cursor, Windsurf, and GitHub Copilot—while noting that the early chapters keep the assistant separate from the execution environment so learners can better understand how prompts become code.

Later sections focus on access and safety for external services. Readers create an OpenAI API key, install the current OpenAI Python SDK, and verify that the client can list models by reading the key from environment variables. The appendix also covers PostgreSQL and pgAdmin for SQL and pipeline work, including an optional Docker-based setup and loading the Pagila sample database. Finally, it explains how to manage secrets with environment variables or .env files, where to obtain NewsAPI and SerpAPI keys when needed, and how to run a quick smoke test to confirm that Python, libraries, notebooks, and credentials are all working properly.

FAQ