Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Automatic loading of tab- and ;- delimited files #10

Open
mkborregaard opened this issue Sep 12, 2017 · 3 comments
Open

Automatic loading of tab- and ;- delimited files #10

mkborregaard opened this issue Sep 12, 2017 · 3 comments

Comments

@mkborregaard
Copy link

mkborregaard commented Sep 12, 2017

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:
skaermbillede 2017-09-12 kl 07 58 39
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.

@davidanthoff
Copy link
Member

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?

@mkborregaard
Copy link
Author

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.

@davidanthoff
Copy link
Member

#11

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants