Check CSV file for a header row, and detect the dialect.

csv_check.py

import csv

input_csv_file = '/path/to/test_csvfile.csv'

with open(input_csv_file, 'rb') as csvfile: #`with open(input_csv_file, 'r') as csvfile:` for Python 3
    csv_test_bytes = csvfile.read(1024)  # Grab a sample of the CSV for format detection.
    csvfile.seek(0)  # Rewind
    has_header = csv.Sniffer().has_header(csv_test_bytes)  # Check to see if there's a header in the file.
    dialect = csv.Sniffer().sniff(csv_test_bytes)  # Check what kind of csv/tsv file we have.
    inputreader = csv.reader(csvfile, dialect)
    if has_header:
        next(inputreader) # Skip the header if we have one.
    for row in inputreader:
        print(row)

Thank you! So much!

Thank you! 😊

Glad this helped!