Pandas for Class 12 IP: The 25 Marks Most Students Underprepare
Data Handling using Pandas carries 25 of the 70 theory marks in CBSE Class 12 Informatics Practices, the joint-largest block alongside SQL. Most questions ask you to predict output rather than define a term, so reading about dataframes does not prepare you. Writing and running small snippets weekly does.
Why this block decides your grade
Pandas and SQL together are 50 of the 70 theory marks. Get both fluent and the paper is largely done; leave either late and no amount of societal-impacts revision compensates.
What is actually examined
- Series and DataFrame creation, and the difference between them
- Selecting rows and columns, including
locandiloc - Adding, modifying and deleting rows and columns
- Head, tail and basic descriptive functions
- Handling missing data
- Importing and exporting CSV files
- Simple plotting with Matplotlib
The question type that catches people
Output prediction. You are shown four lines of Pandas and asked what prints. Knowing what a dataframe is tells you nothing about what a particular slice returns.
The specific traps that repeat: confusing loc (label-based) with iloc (position-based); forgetting that slicing with loc includes the end label while iloc does not; and assuming an operation changes the dataframe when it returns a copy.
How to practise properly
- Five snippets a week, written and run, from Class 11 onwards.
- Predict the output before running, then compare. The gap between your guess and reality is your revision list.
- Keep one CSV of your own and query it all year, so the data is familiar and the syntax is what varies.
- Do previous years' Pandas questions in one sitting; the repetition is obvious quickly.
Don't skip the practical
The 30 practical marks include Pandas work. CBSE expects a minimum of 15 Pandas programs, 4 Matplotlib programs and 15 SQL queries in the practical file, so the file itself is a revision plan if you start it early.