Bug report
csv.Sniffer detects skipinitialspace by a simple rule: the spaces are a part of the format if every field which follows a delimiter starts with a space. It is wrong in both directions.
A space before a quoted field is not detected. A quote is only a quote at the very start of a field, so not skipping the space splits the field:
>>> sample = 'a, "b,c"\nd,e\nf,g\n'
>>> dialect = csv.Sniffer().sniff(sample)
>>> dialect.skipinitialspace
False
>>> list(csv.reader(io.StringIO(sample), dialect))
[['a', ' "b', 'c"'], ['d', 'e'], ['f', 'g']]
A space which cannot be skipped is counted as evidence. Spaces inside quoted or escaped fields are never skipped, so they say nothing about the padding:
>>> csv.Sniffer().sniff('a," b"\nc, d\n').skipinitialspace
True
>>> csv.Sniffer().sniff('a,\\ b\\,c\nd, e\n').skipinitialspace
TrueIn both samples the first field is not padded at all, so the sample gives evidence against the padding, not for it.
Linked PRs
Bug report
csv.Snifferdetectsskipinitialspaceby a simple rule: the spaces are a part of the format if every field which follows a delimiter starts with a space. It is wrong in both directions.A space before a quoted field is not detected. A quote is only a quote at the very start of a field, so not skipping the space splits the field:
A space which cannot be skipped is counted as evidence. Spaces inside quoted or escaped fields are never skipped, so they say nothing about the padding:
In both samples the first field is not padded at all, so the sample gives evidence against the padding, not for it.
Linked PRs