Volume 1: Data Handling using Pandas & Visualization

CBSE Examination Unit 1 • Weightage: 25 Marks (Highest Weightage Unit)

“Data is the new oil, but unindexed data is crude. Pandas gives you the refinery.”

---

Unit Overview & Architectural Blueprint

In the CBSE Class 12 Information Practices (Code 065) curriculum, Unit 1: Data Handling using Pandas and Data Visualization represents the core programming component, carrying 25 out of 70 theory marks.

This volume systematically covers the complete data analysis and visualization pipeline:

graph LR
    A[Raw Data Sources<br/>ndarray / Dict / CSV] --> B[1D Pandas Series]
    A --> C[2D Pandas DataFrame]
    B --> D[Vectorized Operations & Index Alignment]
    C --> E[loc / iloc Slicing & Boolean Filtering]
    C --> F[Descriptive Stats & GroupBy]
    E --> G[Matplotlib Pyplot]
    F --> G
    G --> H[Line / Bar / Histogram Visuals]

---

Complete Chapter Navigation

Chapter 1

Python Pandas Series Fundamentals

1D labeled homogeneous array structure. Creation from ndarray, dictionary, and scalar values. Mathematical operations, vectorization, index alignment, NaN handling, and head/tail methods.

Read Chapter 1 →

Chapter 2

DataFrame Operations, Indexing & Slicing

2D labeled heterogeneous tabular structure. Creation from dictionaries, lists of dicts, and Series. Column/row addition, deletion, renaming, iteration (iterrows), and loc vs iloc slicing.

Read Chapter 2 →

Chapter 3

Descriptive Stats, GroupBy & CSV I/O

Summary statistics (mean, median, mode, std, var, quantile), GroupBy aggregation, sorting by index/values, missing data management (isna, dropna, fillna), and CSV file read/write.

Read Chapter 3 →

Chapter 4

Data Visualization with Matplotlib Pyplot

Plotting line charts, vertical/horizontal bar graphs, side-by-side multiple bars, and histograms. Customizations: titles, axis labels, legends, grid lines, colors, line styles, and saving figures.

Read Chapter 4 →

---

Interactive Topic Visualizer

Multi-Mode DiagramPandas DataFrame: 2D Heterogeneous Tabular Data Structure & loc/iloc Slicing

Option 1: Publication-Grade Scientific Vector SVG

Two-dimensional tabular data structure with labeled axes (index rows and columns). Illustrating explicit label indexing (loc[row_label, col_label]) vs zero-based integer position indexing (iloc[row_pos, col_pos]).

loc (Label-based Slicing, Both Ends Included): $\text{df.loc[start\_label : end\_label, [\text{col1}, \text{col2}]]}$

iloc (Position-based Slicing, End Excluded): $\text{df.iloc[start\_pos : end\_pos, start\_col : end\_col]}$

Option 2: Interactive 60 FPS Canvas Physics Engine

Interactive loc / iloc row and column selector simulator.

Row Index Pos (0-2): 1

iloc Syntax ($\text{df.iloc}[1]$):Rohan

loc Syntax ($\text{df.loc}[\text{'R102'}]$):Rohan

Option 3: Interactive 3D Spatial Viewport

3D Matrix block representation of DataFrame Series columns.

+X

+Y

+Z

👆 Click and drag anywhere to rotate in 3D space

Azimuth Angle (ψ):35°

Elevation Angle (θ):-22°

DataFrame Column Extraction Rule:$\text{df[col]} \rightarrow \text{Series (1D)}, \quad \text{df[[cols]]} \rightarrow \text{DataFrame (2D)}$

Option 5: Reactive Parametric Physics with Live Calculus

Interactive Series boolean filtering & math calculator.

Score Cutoff: 90

Bonus Marks: 2

Qualifying Count ($\text{count}(s \ge 90)$):$2 / 3 Students$

Active Mode:Option 1 (Print & Derivation Vector SVG)Switch modes using the tabs above to explore different visualizations.

---

Unit 1 Board Exam Checklist (25 Marks)

• [ ] Can you distinguish between loc (label-based, both endpoints included) and iloc (positional, stop excluded)?
• [ ] Do you know what happens when two Series with mismatched indices are added (automatic alignment with NaN)?
• [ ] Can you write code to create side-by-side multiple bar charts using offset x coordinates?
• [ ] Can you filter missing data using df.dropna(how='all') vs df.dropna(how='any')?
• [ ] Do you know the exact syntax for pd.read_csv() and df.to_csv()?