Setting, Resetting & Managing Indices0%
Detecting Missing Values (isna, notna, isnull)

Setting, Resetting & Managing Indices

Beginner12 min read•Updated: Jul 11, 2026
Study MaterialsCheatsheet

Setting, Resetting & Managing Indices

Reading Time: 8 Mins | Level: Beginner to Advanced

1. What is the DataFrame Index?

The Index is the backbone of relational alignment in Pandas. It provides unique labels that identify each row, enabling instant lookups, joins, and time-series resampling.

By default, when creating or loading a DataFrame, Pandas assigns a default zero-indexed integer range: RangeIndex(0, 1, 2, ...).

2. Setting an Existing Column as the Index (set_index)

When a column contains unique identifiers (like Employee_ID, Roll_No, or Timestamp), promoting it to the Index provides faster query speeds and cleaner semantics:

Python
import pandas as pd
 
df = pd.DataFrame({
'Emp_ID': ['E101', 'E102', 'E103', 'E104'],
'Name': ['Amit', 'Sunita', 'Karan', 'Pooja'],
'Department': ['Sales', 'IT', 'Finance', 'HR']
})
 
# Promote 'Emp_ID' to be the Index
df_indexed = df.set_index('Emp_ID')
print(df_indexed)

Output:

Output
Name Department
Emp_ID
E101 Amit Sales
E102 Sunita IT
E103 Karan Finance
E104 Pooja HR

Now row lookups by employee ID are immediate:

Python
employee_record = df_indexed.loc['E102']

3. Resetting the Index (reset_index)

After filtering, sorting, or grouping, the index labels may become jumbled or discontinuous (e.g., rows 3, 7, 12). reset_index() restores a clean 0, 1, 2, ... index:

Python
# Revert 'Emp_ID' back to a normal column and restore integer range index
df_restored = df_indexed.reset_index()
print(df_restored)

Discarding the Old Index (drop=True)

If you filter rows and do not want the old index saved as a new column:

Python
df_filtered = df[df['Department'] == 'IT']
# Reset index without keeping the old index column
df_clean = df_filtered.reset_index(drop=True)

4. MultiIndex (Hierarchical Indexing)

Pandas allows DataFrames to have multiple index levels, enabling high-dimensional data representation in a 2D table:

Python
df_multi = df.set_index(['Department', 'Emp_ID'])
print(df_multi)
Interactive Quiz

Multiple Choice Questions

Question 1
What does the df.set_index('Customer_ID') method do?
Question 2
What happens if you run df.reset_index(drop=True)?
Question 3
What is the default index type created when a DataFrame is initialized without specifying an index?
Question 4
Which parameter can be passed to df.set_index('col', inplace=True) to modify the original DataFrame directly?
Question 5
Can a DataFrame have multiple columns forming a composite, multi-level index?
Next Lesson

Detecting Missing Values (isna, notna, isnull)

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous LessonNext Lesson
Boolean Indexing & DataFrame QueryingDetecting Missing Values (isna, notna, isnull)

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

PreviousNext
PrevNext