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

  • Select an option

    Learn more about clone URLs
  • Save cpkthompson/0264a00fa3de9d81b5b2431a42ab8562 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cpkthompson/0264a00fa3de9d81b5b2431a42ab8562 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @dokterbob dokterbob created this gist Nov 10, 2014.
    23 changes: 23 additions & 0 deletions open_csv.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,23 @@
    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)