How to Set index_col in read_csv in pandas

Use the index_col parameter in pandas.read_csv() to specify which column(s) should be used as the row labels (index) of the DataFrame. You can pass a single column name, column number, or a list of them to set one or multiple index columns.

Syntax

The index_col parameter in pandas.read_csv() lets you choose which column(s) become the DataFrame index. It accepts:

• int: Column number starting at 0
• str: Column name
• list of int or str: Multiple columns as a multi-index
• None (default): No column is used as index

python

pandas.read_csv(filepath_or_buffer, index_col=None, ...)

# Examples:
# Use first column as index
pandas.read_csv('file.csv', index_col=0)

# Use column named 'ID' as index
pandas.read_csv('file.csv', index_col='ID')

# Use multiple columns as multi-index
pandas.read_csv('file.csv', index_col=['Year', 'Month'])

Example

This example shows how to load a CSV file and set the 'Name' column as the index using index_col. The output is a DataFrame with 'Name' as the row labels.

python

import pandas as pd
from io import StringIO

csv_data = '''
Name,Age,City
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago
'''

# Use StringIO to simulate reading from a file
file_like = StringIO(csv_data)

# Read CSV and set 'Name' column as index
df = pd.read_csv(file_like, index_col='Name')
print(df)

Output

         Age         City
Name                      
Alice     30     New York
Bob       25  Los Angeles
Charlie   35      Chicago

Common Pitfalls

Common mistakes when using index_col include:

• Passing a column number that does not exist causes an error.
• Using a column name that is misspelled or missing results in a KeyError.
• For multi-index, passing a single string instead of a list for multiple columns.
• Not setting index_col when you want to use a column as index, leading to default numeric index.

Always check your CSV columns and use the correct names or positions.

python

import pandas as pd
from io import StringIO

csv_data = '''
ID,Value
1,100
2,200
'''

file_like = StringIO(csv_data)

# Wrong: column 'id' does not exist (case sensitive)
# pd.read_csv(file_like, index_col='id')  # Raises KeyError

file_like.seek(0)  # Reset file pointer

# Correct: use 'ID' exactly
correct_df = pd.read_csv(file_like, index_col='ID')
print(correct_df)

Output

     Value
ID         
1      100
2      200

Quick Reference

Parameter	Description	Example
index_col=None	Default, no column used as index	pd.read_csv('file.csv')
index_col=0	Use first column as index	pd.read_csv('file.csv', index_col=0)
index_col='Name'	Use column named 'Name' as index	pd.read_csv('file.csv', index_col='Name')
index_col=['Year','Month']	Use multiple columns as multi-index	pd.read_csv('file.csv', index_col=['Year','Month'])

Key Takeaways

Use the index_col parameter in read_csv to set one or more columns as the DataFrame index.

index_col accepts column names (strings), column positions (integers), or lists of them for multi-index.

Make sure the column names or positions you use exist in the CSV to avoid errors.

Setting index_col helps organize data by meaningful row labels instead of default numbers.

For multiple index columns, pass a list of column names or positions to index_col.