Skip to main content

Introduction to pandas 🐼

Mentor's Note: Before pandas, analysing data in Python meant writing hundreds of lines. pandas collapsed that to five. Once you understand what it does, you'll wonder how anyone worked without it. 💡

What You'll Learn

By the end of this tutorial, you'll know:

  • What pandas is and why it exists (not just "it's a library")
  • How to install pandas and import it correctly — including the pd alias
  • How to create your first DataFrame from a Python dictionary
  • When to use pandas instead of plain Python lists

🌟 The Scenario: The Excel Superpower​

Your school has just handed you a spreadsheet with 10,000 student records — names, marks, attendance, and city. Finding the class average in Excel takes a few clicks and a formula. But what if you need to:

  • Find the average marks for students only from Surat?
  • Identify who scored below 35 in more than two subjects?
  • Export a cleaned version without absent students?

With pandas, all three are fewer than 10 lines of Python. That's why every data analyst, data scientist, and CBSE Class 12 student learns pandas.

📖 Concept Explanation​

1. What is pandas?​

pandas is a Python library for data manipulation and analysis. It provides two core data structures:

  • Series — a labelled 1D array (like a single column from a spreadsheet)
  • DataFrame — a labelled 2D table (like an entire spreadsheet)

It was created by Wes McKinney in 2008 and is built on top of NumPy.

2. Why use pandas over plain Python lists?​

FeaturePython Listpandas
Column labels❌ No✅ Yes
Filter rows by conditionVerbose loopdf[df['marks'] > 80]
Handle missing dataManualBuilt-in dropna(), fillna()
Read CSV in one lineNeeds csv modulepd.read_csv('file.csv')
Statistical summariesManualdf.describe()

3. Where is pandas used?​

  • CBSE Class 12 Python practical exams
  • Finance and banking (stock analysis, risk models)
  • Government data portals and journalism
  • Machine learning pipelines (data preprocessing)

🎨 Visual Logic​

💻 Implementation​

Run this in your terminal (not inside Python):

pip install pandas
# Recommended: install NumPy alongside it
pip install pandas numpy

Verify installation:

pip show pandas

🎯 Practice Lab 🧪​

Task: Your First pandas Program
  1. Install pandas in your Python environment.
  2. Import it and print its version.
  3. Create a dictionary with 3 student names and their ages.
  4. Convert it to a DataFrame and print it.
  5. Print the average age using .mean().

Hint: The column name for ages is just a dictionary key. Access it with df['age'].

❓ Frequently Asked Questions​

Q: Why do we write import pandas as pd and not just import pandas?

You can write import pandas — it works. But then every method call becomes pandas.DataFrame(...), pandas.read_csv(...), etc. The alias pd is the universal shorthand used in every textbook, job interview, Stack Overflow answer, and CBSE exam. If you use pandas instead of pd, your code will confuse other developers immediately.

Q: What's the difference between a Series and a DataFrame?

A Series is one column — a 1D labelled array. A DataFrame is a full table — multiple Series sharing the same index. Think of a Series as one column from a spreadsheet, and a DataFrame as the entire sheet.

Q: Does pandas work without NumPy?

No. pandas is built on top of NumPy and requires it. When you pip install pandas, NumPy is installed automatically as a dependency. You don't need to install it separately, but many data science workflows import both.

Q: CBSE exam — what is the standard import statement for pandas?

import pandas as pd — this exact line is expected in CBSE Class 12 practical exams. Using any other alias will be marked incorrect in most board examinations.

✅ Summary​

In this tutorial, you've learned:

  • ✅ pandas is a Python library built on NumPy for data manipulation — it gives your data a labelled table structure
  • ✅ The two core structures are Series (1D) and DataFrame (2D)
  • ✅ import pandas as pd is the industry standard — use pd, not pandas
  • ✅ You can create a DataFrame from a dictionary in one line with pd.DataFrame(data)
  • ✅ Use pandas when you need column labels, filtering by condition, or built-in statistics like .mean()

💡 Interview & Exam Tips​

Q: What is the standard alias for importing pandas?

import pandas as pd — always use pd. CBSE exams and every industry tutorial expect this exact alias.

Q: What are the two main data structures in pandas?

Series (1D labelled array) and DataFrame (2D labelled table). A DataFrame is a collection of Series sharing the same index.

Q: Who created pandas and in which year?

Wes McKinney, 2008. He created it while working at AQR Capital Management to solve financial data analysis problems.

Q: Which library is pandas built on top of?

NumPy. pandas arrays are backed by NumPy arrays, which is why NumPy operations are so fast inside pandas.

📚 Further Reading​

Continue your learning path:

Go deeper:

🔗 Related Topics​