When loading CSV data with pandas, the first line is mistaken for the title [duplicate]

Question

How to prevent the following? When I load a file with pd.read_csv(), the first line gets unwantedly treated as a header (list of column names):

import pandas as pd
data = pd.read_csv('namefile',sep=' ')
print(data)

and only the second line onwards gets treated as the data (vector = np.array(data)).

pd.read_csv(..., header=None) as the doc says. (See the doc for more complex or multiline headers) — smci
– smci, Commented Aug 29, 2019 at 22:14
Duplicate of Prevent pandas read_csv treating first row as header of column names and tons of others — smci
– smci, Commented Aug 29, 2019 at 22:32
See here for a cheatsheet of useful read_csv arguments you should know about. — cs95
– cs95, Commented Aug 30, 2019 at 1:05

Akshay Sapra · Accepted Answer · 2019-08-29 16:46:05Z

4

you can use the option of header to exclude columns data=pd.read_csv('namefile',sep=' ', header =None)

answered Aug 29, 2019 at 16:46

Akshay Sapra

5265 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1