3 ms·
The analysis itself isn’t (usually) happening in Excel. A lot of tools operate on CSV files. People use Excel to peek at the results or prepare input for other
by mattkrause 6y ago
The analysis itself isn’t (usually) happening in Excel.
A lot of tools operate on CSV files. People use Excel to peek at the results or prepare input for other tools, and that’s how the date coercion slips in.
Sometimes, people do use it to collate the results of small manual experiments, where a database might be overkill. Even so, the data is usually analyzed elsewhere (R, graphPad, etc).
- imtringued 6y ago>A lot of tools operate on CSV files. The mistake was to believe that Excel can operate on CSV files. It doesn't support them in any meaningful way. It supports them in a "I can sort of pretend that I support CSV files" way.
- Arrath 6y agoWhat is a good alternative to working with CSV files than Excel? Excel sure isn't ideal but it's always there as part of the MS Office suite, so I've never looked for anything esle.