Read CSV File without Unnamed Index Column in Python

Whenever the user creates the data frame in Pandas, the Unnamed index column is by default added to the data frame. The article aims to demonstrate how to read CSV File without Unnamed Index Column using index_col=0 while reading CSV.

Read CSV File without Unnamed Index Column Using index_col=0 while reading CSV

The way of explicitly specifying which column to make as the index to the read_csv() function is known as the index_col attribute. This method is useful if you have created the dataset in Pandas and have stored that in a CSV file. Then, while importing that CSV file back in Pandas, you can use this method, with syntax:

df=pd.read_csv(csv_file ,index_col=0)

In this method, we will use the Pandas data frame with three columns, name, subject and fees, Dataset link. On uploading this Pandas data frame in CSV, it by defaults shows an unnamed column in the dataset. The original data is:

Python3

import pandas as pd

# Read the CSV file into a DataFrame
df = pd.read_csv("student_data.csv")

# Display the DataFrame
print(df)

Output:

   Unnamed: 0     name         subject   fees
0           0     Arun           Maths   9000
1           1   Aniket  Social Science  12000
2           2   Ishits         English  15000
3           3  Pranjal         Science  18000
4           4  Vinayak        Computer  18000

Now, let’s see how to remove that unnamed column by using index_col attribute of read_csv function.

Python3

# Read the CSV file removing unnamed columns
df = pd.read_csv('student_data.csv', index_col=0)
print('Dataframe after removing unnamed columns:')
print(df)

Output:

Dataframe after removing unnamed columns:
      name         subject   fees
0     Arun           Maths   9000
1   Aniket  Social Science  12000
2   Ishits         English  15000
3  Pranjal         Science  18000
4  Vinayak        Computer  18000