BUG in read_csv skipping a row after a row with trailing spaces · Issue #8983 · pandas-dev/pandas (original) (raw)
as reported by @xdliao in #8752, skipping a row after a row with trailing spaces fails to create the expected dataframe
data = """A B C \nD E F \nH I J \n1 2 3 \n4 5 6 \n"""
pd.read_csv(StringIO(data), skiprows=2, delim_whitespace=True) and
pd.read_csv(StringIO(data), skiprows=[0,1], delim_whitespace=True) work as expected, but the dataframes returned by
pd.read_csv(StringIO(data), skiprows=[0,2], delim_whitespace=True) and
pd.read_csv(StringIO(data), skiprows=[1,2], delim_whitespace=True) are incorrect