Skip to content

Instantly share code, notes, and snippets.

@cpkthompson

cpkthompson/open_csv.py

Forked from dokterbob/open_csv.py
Created October 4, 2017 21:58
Show Gist options
  • Save cpkthompson/0264a00fa3de9d81b5b2431a42ab8562 to your computer and use it in GitHub Desktop.
Save cpkthompson/0264a00fa3de9d81b5b2431a42ab8562 to your computer and use it in GitHub Desktop.
Download ZIP
Python dialect-sniffing CSV reader example.
Raw
open_csv.py
import csv
sniff_range = 4096
delimiters = ';\t,'
infile_name = 'blabla.csv'
sniffer = csv.Sniffer()
print 'Reading file: %s' % infile_name
with open(infile_name, 'r') as infile:
# Determine dialect
dialect = sniffer.sniff(
infile.read(sniff_range), delimiters=delimiters
)
infile.seek(0)
# Sniff for header
has_header = sniffer.has_header(infile.read(sniff_range))
infile.seek(0)
reader = csv.reader(infile, dialect)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment