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

  1. Don't throw mud. Behave like an intellectual and remember the human.
  2. Keep it rooted (on topic).
  3. No spam.
  4. 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

Physical Sciences

Humanities and Social Sciences

Practical and Applied Sciences

Memes

Miscellaneous

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 34 points 1 year ago (1 children)

CSV isn't nightmarish, it is just a table structure in text form. You can open it with any text editor.

[โ€“] [email protected] 8 points 1 year ago* (last edited 1 year ago)

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.