How to read csv file with Pandas without header?

October 23, 2021October 23, 2021 User HandleUser Handle

How to read csv file with Pandas without header?

A header of the CSV file is an array of values assigned to each of the columns. It acts as a row header for the data. This article discusses how we can read a csv file without header using pandas. To do this header attribute should be set to None while reading the file.

Syntax:

read_csv(“file name”, header=None)

Approach

  • Import module
  • Read file
  • Set header to None
  • Display data

Let us first see how data is displayed with headers, to make difference crystal clear.

Data file used:

Example1: 

# importing python package
import pandas as pd
 
# read the contents of csv file
dataset = pd.read_csv("file.csv")
 
# display the modified result
display(dataset)

Output:

Now let us see the implementation without headers.

Example 2:

# importing python package
import pandas as pd
 
# read the contents of csv file
dataset = pd.read_csv("file.csv", header=None)
 
# display the modified result
display(dataset)

Output:

Example 3:

# importing python package
import pandas as pd
 
# read the content of csv file
dataset = pd.read_csv("sample1.csv", header=None)
 
# display modified csv file
display(dataset)

Output:

 

Last Updated on October 23, 2021 by admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Recommended Blogs

Merge two Pandas DataFrames on certain columnsMerge two Pandas DataFrames on certain columns

October 21, 2021October 21, 2021 User HandleUser Handle

Merge two Pandas DataFrames on certain columns We can merge two Pandas DataFrames on certain columns using the merge function by simply specifying the certain columns for merge. Syntax: DataFrame.merge(right, how=’inner’, on=None, left_on=None, right_on=None, left_index=False, right_index=False, sort=False, copy=True, indicator=False, validate=None) Example1: Let’s

Read FullRead Full