Before importing anything, look at it:
Shell
head -5 sales.csv # the first rows — is there a header?
wc -l sales.csv # how many rows am I dealing with?
cut -d, -f1,3 sales.csv | head # just the columns I care about
Thirty seconds of head answers the questions that otherwise become
import errors: delimiter, header row, quoting, encoding surprises.