AI Tool:
Lists:
Tuples:
Sets:
Dictionaries:
AI Tool:
Text File Operations:
Working with CSV Files:
Working with JSON:
AI Tool:
AI Tools:
Standard libraries: os, random, math, functools, etc.
Data manipulation with Pandas
Data Visualization:
AI Tools:
AI Tools:
AI Tools:
Topics
Practical: Analyze several real-world problems and identify:
Topics
Practical: Create a workflow for a real-world problem such as:
Topics
Practical
Topics
Practical
Topics
Practical
Topics
Practical
Topics
Practical: Query a sample database containing customers, products, and orders. Additionally, filter results using pattern matching (LIKE) and handle NULL values correctly.
Topics
Practical: Answer questions such as:
Topics
Practical: Combine customer, order, and product information to create an analytical dataset. Additionally, use UNION to merge results from multiple queries into one multi-source report.
Topics
Practical: Create a complete SQL analysis of a business dataset. Additionally, load the exported query results into a Python notebook using pandas.read_sql for further analysis.
Topics
Practical: Design a simple ETL workflow diagram for a real-world business scenario, such as e-commerce orders, hospital records, or banking transactions.
Topics
Practical: Write a script that ingests data from a public API and merges it with a local file-based dataset.
Topics
Practical: Design a simple star schema for a sales or business dataset and outline a scheduled refresh with basic quality checks.
Topics
Practical: Clean a messy real-world dataset. Additionally, use regular expressions to standardize inconsistent text values in the dataset.
Topics
Practical: Prepare a dataset for machine learning. Additionally, compare model-ready features created with different scaling and encoding methods.
Topics
Practical: Perform structured EDA using a real dataset. Additionally, generate an automated EDA report using a tool such as ydata-profiling or Sweetviz and compare it with the manual analysis.
Topics
Practical: Create visualizations for:
Topics
Practical: Convert an exploratory analysis into a structured data story:
Topics
Practical: Complete an EDA project using a dataset from:
Topics
Practical: Identify the correct machine learning problem type for different scenarios. Additionally, explore the scikit-learn estimator API (fit, predict, score) using a simple toy dataset.
Topics
Practical: Build a model to predict:
Topics
Practical: Compare multiple regression models and identify overfitting. Additionally, plot learning curves for at least one model to diagnose bias and variance.
Topics
Practical: Build a classification model for:
Topics
Practical:Train and compare Decision Tree and Random Forest models. Additionally, train a Gradient Boosting model and compare its performance with the Random Forest model.
Topics
Practical: Train a KNN or SVM classifier and compare its performance with Logistic Regression. Additionally, visualize the decision boundaries produced by the KNN and SVM models.
Topics
Practical: Evaluate a classification model on an imbalanced dataset. Additionally, plot ROC and Precision-Recall curves to compare model performance.
Topics
Practical: Build a complete preprocessing and modeling pipeline. Additionally, save the trained pipeline to disk using joblib and reload it to confirm it works correctly.
Topics
Practical: Tune a Random Forest, SVM, or another selected model. Additionally, compare the runtime and results of Grid Search and Randomized Search on the same model.
Topics
Practical: Perform customer segmentation or another clustering task. Additionally, compare the K-Means results with a hierarchical clustering solution on the same dataset.
Topics
Practical: Use an LLM to assist with:
Topics
Practical: Create prompts for:
Topics
Practical: Complete an AI-assisted data analysis workflow and verify every important result. Additionally, use an AI coding assistant to speed up one part of the workflow, then review and correct its output.
Topics
Practical: Create a simple interactive dashboard. Additionally, sketch a simple wireframe of the planned capstone application before building it.
Topics
Practical: Build a dashboard or prediction interface. Additionally, add caching to the application to improve data-loading performance.