Steps to read CSV file without header in Python

CSV files widely used for storing datasets, can sometime have some challenges. Many a times header is not present in the data file, this can pose challenges in importing the file. It can result into importing the first row as header, which is not correct way to proceed. This article discusses easy steps to read CSV file without header in Python.

John has transaction data available for his customers in CSV format. The file has six columns. There is no header available in the file. He is looking forward to import the CSV file as Pandas Dataframe,

Below are the key steps to import CSV file.

• Step 1: Import necessary modules in Python.

import pandas as pd

• Step 2: Use read_csv function from Pandas to import csv file. Set header option as None. This ensures Python understands that header is not present in the file.

Trans_Data = pd.read_csv("C:\Website\LearnEasySteps\Python\Import CSV without Header\Transaction_Data_Apr2020.csv",\
                          header=None)

• Step 3: Check the output data quality to ensure if the file is correctly read.

Trans_Data.head()
Trans_Data.shape

Thus, John is able to import CSV file properly in Python which does not contains any header. This can be very helpful in situation where multiple files are present and no header is available. The file can be imported with the help of this process.

To get top certifications in Python and build your resume visit here. Also, you can read books listed here to build strong knowledge around Python.

Visit us below for video tutorial:

 Looking to practice more with this example? Drop us a note, we will email you the Code file: