Dec-11-2018, 06:01 AM
If the file is tab-separated, you can try
dialect=csv.excel_tab
in the call to csv.reader()
. If the values are merely separated by space characters, you can define your own dialectclass MyDialect(csv.Dialect): delimiter = ' ' doublequote = True lineterminator = '\r\n' quotechar = '"' quoting = csv.MINIMAL skipinitialspace = FalseThen use
dialect=MyDialect
in csv.reader()
until it reads ['Column_2', 'Number(10, 2)']