Skip to content

Instantly share code, notes, and snippets.

@HintikkaKimmo
Created February 21, 2017 06:10
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save HintikkaKimmo/9336e2e56136f3e6b3a04b782ce33195 to your computer and use it in GitHub Desktop.
Save HintikkaKimmo/9336e2e56136f3e6b3a04b782ce33195 to your computer and use it in GitHub Desktop.
handy way to read csv files with unknown csv dialect
import csv
import pprint
# opens csv file and assingns it to an object
with open('data-text.csv') as csvfile:
# Use Sniffer to figure out csv dialect
dialect = csv.Sniffer().sniff(csvfile.read(1024))
csvfile.seek(0)
# pass the dialect to filereader to read the file
reader = csv.reader(csvfile, dialect)
# print(dialect)
# Use for loop to print csv row by row
for row in reader:
pprint.pprint(row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment