how to read certain columns from Excel using Pandas - Python

Question

I am reading from an Excel sheet and I want to read certain columns  column 0 because it is the row-index  and columns 22 37  Now here is what I do   import pandas as pd import numpy as np file loc    path xlsx  df   pd read excel file loc  index col None  na values   NA    parse cols   37  df  pd concat  df df columns 0    df df columns 22      axis 1    But I would hope there is better way to do that  I know if I do parse cols  0  22    37  I can do it  but for large datasets this doesn t make sense   I also did this   s   pd Series 0  s 1  22 for i in range 2 14       s i  s i-1  1 df   pd read excel file loc  index col None  na values   NA    parse cols   s    But it reads the first 15 columns which is the length of s

User · Answer

parse cols is deprecated  use usecols instead  that is    df   pd read excel file loc  index col None  na values   NA    usecols    A C AA

User · Answer

You can use column indices  letters  like this   import pandas as pd import numpy as np file loc    path xlsx  df   pd read excel file loc  index col None  na values   NA    usecols    A C AA   print df     Corresponding documentation  1       usecolsint  str  list-like  or callable default None         If None  then parse all columns    If str  then indicates comma separated list of Excel column letters and column ranges  e g     A E    or    A C E F      Ranges are inclusive of both sides    If list of int  then indicates list of column numbers to be parsed    If list of string  then indicates list of column names to be parsed       New in version 0 24 0    If callable  then evaluate each column name against it and parse the column if the callable returns True          Returns a subset of the columns according to behavior above       New in version 0 24 0

User · Answer

usecols  should help  use range of columns  as per excel worksheet  A B   etc   below are the examples   Selected Columns   df   pd read excel file location sheet name  Sheet1   usecols  A C F      Range of Columns and selected column   df   pd read excel file location sheet name  Sheet1   usecols  A F H      Multiple Ranges   df   pd read excel file location sheet name  Sheet1   usecols  A F H J N      Range of columns   df   pd read excel file location sheet name  Sheet1   usecols  A N

[python] how to read certain columns from Excel using Pandas - Python

Examples related to python

Examples related to numpy

Examples related to pandas

Examples related to dataframe