Exclude first row when importing data from excel into Python

Question

I have a partial code to import excel into Python as strings. How I can exclude first row when importing data from excel into Python?

import pandas as pd
data = pd.read_excel(".xlsx", parse_cols="A,C,E,G, I, K, M, O, Q, S, U, W, Y, AA, AC, AE, AG, AI, AK, AM, AO, AQ, AS, AU, AW, AY, BA, BC, BE, BG, BI, BK, BM, BO, BQ, BS, BU, BW, BY, CA, CC, CE, CG, CI, CK, CM, CO, CQ, CS, CU, CW, CY, DA, DC, DE, DG, DI, DK, DM, DO, DQ, DS, DU, DW, DY, EA, EC, DE, EG, EI, EK, EM, EO, EQ, ES, EU, EW, EY")
data = data.to_string()

Answer 1

The pandas documentation for the pd.read_excel method mentions a skiprows parameter that you can use to exclude the first row of your excel file.

Example

import pandas as pd
data = pd.read_excel("file.xlsx", parse_cols="A,C,E,G", skiprows=[0])

Source: pandas docs

Answer 2

for read_excel function assign value to skiprows argument. it will ignore the header

Answer 3

parse_cols argument is deprecated since version 0.21.0. Instead you should use usecols:

usecols : int or list, default None

• If None then parse all columns, If int then indicates last column to
• be parsed If list of ints then indicates list of column numbers to be
• parsed If string 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.

To exclude first row use skiprows=[0] argument.