Exclude first row when importing data from excel into Python

python pandas import-from-excel
Nguyen picture Nguyen · Aug 26, 2017 · Viewed 24.4k times · Source

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

Onel Harrison picture Onel Harrison · Aug 26, 2017

The pandas documentation for the pd.read_excel method mentions a skiprows parameter that you can use 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

Related questions

Faster way to read Excel files to pandas dataframe

I have a 14MB Excel file with five worksheets that I'm reading into a Pandas dataframe, and although the code below works, it takes 9 minutes! Does anyone have suggestions for speeding it up? import pandas as pd def OTT_read(…

Read More
Pandas importing CSV and Excel file error

I am trying to use Python Pandas to import a CSV file. The example data in this file is as follows where the first row is the column names separated by commas. End Customer Organization ID,End Customer Organization Name,…

Read More
Pandas.read_excel reads date into timestamp, I want a string

I read a large Excel file into pandas using .read_excel, and the file has date columns. When read into pandas, the dates default to a timestamp. Since the file is large, I would like to read the dates as …

Read More