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

Specify the separator #1

Open
magoorden opened this issue May 9, 2022 · 1 comment
Open

Specify the separator #1

magoorden opened this issue May 9, 2022 · 1 comment

Comments

@magoorden
Copy link

Currently, I guess, anything that is not a digit or a . is considered to be a column separator. It would be nice to specify what the column separator is for a particular file.

For example, I have a data file that looks like

0	10/05/2021	17:00:00	28.047283641646498	28.229890823364258	0.16600261628627777
1	10/05/2021	17:05:00	27.85280887167062	28.241891860961914	0.16254563629627228
2	10/05/2021	17:10:00	27.988941210653625	28.097787857055664	0.13076160848140717
3	10/05/2021	17:15:00	27.891703825665818	27.795202255249023	0.1424412727355957
....

where the actual columns are separated by the tab character. Right now, the library interprets the tab, /, and : as column separators. So the last column can be retrieved using column index 9, while intuitively (i.e., when you can specify that the tab is the separator) it has column index 5.

@mikucionisaau
Copy link
Member

The major issue is that the library is expecting a table with numbers and anything else ruins the formatting.

In principle, the dates and times should be quoted as text strings.

Not sure how to treat the text in columns.

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

No branches or pull requests

2 participants