this post was submitted on 09 Nov 2023
1827 points (99.2% liked)

Science Memes

10348 readers
1881 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.


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] 33 points 10 months 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] 9 points 10 months ago* (last edited 10 months 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.