this post was submitted on 09 Nov 2023
1748 points (99.2% liked)
Science Memes
11253 readers
5010 users here now
Welcome to c/science_memes @ Mander.xyz!
A place for majestic STEMLORD peacocking, as well as memes about the realities of working in a lab.
Rules
- Don't throw mud. Behave like an intellectual and remember the human.
- Keep it rooted (on topic).
- No spam.
- Infographics welcome, get schooled.
This is a science community. We use the Dawkins definition of meme.
Research Committee
Other Mander Communities
Science and Research
Biology and Life Sciences
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- !reptiles and [email protected]
Physical Sciences
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
- [email protected]
Humanities and Social Sciences
Practical and Applied Sciences
- !exercise-and [email protected]
- [email protected]
- !self [email protected]
- [email protected]
- [email protected]
- [email protected]
Memes
Miscellaneous
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
CSV isn't nightmarish, it is just a table structure in text form. You can open it with any text editor.
The problem is that it's not really a standard. It's reinvented ad-hoc by whomever programs it today.
Should there be any whitespace after the comma? Do you want to use pipes or some other character instead of commas (ASCII 0x1E is sitting over there for exactly this purpose, but it's been ignored for decades)? How do you handle escaping your separator char inside the dataset? Are you [CR] or [LF} or [CR] [LF]? None of these questions have a set answer. Even JSON has more specification than this.
Csv are easy to open in any spreadsheet software. You can even copy/paste it straight into some of them, e.g. LibreOffice Calc
Beware opening CSV in Excel. You will lose all your leading zeroes, among other "helpful" edits. Sometimes the leading zeroes are there for a reason!
Newest update to excel asks before applying default formatting and type conversion just as an FYI.