TIP
  • Home
  • Posts
  • About
Categories
All (18)
aggregation (2)
categorical-data (1)
concat (1)
data manipulation (1)
data-cleaning (1)
data-manipulation (2)
data-transformation (1)
data-visualisation (1)
dataframe (15)
filtering (1)
functions (1)
group-by (1)
matplotlib (1)
merge (1)
multi-index (1)
pandas (18)
preprocessing (1)
python (1)
querying (1)
Series (1)
temporal-data (1)
text-manipulation (1)
time-series (2)
transformation (1)
visualization (1)

Pandas for Data Science

Data manipulation and analysis with Python’s Pandas library

Topics Covered

  • DataFrames and Series - Core data structures and creation
  • Data Loading - Reading CSV, Excel, JSON, and databases
  • Data Cleaning - Handling missing values and duplicates
  • Data Selection - Indexing, filtering, and querying data
  • Data Transformation - Grouping, aggregation, and pivot tables
  • Time Series - Working with dates and time-based data
  • Data Visualization - Basic plotting with Pandas
  • Performance Tips - Optimizing operations for large datasets

Learning Path

  1. Start with basic DataFrame operations
  2. Learn data loading and inspection techniques
  3. Master data cleaning and preprocessing
  4. Explore advanced transformations and analysis
  5. Practice with real-world datasets

Available Notebooks

Data Viz with pandas tools
pandas
dataframe
data-visualisation

Quick examples of plotting with pandas and matplotlib (line, bar, scatter) and visualization best practices.

Sep 23, 2025
Working with MultiIndex DataFrames
pandas
dataframe
multi-index

Guide to creating, inspecting, and working with MultiIndex DataFrames in pandas, including integration with NumPy.

Sep 23, 2025
Text Manipulation Methods in pandas
pandas
dataframe
text-manipulation

Comprehensive guide to string methods in pandas for text data manipulation, including case conversion, searching, regex, and splitting.

Sep 23, 2025
Advanced Data Manipulation (apply, map, applymap)
pandas
dataframe
transformation

Overview of apply, map, and applymap for advanced DataFrame/Series transformations.

Sep 21, 2025
Advanced Data Aggregation with Pandas Functions
pandas
dataframe
aggregation
functions

Master advanced data aggregation techniques in Pandas using built-in functions, custom functions, and lambda expressions. Learn to create powerful summary statistics and…

Sep 21, 2025
Group By Operations in Pandas
pandas
dataframe
group-by
aggregation

Master Pandas groupby operations: splitting data by categories, applying functions, and combining results. Learn aggregation, transformation, and filtering techniques for…

Sep 21, 2025
Handling Categorical Data with Pandas
pandas
dataframe
categorical-data
data-transformation

Comprehensive guide to handling categorical data in Pandas, including encoding techniques, grouping operations, and data reshaping methods like melt and pivot.

Sep 21, 2025
Handling Temporal Data with Pandas
pandas
dataframe
temporal-data
time-series

Master temporal data handling in Pandas: datetime conversion, time series operations, resampling, shifting, and date range generation for effective time-based data analysis.

Sep 21, 2025
Time Series Visualization with Pandas
pandas
dataframe
time-series
visualization
matplotlib

Learn to create compelling time series visualizations using Pandas and Matplotlib. Master line plots, area plots, and customization techniques for effective temporal data…

Sep 21, 2025
Combining and Merging DataFrames with Pandas
pandas
dataframe
merge
concat
data-manipulation

Learn how to combine and merge Pandas DataFrames using concat() and merge(). This guide covers row-wise and column-wise concatenation, and database-style joins.

Sep 19, 2025
Data Cleaning with Pandas
pandas
data-cleaning
preprocessing

A comprehensive guide to handling duplicates and outliers in Pandas DataFrames, with practical examples and best practices.

Sep 19, 2025
Pandas: Advanced Techniques for Conditional Filtering and Querying
pandas
dataframe
filtering
querying
data-manipulation

Master advanced pandas techniques for conditional filtering, boolean indexing, query methods, sorting, and ranking data. Learn efficient data manipulation strategies with…

Sep 18, 2025
Data Manipulation with loc and iloc
python
pandas
data manipulation

This notebook demonstrates how to select rows and columns in a Pandas DataFrame using .loc and .iloc. Each section explains a different selection technique.

Sep 18, 2025
Pandas: Dealing with missing Datas
pandas
dataframe

This notebook demonstrates how to handle missing data in Pandas DataFrames. Each section below explains a different operation or concept.

Sep 16, 2025
Pandas: Intro to DataFrames
pandas
dataframe

Understanding basics of Pandas DataFrames, a core data structure for data analysis in Python.

Sep 16, 2025
Pandas: Intro to Series
pandas
Series

This notebook covers the Pandas Series object, which is a one-dimensional labeled array.

Sep 16, 2025
Pandas: DataFrame Operation
pandas
dataframe

Understanding various DataFrame options provided by the pandas lib

Sep 16, 2025
Pandas: Data Loading
pandas
dataframe

Understanding how to use the Pandas library to load data from CSV and Excel files.

Sep 16, 2025
No matching items