Results for "excel"
6 / 18 posts
Filter by Category
Pandas for Python Developers: The Complete Guide (Part 1 — Fundamentals)
Meta Description: Master Pandas from scratch. Learn Series, DataFrames, I/O operations, and essential data manipulation with real-world examples. The only gu...
Excel formulas
Function What it Counts Syntax Example Range Output Example COUNT Only numeric data =COUNT(range) A1(e.g. 1, "Text", 3, "", 5) =COUNT(A1:A5) → 3 (counts 1,…
Pandas Data Manipulation: The Complete Guide (Part 2 — Indexing, GroupBy, Merge & Reshape)
Master Pandas data manipulation — loc/iloc, boolean filtering, GroupBy, merge/join, pivot tables, melt, string ops, and apply functions with real examples.
Advanced Pandas: Performance, Time Series, ML Pipelines & Interview Questions (Part 3)
Master advanced Pandas — MultiIndex, time series resampling, rolling windows, memory optimization, Pandas 2.x features, ML pipelines, and 30+ interview Q&A.
Categorical Data Handling in Machine Learning (Pandas + Sklearn) – Complete Practical Guide
Learn categorical data encoding end-to-end — Label, Ordinal, One-Hot, Target, Binary, Frequency encoding with Pandas & Sklearn. Beginner to advanced.
Python List, Tuple, Set & Dictionary: The Ultimate Complete Guide
Master Python's four core data structures — List, Tuple, Set, and Dictionary — with real examples, methods, performance tips, and interview questions.