Applied Data Science: Techniques and Implementation
Chapter 1: Advanced Data Acquisition and Preparation
Connecting to Databases and Data Warehouses
Working with Web APIs for Data Retrieval
Techniques for Web Scraping Structured Data
Advanced Data Cleaning Methods
Strategies for Handling Missing Values
Data Transformation and Normalization Techniques
Merging and Joining Diverse Datasets
Hands-on: Data Acquisition and Wrangling Practice
Quiz for Chapter 1
Chapter 2: Practical Feature Engineering
Generating Features from Numerical Data
Encoding Categorical Variables Effectively
Creating Features from Text Data
Interaction Terms and Polynomial Features
Dimensionality Reduction with PCA
Selecting Features using Statistical Methods
Hands-on: Feature Creation and Selection
Quiz for Chapter 2
Chapter 3: Building and Tuning Predictive Models
Review of Common Supervised Learning Algorithms
Implementing Linear and Logistic Regression
Applying Tree-Based Models
Introduction to Gradient Boosting Machines
Hyperparameter Tuning using Grid Search and Randomized Search
Model Evaluation of Accuracy
Cross-Validation Strategies
Hands-on: Model Training and Hyperparameter Optimization
Quiz for Chapter 3
Chapter 4: Applied Unsupervised Learning
Understanding Clustering Concepts
Implementing K-Means Clustering
Applying DBSCAN for Density-Based Clustering
Introduction to Anomaly Detection Methods
Dimensionality Reduction for Visualization
Hands-on: Clustering and Anomaly Detection Practice
Quiz for Chapter 4
Chapter 5: Model Deployment Fundamentals
Saving and Loading Trained Models
Introduction to Model Serving Frameworks
Building a REST API for Model Prediction
Containerizing Applications with Docker
Basic Model Monitoring Concepts
Hands-on: Creating and Containerizing a Model API
Quiz for Chapter 5
Connecting to Databases and Data Warehouses
Was this section helpful?
- SQLAlchemy 2.0 Documentation - Unified Tutorial, The SQLAlchemy Project, 2025 - Provides comprehensive documentation for SQLAlchemy, including its core components, engine creation, and connection management, which are fundamental for database interaction in Python.
- pandas.read_sql, The pandas development team, 2024 - Official documentation for the pandas.read_sql function, demonstrating how to execute SQL queries and load results directly into a Pandas DataFrame.
- PEP 249 -- Python Database API Specification v2.0, Marc-André Lemburg, 1999 - Defines the standard interface for Python database drivers, explaining the underlying mechanisms by which libraries like psycopg2 and mysql.connector operate.