Search code examples
pythonpandascsvreadfile

Skip rows during csv import pandas


I'm trying to import a .csv file using pandas.read_csv(), however, I don't want to import the 2nd row of the data file (the row with index = 1 for 0-indexing).

I can't see how not to import it because the arguments used with the command seem ambiguous:

From the pandas website:

skiprows : list-like or integer

Row numbers to skip (0-indexed) or number of rows to skip (int) at the start of the file."

If I put skiprows=1 in the arguments, how does it know whether to skip the first row or skip the row with index 1?


Solution

  • You can try yourself:

    >>> import pandas as pd
    >>> from io import StringIO
    >>> s = """1, 2
    ... 3, 4
    ... 5, 6"""
    >>> pd.read_csv(StringIO(s), skiprows=[1], header=None)
       0  1
    0  1  2
    1  5  6
    >>> pd.read_csv(StringIO(s), skiprows=1, header=None)
       0  1
    0  3  4
    1  5  6