using pandas.read_csv to read certain columns

Question

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))

EdChum · Accepted Answer · 2016-08-02 09:30:51Z

48

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

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

answered Aug 2, 2016 at 9:30

EdChum

397k204 gold badges836 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Not to add much to this answer, but of course, you can select various columns, as I did here: df = pd.read_csv( '.\\file.csv', usecols=[0,1,2,3,5])

Kenan · Accepted Answer · 2021-08-02 20:41:27Z

7

Adding on to @EdChum answer, you can also simply use range

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

to read the first 5 columns. If you columns aren't numeric you can always use header=None to have pandas ignore the columns

answered Aug 2, 2021 at 20:41

Kenan

14.2k9 gold badges47 silver badges56 bronze badges