The Library · Insights
Deep dives across data, automation & AI
53 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
PythonFoundation
Cleaning Messy Data with pandas: Missing Values, Duplicates, and Data Types
Real-world data is broken — currency strings, mixed date formats, duplicated rows, and missing values in five different forms. This hands-on lesson walks you through building a systematic, reusable cleaning pipeline in pandas that you can apply to any messy dataset.
19 min read
PythonFoundation
Selecting and Filtering Data in pandas: loc, iloc, and Boolean Masks
Learn the three essential tools for pulling exactly the data you need from a pandas DataFrame: loc for label-based access, iloc for position-based access, and boolean masks for filtering by condition. By the end, you'll be combining multiple conditions and selecting specific rows and columns with confidence.
14 min read
PythonFoundation
Your First pandas DataFrame: Loading CSV and Excel Files and Exploring Data
Loading data into pandas is more nuanced than calling pd.read_csv() and hoping for the best. This lesson teaches you exactly how to load CSV and Excel files with precision — handling messy headers, wrong dtypes, and missing values — then gives you a professional first-look exploration workflow to audit any dataset before you touch it.
26 min read
PythonFoundation
Python Basics for Excel Users: Variables, Lists, Dictionaries, and Loops
Already know Excel? You're closer to Python than you think. This hands-on lesson translates your spreadsheet intuition into Python fundamentals — variables, lists, dictionaries, and loops — using realistic data scenarios you'll actually encounter on the job.
20 min read
PythonFoundation
Setting Up Python for Data Analysis: Python, VS Code, Jupyter, and Virtual Environments
Getting your Python environment wrong is the fastest way to kill your momentum before you write a single line of analysis code. This lesson walks you through installing Python, VS Code, and Jupyter correctly — and shows you why virtual environments are the professional habit that saves hours of future frustration.
17 min read