Daniel Dahms Daniel Dahms - 4 months ago 34
Python Question

using pandas.read_csv to read certain columns

I have a .csv file with three columns and many rows. I am trying to use pandas to read only the third column.

right now I have:

import pandas as pd

pd.read_csv(r"C:\test.csv",usecols=(3))

Answer

column indexing is zero based, pass 2 to read the third column:

pd.read_csv(r"C:\test.csv",usecols=[2])
Comments