How to read Pandas csv file with no header

Question

I have a csv file that I am importing in my Python script using pandas. The csv file start with cell values and doesn’t contain headings. Pandas is considering the first row value as heading. How to read csv without heading?

Answer 1

You can set the header option to None to ignore header.

file = pd.read_csv('Diabetes.csv', header=1)

Comments

file = pd.read_csv('Diabetes.csv', header=None) 
We need to keep header as None instead of 1

Answer 2

Use this logic, if header is present but you don't want to read.

Using only header option, will either make header as data or one of the data as header. So, better to use it with skiprows, this will create default header (1,2,3,4..) and remove the actual header of file.

dfE_NoH = pd.read_csv('example.csv',header = 1)     

	42	Jason	Miller	25,000	4
0	52	Molly	Jacobson	94,000	24
1	36	Tina	.	57	31
2	24	Jake	Milner	62	.

dfE_NoH = pd.read_csv('example.csv',header = None)

	0	1	2	3	4
0	age	first_name	last_name	postTestScore	preTestScore
1	42	Jason	Miller	25,000	4
2	52	Molly	Jacobson	94,000	24
3	36	Tina	.	57	31

df = pd.read_csv('example.csv', skiprows = 1,header = None)   

	0	1	2	3	4
0	42	Jason	Miller	25,000	4
1	52	Molly	Jacobson	94,000	24
2	36	Tina	.	57	31
3	24	Jake	Milner	62	.

Answer 3

In order to read a csv in that doesn't have a header and for only certain columns you need to pass params header=None and usecols=[3,6] for the 4th and 7th columns:

df = pd.read_csv(file_path, header=None, usecols=[3,6])

Answer 4

Load CSV files to Python Pandas

1. # Load the Pandas libraries with alias 'pd'
2. import pandas as pd.
3. # Read data from file 'filename.csv'
4. # (in the same directory that your python process is based)
5. # Control delimiters, rows, column names with read_csv (see later)
6. data = pd. ...
7. # Preview the first 5 lines of the loaded data.

Answer 5

Reading in a .csv file into a Pandas DataFrame will by default, set the first row of the .csv file as the headers in the table. However, if the .csv file does not have any pre-existing headers, Pandas can skip this step and instead start reading the first row of the .csv as data entries into the data frame.

USE pandas.io.parsers.read_csv() TO READ IN A .csv FILE WITHOUT HEADERS

Call pandas.read_csv(file, header = None) with file set to the name of the .csv to be read into the DataFrame.

SAMPLE.CSV

1,2
3,4

df = pd.read_csv('sample.csv', header=None)

print(df)

OUTPUT

   0  1
0  1  2
1  3  4