queryverse
Automatic loading of tab- and ;- delimited files
DataFrames support loading tab-delimited files and semicolon-delimited files automatically by file extension (e.g. .tsv). Is something like that possible?
The issues is that comma-delimited files, though apparently the default format in Julia, are more or less restricted to countries with decimal points, i.e. the English-speaking countries:
In countries where the comma is the decimal separator, semicolon-delimited values are saved automatically in programs like Excel when specifying the csv format. I can't believe the guys who came up with that thought that might be a good idea, but there you are.
I feel your pain, my solution to it was to just move to the US a couple of years ago ;)
We can definitely register more file extensions and associate a default separator for each. Besides the .tsv extension, what else would make sense?
That's a remarkably radical solution, but desperate situations require desperate measures of course :-) DataFrames support tsv for tab-separated and wsv for space-separated. In the old days prn was often used for space-separated but it's been a while since I last saw a prn file. There seems to be a convention to use csv2 to indicate csv files in the European style, but I've never seen it used as a file extension TBH.