Skip to content
Related Articles

Related Articles

Reading specific columns of a CSV file using Pandas
  • Last Updated : 24 Oct, 2020

Let us see how to read specific columns of a CSV file using Pandas. This can be done with the help of the pandas.read_csv() method. We will pass the first parameter as the CSV file and the second parameter the list of specific columns in the keyword usecols. It will return the data of the CSV file of specific columns.

Example 1: Link of the CSV file used: link

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# read specific columns of csv file using Pandas
df = pd.read_csv("student_scores2.csv", usecols = ['IQ','Scores'])
print(df)

chevron_right


Output 
 



Example 2: Link of the CSV file used: link
 

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
# read specific columns of csv file using Pandas 
df = pd.read_csv("student.csv", usecols = ['Hours','Scores','Pass'])
print(df)

chevron_right


Output 
 

Example 3: Link of the CSV file used: link

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# importing the module
import pandas as pd
  
 # read specific columns of csv file using Pandas
df = pd.read_csv("titanic.csv", usecols = ['Survived','Pclass'])
print(df)

chevron_right


Output:
 


Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :