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
# importing the moduleimport pandas as pd  # read specific columns of csv file using Pandasdf = pd.read_csv("student_scores2.csv", usecols = ['IQ','Scores'])print(df) |
OutputÂ
Â
Example 2: Link of the CSV file used: link
Â
Python3
# importing the moduleimport pandas as pd  # read specific columns of csv file using Pandas df = pd.read_csv("student.csv", usecols = ['Hours','Scores','Pass'])print(df) |
OutputÂ
Â
Example 3: Link of the CSV file used: link
Python3
# importing the moduleimport pandas as pd   # read specific columns of csv file using Pandasdf = pd.read_csv("titanic.csv", usecols = ['Survived','Pclass'])print(df) |
Output:
Â
… [Trackback]
[…] Info on that Topic: geeksforgeeks.org/reading-specific-columns-of-a-csv-file-using-pandas/ […]