undefined | Better HN

0 pointsdanso1y ago0 comments

> Then there will be your data, but they will format currency values as prettified strings, for example "34 593,12 USD", instead of producing one column with a number and another with currency.

To be fair, that's not a problem with CSV but with the provider's lack of data literacy.

0 comments

remram1y ago

Yeah, you can also use Parquet/JSON/protobuf/XLSX and store numbers as strings in this format. CSV is just a container.

ahoka1y ago

But somehow CSV is the PHP of serialization formats, attracts the wrong kind of developers and projects.

remram1y ago

I definitely wouldn't say that. I saw a lot of weird stuff in Excel files, and there's the whole crowd only giving you data as PDFs.

j / k navigate · click thread line to collapse

0 pointsdanso1y ago0 comments

> Then there will be your data, but they will format currency values as prettified strings, for example "34 593,12 USD", instead of producing one column with a number and another with currency.

To be fair, that's not a problem with CSV but with the provider's lack of data literacy.

0 comments

remram1y ago

Yeah, you can also use Parquet/JSON/protobuf/XLSX and store numbers as strings in this format. CSV is just a container.

ahoka1y ago

But somehow CSV is the PHP of serialization formats, attracts the wrong kind of developers and projects.

remram1y ago

I definitely wouldn't say that. I saw a lot of weird stuff in Excel files, and there's the whole crowd only giving you data as PDFs.

j / k navigate · click thread line to collapse