This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author eric.smith
Recipients eric.smith, wy7305e
Date 2020-05-01.07:40:16
SpamBayes Score -1.0
Marked as misclassified Yes
Message-id <1588318816.96.0.224976432279.issue40463@roundup.psfhosted.org>
In-reply-to
Content
You should tell us what you're seeing, and what you're expecting.

I'm adding the rest of this not because it solves your problem, but because it might help you or someone else troubleshoot this further.

Here's a simpler reproducer:

import csv
lst = ['"A,"h"e, ","E","DC"']

csv_list = csv.reader(lst)
for idx, col in enumerate(next(csv_list)):
    print(idx, repr(col))

Which produces:
0 'A,h"e'
1 ' "'
2 'E'
3 'DC'

Although true to its word, this is using the default dialect='excel', and my version of Excel gives these same 4 columns, including the space starting the second column.

Dropping the space after the "e," gives 3 columns:

lst = ['"A,"h"e,","E","DC"']

Produces:
0 'A,h"e'
1 ',E"'
2 'DC'

Again, this is exactly what Excel gives, as odd as it seems.

It might be worth playing around with the dialect parameters to see if you can achieve what you want. In your example:
delimiter=',', quotechar='"'
are the default values for the "excel" dialect, which is why I dropped them above.
History
Date User Action Args
2020-05-01 07:40:17eric.smithsetrecipients: + eric.smith, wy7305e
2020-05-01 07:40:16eric.smithsetmessageid: <1588318816.96.0.224976432279.issue40463@roundup.psfhosted.org>
2020-05-01 07:40:16eric.smithlinkissue40463 messages
2020-05-01 07:40:16eric.smithcreate