4 ms·
It looks like this tool doesn't support semicolon-separated CSV files, quotes, or numbers using a comma as decimal separator. Too bad. It's a pity that the CSV
by jakobegger 11y ago
It looks like this tool doesn't support semicolon-separated CSV files, quotes, or numbers using a comma as decimal separator. Too bad.
It's a pity that the CSV file format is so fragmented. It's all too common that a CSV file written by tool A can't be read by tool B.
Only very few tools do it right. For example, I think the ruby CSV module has a heuristic to automatically detect the "style" of CSV files, which is pretty neat.
- john_kerl 11y agosemicolons etc you get with FS RS OS etc. number commas I can probably implement with locale; i'll look. and quotes are definitely to do. :)
- deleted 11y ago[deleted]
- gambiter 11y agoCSV stands for 'Comma-Separated Values', not 'Semicolon-Separated Values'. Seeing as this was downvoted, I'm just pointing out that bemoaning how the CSV format is fragmented and then using it incorrectly is the precise reason it is fragmented. It wasn't originally meant to be extended in so many ways, so there really isn't room to complain when a library doesn't magically figure out your personal delimiter or qualifier.
- im3w1l 11y agoAuto-detecting format sounds like a recipe for injection attacks.
- iampims 11y agoI found the pandas tests to be a great source for implementing robust CSV parsers: https://github.com/pydata/pandas/blob/master/pandas/io/tests/test_parsers.py https://github.com/pydata/pandas/blob/master/pandas/io/tests...